Description

API Call to retrieve all relevant invoice lines

Request Parameters

#	Name	Type	Required	Example	Description
1	InvlineKey	integer	0	123	pixi* Invoice line Key
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 rows returned maximum

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:pixiReadInvlines>
         <dem:InvlineKey>123</dem:InvlineKey>
         <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:pixiReadInvlines>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Result set

#	Name	Type	Description
1	InvLineKey	integer	InvLineKey
2	InvoiceRef	integer	InvoiceRef
3	OrderLineRef	integer	OrderLineRef
4	CustRef	integer	CustRef
5	AddrRef	integer	AddrRef
6	ItemNr	string	ItemNr
7	ItemQty	integer	ItemQty
8	OrderQty	integer	OrderQty
9	ItemText	string	ItemText
10	ItemPrice	string	ItemPrice
11	ItemDiscount	integer	ItemDiscount
12	ItemVAT	string	ItemVAT
13	CreateDate	string	CreateDate
14	CreateEmp	string	CreateEmp
15	UpdateDate	string	UpdateDate
16	UpdateEmp	string	UpdateEmp
17	ItemPrice_OrderCurr	string	ItemPrice_OrderCurr
18	ShipCost	string	ShipCost
19	ShipCostPerItem	string	ShipCostPerItem
20	OrderCurrency	string	OrderCurrency
21	ShipCost_OrderCurr	string	ShipCost_OrderCurr
22	ItemRef	integer	ItemRef
23	CCPChargedYN	string	CCPChargedYN
24	SerialNr	string	SerialNr
25	FullPrice	string	FullPrice
26	DiscountValue	string	DiscountValue
27	DiscountPerc	string	DiscountPerc

Additional Notes