pixi Developer & Integration Documentation

pixiGetDeliveryItem

Description

Returns delivery item (line) details for goods receipts. Supports filtering by delivery, item, and date range with pagination.


Request Parameters

#

Name

Type

Required

Example

Description

1

SDelHKey

integer

0

58401

Reference to a specific delivery (ID)

2

DeliveryNumber

integer

0

10250

Reference to a specific delivery (DeliveryNumber)

3

ItemNrInternal

string

0

ART-10025

Load only deliveries for a specific ItemNrInternal

4

EANUPC

string

0

4006381333931

Load only deliveries for a specific EANUPC

5

RowCount

integer

0

100

Number of rows returned

6

Offset

integer

0

5840

To be used together with RowCount for pagination. Use last SDelDkey from results to get next.

7

DateFrom

datetime

0

2025-01-01 00:00:00.000

Delivery line "Create date" filter. Show delivery lines younger than DateFrom.

8

DateTo

datetime

0

2025-01-31 23:59:59.997

Delivery line "Create date" filter. Show delivery lines older than DateTo.


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:pixiGetDeliveryItem>
<dem:SDelHKey>58401</dem:SDelHKey>
<dem:DeliveryNumber>10250</dem:DeliveryNumber>
<dem:ItemNrInternal>ART-10025</dem:ItemNrInternal>
<dem:EANUPC>4006381333931</dem:EANUPC>
<dem:RowCount>100</dem:RowCount>
<dem:Offset>5840</dem:Offset>
<dem:DateFrom>2025-01-01 00:00:00.000</dem:DateFrom>
<dem:DateTo>2025-01-31 23:59:59.997</dem:DateTo>
</dem:pixiGetDeliveryItem>
</soapenv:Body>
</soapenv:Envelope>


Response


Body 1: Delivery item details

#

Name

Type

Description

1

SDelDkey

integer

Delivery detail ID

2

DeliveryNumber

integer

Delivery number

3

SDelHKey

integer

Delivery header ID

4

ItemKey

integer

pixi item ID

5

ItemNrInt

string

Shop item number

6

ItemNrSuppl

string

Default item number supplier

7

DeliveryItemNrSuppl

string

Item number supplier connected to delivery

8

ItemName

string

Item name

9

EANUPC

string

Item barcode

10

DeliveredQty

number

Delivered quantity

11

OrderedQty

number

Ordered quantity

12

MidPrice

number

Discounted price for the item

13

Discount

number

Delivery item discount in percents

14

EK

number

Original supplier price

15

FinalPrice

number

Final discounted price for the item, including the delivery discount

16

ItemTAGs

string

Item tags

17

PicLinkLarge

string

Large picture URL

18

PicLinkSmall

string

Small picture URL

19

BatchNumber

string

Batch number

20

BestBeforeDate

datetime

Best before date

21

BatchManagementDetails

string

Batch number and Best before date data if there are multiple entries.

XML containing:

- BinItemLogId - Id InvBinItemLog

- LocationId - Location Id
- BinRef - Bin Id
- ItemRef - Item Id
- DeliveredQty - Delivered Quantity
- BatchNumber - Batch Number
- BestBeforeDate - Best Before Date

22

InternalNumber

string

Supplier order internal number

23

ExternalReceiptNr

string

External receipt number from supplier


Additional Notes

Use the Offset parameter together with RowCount for pagination. Set Offset to the last SDelDkey value from your previous result to get the next batch.

BatchManagementDetails (column 21) contains XML with detailed batch data when an item has multiple batch entries on the same delivery line.