pixi Developer & Integration Documentation

pixiGetItemSuppliers

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).