Description

Retrieve Orderlines based on several filters.

Request Parameters

#	Name	Type	Required	Example	Description
1	OrderlineKey	integer	0	123	Order line ID, references table Orderlines
2	OrderNR	integer	0	123	pixi* order number
3	OrderNRExternal	string	0	abcdefg	Shop order number
4	Status	string	0	abcdefg	Orderline Status
5	ShopID	string	0	abcdefg	Shop ID
6	PaymentType	string	0	Single character : "g"	Payment TYPE, references table payments
7	OrderDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Beginning of the order date range
8	OrderDateTo	string	0	YYYY-MM-DD hh:mm:ss	End of order date range
9	UpdateDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Beginning of the date range when order line was updated
10	UpdateDateTo	string	0	YYYY-MM-DD hh:mm:ss	End of the date range when order line was updated
11	RowCount	integer	0	123	Maximum number of rows returned
12	InvoiceNr	string	0	abcdefg	Invoice number
13	ShowOrderlines	boolean	0	0 or 1	Force to return Orderlinekey in case of bundle

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:pixiGetOrderline>
         <dem:OrderlineKey>123</dem:OrderlineKey>
         <dem:OrderNR>123</dem:OrderNR>
         <dem:OrderNRExternal>abcdefg</dem:OrderNRExternal>
         <dem:Status>abcdefg</dem:Status>
         <dem:ShopID>abcdefg</dem:ShopID>
         <dem:PaymentType>Single character : "g"</dem:PaymentType>
         <dem:OrderDateFrom>YYYY-MM-DD hh:mm:ss</dem:OrderDateFrom>
         <dem:OrderDateTo>YYYY-MM-DD hh:mm:ss</dem:OrderDateTo>
         <dem:UpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:UpdateDateFrom>
         <dem:UpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:UpdateDateTo>
         <dem:RowCount>123</dem:RowCount>
         <dem:InvoiceNr>abcdefg</dem:InvoiceNr>
         <dem:ShowOrderlines>0 or 1</dem:ShowOrderlines>
      </dem:pixiGetOrderline>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Get Orderline Overview

#	Name	Type	Description
1	OrderlineKey	integer	ID for the Orderline record
2	ArtName	string	Name of the item
3	Qty	integer	Qty
4	Price	number	Price
5	Status	string	Status
6	StatusText	string	Status Text
7	ItemNrExternal	string	Item number external (Imported from Shop)
8	OrderNR	integer	Order number in pixi*
9	OrderNrExternal	string	External order number
10	OrderCurrency	string	Order Currency
11	OrderDate	string	Order Date
12	UpdateDate	string	Last update date of the record
13	ItemRef	integer	Item ID
14	oItemSpecialNote	string	oItem Special Note
15	DiscountValue	number	Discount Value
16	DiscountPerc	number	Discount Perc
17	FullPrice	number	Full Price
18	FullPriceForItem	number	Full Price For Item
19	VATRate	string	VAT Rate
20	PriceNoVAT	number	Price No VAT
21	ItemNrInt	string	Shop item number
22	ShipDate	string	Ship this order at this date only! not before
23	DFShipDate	string	DF Ship Date
24	DFShipmentTrackingID	string	Direct fullfilement shipment tracking ID
25	AvailStockOrderLine	integer	Avail Stock OrderLine
26	EstimatedDelivery	string	Estimated Delivery
27	EANUPC	string	Item barcode
28	ReservedCount	number	Reserved Count

Additional Notes