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.