pixiSatisfiedCustomers

API call to return times since last delivery and order.

Since pixi version: LOU Official (6.3.0.4452) Additional notes:

Customers

Request

POST https://apigateway.descartes.com/tms/pixi/pixiSatisfiedCustomers

Request body

Name	Type	Required	Description
NoOrderSince	boolean	false	NoOrderSince. Type: bit Default value: 0 Example: 0 Available from: LOU Official - Update 46 (6.9.46.27927)
MaxDaysSinceOrder	integer	false	Days sice last order for customer. Type: int Default value: NULL Example: 123 Available from: LOU Official (6.3.0.4452)
MinDaysSinceOrder	integer	false	Days sice last order for customer. Type: int Default value: NULL Example: 123 Available from: LOU Official (6.3.0.4452)
CustomerNrExternal	string	false	Customer number. Used to identify the customer. Type: varchar(60) Default value: NULL Example: abcdef Available from: LOU Official (6.3.0.4452)
MaxDaysSinceDelivery	integer	false	Days sice last delivery for customer. Type: int Default value: NULL Example: 123 Available from: LOU Official (6.3.0.4452)
MinDaysSinceDelivery	integer	false	Days sice last delivery for customer. Type: int Default value: NULL Example: 123 Available from: LOU Official (6.3.0.4452)
ExcludePartialDeliveries	boolean	false	Exclude partial deliveries from results. Type: bit Default value: 0 Example: 0 Available from: LOU Official (6.3.0.4452)

Request Example

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Body xmlns="">
    <pixiSatisfiedCustomers>
      <MaxDaysSinceDelivery>0</MaxDaysSinceDelivery>
      <MinDaysSinceDelivery>0</MinDaysSinceDelivery>
      <MaxDaysSinceOrder>0</MaxDaysSinceOrder>
      <MinDaysSinceOrder>0</MinDaysSinceOrder>
      <CustomerNrExternal>string</CustomerNrExternal>
      <ExcludePartialDeliveries>true</ExcludePartialDeliveries>
      <NoOrderSince>true</NoOrderSince>
    </pixiSatisfiedCustomers>
  </Body>
</Envelope>

Response

1. Picklist data

Name	Type	Description
Name	string	Name Type: varchar Available from: 25.06 (25.6.0.58802)
email	string	email Type: varchar Available from: 25.06 (25.6.0.58802)
Anrede	string	Anrede Type: varchar Available from: 25.06 (25.6.0.58802)
ShopID	string	ShopID Type: varchar Available from: 25.06 (25.6.0.58802)
ItemQty	integer	ItemQty Type: int Available from: 25.06 (25.6.0.58802)
ItemText	string	ItemText Type: varchar Available from: 25.06 (25.6.0.58802)
InvoiceNr	string	InvoiceNr Type: varchar Available from: 25.06 (25.6.0.58802)
ItemPrice	number	ItemPrice Type: money Available from: 25.06 (25.6.0.58802)
InvoiceKey	integer	InvoiceKey Type: int Available from: 25.06 (25.6.0.58802)
ItemNrShop	string	ItemNrShop Type: varchar Available from: 25.06 (25.6.0.58802)
FirstOrderDate	string	FirstOrderDate Type: datetime Available from: 25.06 (25.6.0.58802)
LastDeliveryDate	string	LastDeliveryDate Type: datetime Available from: 25.06 (25.6.0.58802)
CustomerNRExternal	string	CustomerNRExternal Type: varchar Available from: 25.06 (25.6.0.58802)

Response Example

<PixiSatisfiedCustomersPost200TextXmlResponse>
  <InvoiceNr>string</InvoiceNr>
  <InvoiceKey>0</InvoiceKey>
  <CustomerNRExternal>string</CustomerNRExternal>
  <ShopID>string</ShopID>
  <Anrede>string</Anrede>
  <Name>string</Name>
  <email>string</email>
  <LastDeliveryDate>string</LastDeliveryDate>
  <FirstOrderDate>string</FirstOrderDate>
  <ItemText>string</ItemText>
  <ItemQty>0</ItemQty>
  <ItemNrShop>string</ItemNrShop>
  <ItemPrice>0</ItemPrice>
</PixiSatisfiedCustomersPost200TextXmlResponse>

HTTP Example

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
# echo -n '{{username}}:{{password}}' | base64 | pbcopy
Authorization: Basic {{token}}

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
                   xmlns:ns1="https://apigateway.descartes.com/tms/pixi/"
                   xmlns:xsd="http://www.w3.org/2001/XMLSchema"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <SOAP-ENV:Body>
        <ns1:pixiSatisfiedCustomers>
            <NoOrderSince xsi:type="xsd:boolean">0</NoOrderSince>
            <MaxDaysSinceOrder xsi:type="xsd:integer">123</MaxDaysSinceOrder>
            <MinDaysSinceOrder xsi:type="xsd:integer">123</MinDaysSinceOrder>
            <CustomerNrExternal xsi:type="xsd:string">abcdef</CustomerNrExternal>
            <MaxDaysSinceDelivery xsi:type="xsd:integer">123</MaxDaysSinceDelivery>
            <MinDaysSinceDelivery xsi:type="xsd:integer">123</MinDaysSinceDelivery>
            <ExcludePartialDeliveries xsi:type="xsd:boolean">0</ExcludePartialDeliveries>
        </ns1:pixiSatisfiedCustomers>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

PHP Example

<?php

getPixiSoapClientResponse('pixiSatisfiedCustomers', [
    'NoOrderSince' => '0', // boolean
    'MaxDaysSinceOrder' => '123', // integer
    'MinDaysSinceOrder' => '123', // integer
    'CustomerNrExternal' => 'abcdef', // string
    'MaxDaysSinceDelivery' => '123', // integer
    'MinDaysSinceDelivery' => '123', // integer
    'ExcludePartialDeliveries' => '0', // boolean
]);

function getPixiSoapClientResponse(string $method, array $arguments = [])
{
    $soapArguments = [];
    foreach ($arguments as $key => $value) {
        $soapArguments[] = new SoapVar($value, null, '', '', $key);
    }

    $soapClient = new SoapClient(null, [
        'login' => '...',
        'password' => '...',
        'uri' => 'https://apigateway.descartes.com/tms/pixi/',
        'location' => 'https://apigateway.descartes.com/tms/pixi/',
    ]);

    return $soapClient->__call($method, $soapArguments);
}

Unofficial Pixi-API-Documentation

by koempf24.de