pixi Developer & Integration Documentation

pixiGetHistoricalSupplierPriceMatching

Warning: API call is no longer maintained!

Description

API call returns historical supplier prices for items.


Request Parameters

# Name Type Required Example Description
1 ItemKey integer 0 12345 Filter: ItemID
2 DateFrom string 1 YYYY-MM-DD Filter: Begining of the date range peroid.
3 DateTo string 1 YYYY-MM-DD Filter: End of the date range peroid

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiGetHistoricalSupplierPriceMatching>
         <dem:ItemKey>12345</dem:ItemKey>
         <dem:DateFrom>YYYY-MM-DD</dem:DateFrom>
         <dem:DateTo>YYYY-MM-DD</dem:DateTo>
      </dem:pixiGetHistoricalSupplierPriceMatching>
   </soapenv:Body>
</soapenv:Envelope>

Response


Body 1: Historical supplier prices of items and coresponding selling price match.

# Name Type Description
1 ItemID integer Item Id.
2 DatePutToStock string Time stamp of put to stock operation.
3 Quantity integer Quantity that was put to stock.
4 SupplierPrice number Corresponding item supplier price at the time.
5 SupplierId integer Supplier ID.
6 RefTypeSupplierPrice string Supplier price matching reference description.
7 RefDocumentNumberSupplierPrice integer Delivery number for found match.
8 SellDocumentDate string Time stamp of document when item got sold.
9 SellingPrice number Item sell price at the time.
10 RefTypeSellingPrice string Selling price matching reference description.
11 RefDocumentNumberSellingPrice string Invoice or POS document number for found match.
12 InvBinItemLogId integer Uinque ID of put to stock operation.

Body 2: Error/Warning response.

# Name Type Description
1 Staus string Status of response.
2 Message string Description of error/warning response.

Additional Notes

The date range period is limited to 31 days. Population of price data happens over night. This means that it is not possible to get data for current day.