Description

API call to retrieve all relevant supplier data

Request Parameters

#	Name	Type	Required	Example	Description
1	AddItemKey	integer	0	123	pixi* Additem ID (starting ID + 1 used for pagination)
2	CreateDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Create Date from (including)
3	CreateDateTo	string	0	YYYY-MM-DD hh:mm:ss	Create Date to (excluding)
4	UpdateDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Update Date from (including)
5	UpdateDateTo	string	0	YYYY-MM-DD hh:mm:ss	Update Date To (excluding)
6	CreateAndUpdateDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Create or Update Date from (including)
7	CreateAndUpdateDateTo	string	0	YYYY-MM-DD hh:mm:ss	Create or Update Date to (excluding)
8	RowCount	integer	0	123	Number of maximum returned rows

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:pixiReadAddItems>
         <dem:AddItemKey>123</dem:AddItemKey>
         <dem:CreateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateDateFrom>
         <dem:CreateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateDateTo>
         <dem:UpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:UpdateDateFrom>
         <dem:UpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:UpdateDateTo>
         <dem:CreateAndUpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateFrom>
         <dem:CreateAndUpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateTo>
         <dem:RowCount>123</dem:RowCount>
      </dem:pixiReadAddItems>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Returns additional item data (Items in connection with suppliers)

#	Name	Type	Description
1	AddItemKey	integer	AddItem ID
2	EANUPC	string	Item barcode
3	UPC	string	Item barcode
4	ItemNrSuppl	string	Supplier item number.
5	ItemNrInt	string	Shop item number.
6	ItemNrOld	string	Obsolete field. Not imported from the shop.
7	SupplNr	string	Supplier number (code)
8	Price	number	Item price
9	SupplPrice	number	Supplier price of the item.
10	Curr_Source	string	Item price currency
11	MwStSatz	number	VAT Rate
12	AutoPrice	boolean	Always set to 0 when imported from shop.
13	CreateDate	string	Create date
14	UpdateDate	string	Last update date of the record.
15	ItemRef	integer	Item ID
16	LastImportDate	string	Time stamp when the item was last imported from the shop
17	SKU	string	SKU number assigned to item
18	PreferredSupplier	boolean	Flag that marks the used supplier as preferred supplier for the item.
19	Active	boolean	Flag that marks the supplier for this item is active

Additional Notes

Call returns flat data directly from the table