Description

Returns delivery header documents filtered by various criteria. Supports filtering by supplier, item, date ranges, location, and status.

Request Parameters

#	Name	Type	Required	Example	Description
1	SDelHKey	integer	0	58401	Filter: Delivery header id
2	SupplNr	string	0	MGS	Filter: Supplier number
3	DeliveryNumber	integer	0	10250	Filter: Delivery number
4	ItemNrInt	string	0	ART-10025	Filter: Internal item number
5	ItemNrSuppl	string	0	SUP-78542	Filter: Supplier item number
6	EANUPC	string	0	4006381333931	Filter: Barcode
7	ItemName	string	0	Blue T-Shirt XL	Filter: Item name
8	RowCount	integer	0	100	Maximum number of rows
9	Offset	integer	0	58400	Offset for delivery header id
10	Closed	boolean	0	1	Filter: Additionally return documents on closed status.
11	Invoice	boolean	0	1	Filter: Additionally return documents on invoice status
12	LocID	string	0	001	Filter: Location id
13	PiccoUser	string	0	warehouse01	Filter: Picco user
14	CreateDateFrom	datetime	0	20250101	Filter: Create date of Delivery (from)
15	CreateDateTo	datetime	0	20250131	Filter: Create date of Delivery (to)
16	UpdateDateFrom	datetime	0	20250101	Filter: Update date of Delivery (from)
17	UpdateDateTo	datetime	0	20250131	Filter: Update date of Delivery (to)
18	ExternalReceiptNr	string	0	EXT-2025-00417	Filter: External receipt number from supplier

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:pixiGetDelivery>
         <dem:SDelHKey>58401</dem:SDelHKey>
         <dem:SupplNr>MGS</dem:SupplNr>
         <dem:DeliveryNumber>10250</dem:DeliveryNumber>
         <dem:ItemNrInt>ART-10025</dem:ItemNrInt>
         <dem:ItemNrSuppl>SUP-78542</dem:ItemNrSuppl>
         <dem:EANUPC>4006381333931</dem:EANUPC>
         <dem:ItemName>Blue T-Shirt XL</dem:ItemName>
         <dem:RowCount>100</dem:RowCount>
         <dem:Offset>58400</dem:Offset>
         <dem:Closed>1</dem:Closed>
         <dem:Invoice>1</dem:Invoice>
         <dem:LocID>001</dem:LocID>
         <dem:PiccoUser>warehouse01</dem:PiccoUser>
         <dem:CreateDateFrom>20250101</dem:CreateDateFrom>
         <dem:CreateDateTo>20250131</dem:CreateDateTo>
         <dem:UpdateDateFrom>20250101</dem:UpdateDateFrom>
         <dem:UpdateDateTo>20250131</dem:UpdateDateTo>
         <dem:ExternalReceiptNr>EXT-2025-00417</dem:ExternalReceiptNr>
      </dem:pixiGetDelivery>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Delivery headers

#	Name	Type	Description
1	SDelHKey	integer	Delivery header ID
2	SDelHSupplNr	string	Supplier number
3	SDelHDate	datetime	Delivery date
4	SDelHLocationID	string	Location Id
5	SDelHNr	integer	Delivery number
6	SDelHNote	string	Note
7	SDelHStatus	string	Status
8	SDelHCreateDate	datetime	Date of creation
9	SDelHCreateEmp	string	Created by user
10	SDelHUpdateDate	datetime	Date of update
11	SDelHUpdateEmp	string	Updated by user
12	SDelHextInvoiceNr	string	External invoice number
13	SDelHextOrderNr	string	External order number
14	SDelHfinalDicsount	number	Final discount
15	PiccoUser	string	Picco user
16	LockedByPicco	string	Is locked by picco user
17	SupplName	string	Supplier name
18	ExternalReceiptNr	string	External receipt number from supplier

Additional Notes

By default only goods receipts in status NEW are returned. Use parameters Closed and Invoice to include receipts in these statuses.

CreateDateFrom and CreateDateTo or UpdateDateFrom and UpdateDateTo must always be used in pairs, defining a date full range, not just a start or end. To achieve that, use imaginary boundaries like 1999-01-01 or 2099-01-01. You can use any datetime declaration supported by T-SQL, e.g. 2026-05-29T14:30:00', '2026-05-29', '2026-05-29T14:30:00.123', '20260529'.

For pagination, use RowCount in with Offset set to the last SDelHKey from the previous result.

Combining ExternalReceiptNr with SupplNr allows to retrieve a specific delivery from a specific supplier.