Description

API Call to retrieve all relevant orderlines lines

Request Parameters

#	Name	Type	Required	Example	Description
1	OrderlineKey	integer	0	123	pixi* orderline Key. 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 rows 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:pixiReadOrderlines>
         <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:pixiReadOrderlines>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Orderlines list

#	Name	Type	Description
1	OrderlineKey	integer	ID for the Orderline record
2	OrderNr	integer	Order number in pixi*
3	CustRef	integer	IF for the Customer record
4	AddrRef	integer	ID for the Address record
5	ShipAdrRef	integer	ID for the Shipping Address record
6	InvRef	integer	ID for the Invoice record
7	NODRef	integer
8	SupplRef	integer
9	SupplInfo	string
10	ShipRef	integer
11	ArtNr	string	Barcode
12	ArtName	string	Name of the item
13	Qty	integer	Quantity
14	Backlist	string
15	Price	number
16	SupplPrice	number
17	ArtVAT	string
18	Status	string	Status
19	Note	string
20	OrderMS	string
21	ConfMS	string
22	ConfigType	string
23	MusicType	string
24	Source	string
25	OrderDate	string
26	TimeZone	string
27	SOrderDate	string
28	ConfDate	string
29	ConfVia	string
30	LConfDate	integer
31	LConfVia	string
32	ShipDate	string
33	AktionsKennz	string
34	Discount	string
35	ShipId	string
36	BoxNr	integer
37	OrderLineType	string
38	BackorderRef	integer
39	OrderCurrency	string
40	CreateDate	string
41	CreateEmp	string
42	UpdateDate	string
43	UpdateEmp	string
44	OrderExchRate	number
45	ItemRef	integer
46	WaitDays	integer
47	Price_OrderCurr	number	*Obsolete
48	TaxAmount	number
49	TaxRate	number
50	ShipCost	number
51	ShipCostPerItem	string
52	ShipCost_OrderCurr	number
53	OrderNrExternal	string
54	ItemNrExternal	string
55	LocationID	string
56	LastOrdLocationID	string
57	SupplGroup	string
58	SOrderlineRef	integer	*Obsolete
59	CustomerEMailed	string
60	DelayEMailed	string
61	SupplGroupScanIn	string
62	rowguid	string
63	OrdShopID	string
64	OrGosF1	string
65	OrGosF2	string
66	SupplPrice_Source	string
67	Curr_Source	string
68	LastDelayEmail	string
69	ConfEmailed	string
70	HALEmailed	string
71	CCReqEmailed	string
72	CCEXpEmailed	string
73	NotEmailed	string
74	OrShippingNote	string
75	ForceFirstSuppl	string
76	ForceLocToSuppl	string
77	ForceParallelShip	string
78	VoucherID	string
79	OrReplFlag	string
80	OrCCPLock	string
81	ChangeDate	string
82	ChangeSequence	integer
83	InvSorderlineRef	integer
84	BundleOrderlineRef	integer
85	Refunded	boolean
86	DIcheckbox	boolean
87	OriginalOrderlineRef	integer
88	oItemSpecialNote	string
89	DiscountValue	string
90	DiscountPerc	number
91	BookAccountNr	string
92	SerialNr	string
93	UpdateBackToHal	boolean
94	AlreadyOrdered	boolean
95	FullPrice	number
96	DF_type	string
97	DFShipDate	string
98	DFShipmentTrackingID	string
99	NLBCustomerEmailed	string
100	PriceWeightUnits_Price	number
101	MeasuredWeight	integer
102	OrderDateStartOfDay	string
103	PickListNrUsed	integer
104	InvoiceNrExternal	string
105	Order_Id	integer
106	ItemOriginalFullPrice	number
107	Price_Net	number
108	Price_OrderCurr_Set	integer	*Obsolete
109	ShipCost_OrderCurr_Set	integer	*Obsolete
110	VATPercent	number
111	VATsRef	integer
112	BatchNumber	string
113	BestBeforeDate	string
114	RealSorderlineRef	integer
115	EstimatedDelivery	string

Additional Notes