Customs Read

pixiReportItemsWithMissingCustomsInfo

Returns items that are not yet tagged with the system tag `AtlasData`, including master data and customs fields, paged by `ItemKey`.

Lists items whose customs information has not been marked as complete yet.

The ID of the system tag AtlasData (tag type 1, IsSystemTag = 1) is looked up in Tag.
All items that have no assignment of this tag in TagMatch are selected.
Only items with ItemKey greater than ItemKeyStart are returned.
The result is sorted by ItemKey ascending and limited to Rowcount rows.

For each item the call returns master data (name, supplier, numbers, EAN, sales price, VAT level, weight and dimensions), all assigned item tags as a pipe-separated string, the ABC classification and the current customs fields (tariff number, country of origin with ISO2 code, tariff text, previous process).

Paging: pass the highest ItemKey of the previous page as ItemKeyStart to get the next page. Start with 0.

Notes

"Missing customs info" is defined only by the absence of the AtlasData tag. The customs columns of returned items may already be filled; items with empty customs fields are not returned if they carry the tag.
If the system tag AtlasData does not exist, the tag ID is NULL, the NOT EXISTS check never matches and all items (above ItemKeyStart) are returned.
The row limit uses SET ROWCOUNT; Rowcount = 0 removes the limit.
Inactive items are included; check the Enabled column.
All reads use NOLOCK, so uncommitted data may appear.
ItemTAGs and ABC are computed per row by scalar functions, which can be slow for large pages.
The column Heigth is spelled as in the database.

Tables used

Tag · Read TagMatch · Read items · Read Countries · Read

Parameter	Type	Default	Description
`Rowcount`	int	1000	Maximum number of rows returned (page size). `0` means no limit. Example: `500`
`ItemKeyStart`	int	0	Only items with `ItemKey` greater than this value are returned. Use the last `ItemKey` of the previous page for paging. Example: `0`

Result set 1 · Always (may be empty)

Items without the AtlasData tag, sorted by ItemKey.

Column	Type	Description
`ItemKey`	int	Internal item key.
`ItemName` Nullable	string	Item name.
`SupplNR` Nullable	string	Supplier number of the item (`SupplNr`).
`ItemNrInt` Nullable	string	Internal item number.
`EANUPC` Nullable	string	EAN/UPC barcode.
`ItemNrSuppl`	string	Supplier item number; empty string if not set.
`PriceVK` Nullable	decimal	Sales price (`Price`).
`VATLevel`	varchar(9) string	VAT level derived from `MwStSatz`: `MwSt_Low` (2), `MwSt_Null` (3), otherwise `MwSt_High`.
`Enabled` Nullable	boolean	Whether the item is active.
`ItemTAGs` Nullable	varchar(8000) string	All tag names assigned to the item, sorted by name and separated by `\|`; `NULL` if none.
`Weight` Nullable	decimal	Item weight.
`Heigth` Nullable	decimal	Item height (column name spelled as in the database).
`Width` Nullable	decimal	Item width.
`Length` Nullable	decimal	Item length.
`ABC` Nullable	char(1) string	ABC classification from the tags `A`, `B` or `C` (first match in this order); empty if none.
`CustomsTariffNumber` Nullable	string	Customs tariff number.
`CustomsCountryOfOrigin` Nullable	string	Country of origin code as stored on the item (`CntCode`).
`CustomsCountryOfOriginISO2` Nullable	string	ISO2 code of the country of origin from `Countries`; `NULL` if no matching country.
`CustomsTariffText` Nullable	string	Customs tariff description.
`CustomsPreviousProcess` Nullable	string	Previous customs process.

Response example

<SqlRowSet1>
  <row>
    <ItemKey>1042</ItemKey>
    <ItemName>Steel Water Bottle 750ml</ItemName>
    <SupplNR>17</SupplNR>
    <ItemNrInt>WB-750-BLK</ItemNrInt>
    <EANUPC>4006381333931</EANUPC>
    <ItemNrSuppl>SUP-88213</ItemNrSuppl>
    <PriceVK>19.9900</PriceVK>
    <VATLevel>MwSt_High</VATLevel>
    <Enabled>1</Enabled>
    <ItemTAGs>A|Outdoor</ItemTAGs>
    <Weight>0.35</Weight>
    <Heigth>26</Heigth>
    <Width>7</Width>
    <Length>7</Length>
    <ABC>A</ABC>
    <CustomsTariffNumber>73239300</CustomsTariffNumber>
    <CustomsCountryOfOrigin>CN</CustomsCountryOfOrigin>
    <CustomsCountryOfOriginISO2>CN</CustomsCountryOfOriginISO2>
    <CustomsTariffText>Haushaltsartikel aus nichtrostendem Stahl</CustomsTariffText>
    <CustomsPreviousProcess/>
  </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:pixiReportItemsWithMissingCustomsInfo>
      <!-- <Rowcount>500</Rowcount> -->
      <!-- <ItemKeyStart>0</ItemKeyStart> -->
    </ns1:pixiReportItemsWithMissingCustomsInfo>
  </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:pixiReportItemsWithMissingCustomsInfo>
      <!-- <Rowcount>500</Rowcount> -->
      <!-- <ItemKeyStart>0</ItemKeyStart> -->
    </ns1:pixiReportItemsWithMissingCustomsInfo>
  </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 = [
    // 'Rowcount' => '500',
    // 'ItemKeyStart' => '0',
];

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

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

SQL object:: dbo.pipiReportItemsWithMissingCustomsInfo