pixiEmillGetItemCategories · Pixi API documentation

Returns the complete list of item categories (Artikelkategorien) from the table TontrArten.

The call takes no parameters and applies no filter.
Each row contains the category ID (ArtCategory) and its description (ArtCategoryDescription).
Rows are sorted alphabetically by description.

The call is part of the eMill integration (tag Tech_eMill).

Notes

The table is read with NOLOCK, so uncommitted changes may be visible. Column data types are not visible in the code and are therefore marked as unknown.

Tables used

TontrArten · Read

This call has no parameters.

Result set 1 · Always

One row per item category, sorted by description.

Column	Type	Description
`ArtCategory`	string	Item category ID (`TontrArt`).
`ArtCategoryDescription` Nullable	string	Description of the item category (`TontrText`).

Response example

<SqlRowSet1>
  <row>
    <ArtCategory>BU</ArtCategory>
    <ArtCategoryDescription>Bücher</ArtCategoryDescription>
  </row>
  <row>
    <ArtCategory>EL</ArtCategory>
    <ArtCategoryDescription>Elektronik</ArtCategoryDescription>
  </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:pixiEmillGetItemCategories/>
  </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:pixiEmillGetItemCategories/>
  </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 = [
];

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

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