pixiGetCRMCustomerData
Get Customer Data with safe XML values for CRM systems.
Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:
Request
Request body
Name | Type | Required | Description |
---|---|---|---|
Rows | integer | false | Rows Type: int Default value: 1000 Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
CustomerOf | string | false | Customer Of Type: varchar(3) Default value: Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
CustKeyStart | integer | false | Customer Id Start Type: int Default value: 0 Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiGetCRMCustomerData>
<CustKeyStart>0</CustKeyStart>
<Rows>0</Rows>
<CustomerOf>string</CustomerOf>
</pixiGetCRMCustomerData>
</Body>
</Envelope>
Response
1. Result set
Name | Type | Description |
---|---|---|
Fax | string | Fax Type: varchar Available from: 25.06 (25.6.0.58802) |
ZIP | string | ZIP Type: varchar Available from: 25.06 (25.6.0.58802) |
City | string | City Type: varchar Available from: 25.06 (25.6.0.58802) |
Name | string | Name Type: varchar Available from: 25.06 (25.6.0.58802) |
Name2 | string | Name 2 Type: varchar Available from: 25.06 (25.6.0.58802) |
Phone | string | Phone Type: varchar Available from: 25.06 (25.6.0.58802) |
State | string | State Type: varchar Available from: 25.06 (25.6.0.58802) |
VATID | string | VATID Type: varchar Available from: 25.06 (25.6.0.58802) |
string | Type: varchar Available from: 25.06 (25.6.0.58802) |
|
Anrede | string | Anrede Type: varchar Available from: 25.06 (25.6.0.58802) |
CareOf | string | Care Of Type: varchar Available from: 25.06 (25.6.0.58802) |
Locked | string | Locked Type: varchar Available from: 25.06 (25.6.0.58802) |
Street | string | Street Type: varchar Available from: 25.06 (25.6.0.58802) |
Address | string | Address Type: varchar Available from: 25.06 (25.6.0.58802) |
Country | string | Country Type: varchar Available from: 25.06 (25.6.0.58802) |
CustKey | integer | Customer Id Type: int Available from: 25.06 (25.6.0.58802) |
HouseNr | string | House Nr Type: varchar Available from: 25.06 (25.6.0.58802) |
LastName | string | Last Name Type: varchar Available from: 25.06 (25.6.0.58802) |
BirthDate | string | Birth Date Type: datetime Available from: 25.06 (25.6.0.58802) |
FirstName | string | First Name Type: varchar Available from: 25.06 (25.6.0.58802) |
CustomerOf | string | Customer Of Type: varchar Available from: 25.06 (25.6.0.58802) |
CustomerNrExternal | string | Customer Nr External Type: varchar Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiGetCRMCustomerDataPost200TextXmlResponse>
<CustKey>0</CustKey>
<CustomerNrExternal>string</CustomerNrExternal>
<CustomerOf>string</CustomerOf>
<Anrede>string</Anrede>
<Name>string</Name>
<Name2>string</Name2>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Street>string</Street>
<HouseNr>string</HouseNr>
<Address>string</Address>
<ZIP>string</ZIP>
<City>string</City>
<State>string</State>
<Country>string</Country>
<eMail>string</eMail>
<Phone>string</Phone>
<Fax>string</Fax>
<VATID>string</VATID>
<Locked>string</Locked>
<BirthDate>string</BirthDate>
<CareOf>string</CareOf>
</PixiGetCRMCustomerDataPost200TextXmlResponse>
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:pixiGetCRMCustomerData>
<Rows xsi:type="xsd:integer"></Rows>
<CustomerOf xsi:type="xsd:string"></CustomerOf>
<CustKeyStart xsi:type="xsd:integer"></CustKeyStart>
</ns1:pixiGetCRMCustomerData>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
PHP Example
<?php
getPixiSoapClientResponse('pixiGetCRMCustomerData', [
'Rows' => '', // integer
'CustomerOf' => '', // string
'CustKeyStart' => '', // integer
]);
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);
}