pixiGetEanByItemNr · Pixi API documentation

Scalar function that looks up the item in Items whose ItemNrInt equals ItemNrInt and returns its EANUPC value.

If no item matches, the result is NULL.
If EANUPC is empty or NULL for the item, that value is returned as is.

Notes

The table is read with NOLOCK, so uncommitted changes may be returned.
The return type is varchar(13); longer values in EANUPC would be truncated to 13 characters.
If several rows had the same ItemNrInt, the value of one of them would be returned without defined order.

Tables used

Items · Read

Parameter	Type	Default	Description
`ItemNrInt` Required	varchar(50) string	–	Internal item number (`ItemNrInt`) of the item whose EAN is requested. Example: `10001234`

Result set 1 · Always

Single value with the EAN/UPC code of the item, or NULL if the item is not found.

Column	Type	Description
`Ean` Nullable	varchar(13) string	EAN/UPC code from `Items.EANUPC`.

Response example

<SqlRowSet1>
  <row>
    <Ean>4012345678901</Ean>
  </row>
</SqlRowSet1>

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
Authorization: Basic BASE64(USERNAME:PASSWORD)

<?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/">
  <SOAP-ENV:Body>
    <ns1:pixiGetEanByItemNr>
      <ItemNrInt>10001234</ItemNrInt>
    </ns1:pixiGetEanByItemNr>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

curl -X POST 'https://apigateway.descartes.com/tms/pixi/' \
  --user 'USERNAME:PASSWORD' \
  --header 'Content-Type: text/xml; charset=utf-8' \
  --data-binary @- <<'XML'
<?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/">
  <SOAP-ENV:Body>
    <ns1:pixiGetEanByItemNr>
      <ItemNrInt>10001234</ItemNrInt>
    </ns1:pixiGetEanByItemNr>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
XML

<?php

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

$arguments = [
    'ItemNrInt' => '10001234',
];

$soapArguments = [];
foreach ($arguments as $name => $value) {
    $soapArguments[] = new SoapVar($value, XSD_STRING, '', '', $name);
}

$response = $soapClient->__soapCall('pixiGetEanByItemNr', $soapArguments);