Description

API call returns bundle orderlines

Request Parameters

#	Name	Type	Required	Example	Description
1	OrderlineKey	integer	0	123	pixi bundle orderline id. If @RowCount is NULL then it returns only this row, otherwise next @RowCount records.
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	Maximum number of records returned

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:pixiReadBundleOrderlines>
         <dem:OrderlineKey>123</dem:OrderlineKey>
         <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:pixiReadBundleOrderlines>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Bundle ordeline details

#	Name	Type	Description
1	OrderlineKey	integer	ID for the Orderline record
2	OrderNr	integer	Order number in pixi*
3	CustRef	integer	ID of customer
4	AddrRef	integer	Billing address ID
5	ShipAdrRef	integer	Shipping address ID
6	SupplInfo	string	Supplier code
7	ArtNr	string	Item barcode
8	ArtName	string	Name of the item
9	Qty	integer	Bundle item quantity
10	Price	number	Bundle item price
11	SupplPrice	number	Supplier price of the item
12	Status	string	Bundle orderline status
13	Note	string	Bundle orderline note
14	OrderMS	string	Currency code
15	ConfigType	string	Category ID
16	Source	string	Record creation source
17	OrderDate	string	Order date
18	TimeZone	string	Time zone
19	OrderLineType	string	Type of order
20	CreateDate	string	Create date
21	CreateEmp	string	Creator of the recodr (pixi user)
22	UpdateDate	string	Last update date of the record
23	UpdateEmp	string	User who last updated the record
24	ItemRef	integer	Item ID
25	WaitDays	integer	Days to wait before shipping
26	TaxAmount	number	VAT amount
27	TaxRate	number	VAT rate
28	ShipCostPerItem	string	Shipping costs per item
29	OrderNrExternal	string	External order number
30	ItemNrExternal	string	Item number external (Imported from Shop)
31	LocationID	string	Location ID
32	LastOrdLocationID	string	Last order location ID
33	SupplGroup	string	Item supplier group
34	rowguid	string	Uniquely identifying row
35	OrdShopID	string	Shop ID
36	VoucherID	string	ID of the voucher
37	oItemSpecialNote	string	Bundle item note
38	DiscountValue	number	Discount value
39	DiscountPerc	number	Discount percent
40	FullPrice	number	Bundle orderline full price
41	DF_type	string	Direct fulfillment type
42	Price_Net	number	Price without VAT
43	VATPercent	number	VAT percent
44	VATsRef	integer	VAT refference ID

Additional Notes