Description
API Call to get item-supplier rows for a specific item, or all item-supplier rows for a specific supplier. Returns pricing, delivery times, and supplier status.
Request Parameters
# |
Name |
Type |
Required |
Example |
Description |
1 |
ItemKey |
integer |
0 |
123 |
ItemKey to load item. |
2 |
EAN |
string |
0 |
4001234567890 |
EANUPC to load item. |
3 |
ItemNrSuppl |
string |
0 |
ABC-123 |
Supplier item number to load item. |
4 |
ItemNrInt |
string |
0 |
INT-123 |
Shop item number to load item. |
5 |
OnlyActiveSuppliers |
boolean |
0 |
0 |
Show only active suppliers. Default is 0 (off). When 1, returns only rows where the supplier is not disabled and the item is active. |
6 |
SupplNr |
string |
0 |
0001 |
Filter by supplier number. Returns all items for this supplier. Validated against existing suppliers; an error is returned if it does not exist. |
Important: At least one parameter (ItemKey, EAN, ItemNrSuppl, ItemNrInt, or SupplNr) must be supplied, otherwise an error is returned. The item identifiers (ItemKey, EAN, ItemNrSuppl, ItemNrInt) use OR logic to match any provided value. SupplNr can be used on its own to list all items for a supplier, or combined with item identifiers (AND logic).
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:pixiGetItemSuppliers>
<dem:ItemKey>123</dem:ItemKey>
<dem:EAN>4001234567890</dem:EAN>
<dem:ItemNrSuppl>ABC-123</dem:ItemNrSuppl>
<dem:ItemNrInt>INT-123</dem:ItemNrInt>
<dem:OnlyActiveSuppliers>0</dem:OnlyActiveSuppliers>
<dem:SupplNr>0001</dem:SupplNr>
</dem:pixiGetItemSuppliers>
</soapenv:Body>
</soapenv:Envelope>Response
Body 1: List of item suppliers. Returned when validation passes (empty set if there are no matches).
# |
Name |
Type |
Description |
1 |
ItemKey |
int |
pixi* item ID. |
2 |
EANUPC |
varchar (13) |
Item barcode. |
3 |
ItemNrSuppl |
varchar (50) |
Supplier item number. |
4 |
ItemNrInt |
varchar (50) |
Shop item number. |
5 |
SupplNr |
varchar (4) |
Supplier number code. |
6 |
SupplPrice |
money |
Supplier price for the item. |
7 |
SupplierDisabled |
bit |
Flag if supplier is disabled. |
8 |
MinOrderQty |
int |
Min order quantity. |
9 |
OnlyPU |
bit |
Only package unit. |
10 |
ItemDeliveryTime |
int |
Item delivery time. |
11 |
DeliveryTime |
int |
Delivery time. |
Body 2: Error response. Returned instead of Body 1 when validation fails.
Name |
Type |
Description |
Error |
varchar (20) |
Error status. Value is "Error". |
ErrorMsg |
varchar (256) |
Error description: "Please specify at least one parameter" (no filter parameter supplied) or "Supplier not found" (SupplNr does not exist). |
Additional Notes
This is a read-only call. It reads item-supplier rows from the AddItems and Suppliers data.
A successful call with no matching rows returns an empty result set (not an error).