pixi Developer & Integration Documentation

pixiSupplierOrderLineLocQtyGet

Description

Retrieves location quantity allocations for supplier order lines. Results can be filtered by supplier order IDs, supplier order line IDs, or location quantity IDs — all filters are optional and can be combined. Returns all matching records, or an empty set if no matches are found.


Request Parameters

#

Name

Type

Required

Example

Description

1

AppName

string

1

MyApp

Name of the application executing the API call.

2

SupplierOrderIds

string

0

13,25

Comma-separated IDs of supplier orders to filter by. Example: 13,25

3

SupplierOrderLinesIds

string

0

13,25

Comma-separated IDs of supplier order lines to filter by. Example: 13,25

4

SupplierOrderLinesLocQtyIds

string

0

13,25

Comma-separated IDs of supplier order line location quantity records to filter by. Example: 13,25


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:pixiSupplierOrderLineLocQtyGet>
<dem:AppName>MyApp</dem:AppName>
<dem:SupplierOrderIds>13,25</dem:SupplierOrderIds>
<dem:SupplierOrderLinesIds>13,25</dem:SupplierOrderLinesIds>
<dem:SupplierOrderLinesLocQtyIds>13,25</dem:SupplierOrderLinesLocQtyIds>
</dem:pixiSupplierOrderLineLocQtyGet>
</soapenv:Body>
</soapenv:Envelope>


Response


Body 1: Location Quantities

Returned on success. One row per matching location quantity record.

#

Name

Type

Description

1

Id

int

Supplier order line location quantity ID.

2

RecordCreatedOn

datetime

Date and time the record was created.

3

RecordCreatedByUserId

int

ID of the user who created the record.

4

RecordModifiedOn

datetime

Date and time the record was last modified.

5

RecordModifiedByUserId

int

ID of the user who last modified the record.

6

RowVersion

int

Row version for concurrency control.

7

SupplierOrderLineId

int

ID of the supplier order line.

8

LocationId

int

ID of the warehouse location.

9

Qty

int

Allocated quantity.

10

DeliveredQty

int

Quantity already delivered.

11

UndeliveredQty

int

Remaining quantity not yet delivered.


Body 2: Error Information

Returned instead of Body 1 when an unexpected error occurs.

#

Name

Type

Description

1

ReturnCode

string

Always "ERROR" on failure.

2

ErrorMessage

string

Description of the error.


Additional Notes

All filter parameters (SupplierOrderIds, SupplierOrderLinesIds, SupplierOrderLinesLocQtyIds) are optional but at least one should contain values to return meaningful results. Multiple filters can be combined.

ID values are passed as comma-separated integers, for example: 13,25,101

Body 1 and Body 2 are mutually exclusive — Body 1 is returned on success (including empty result set),
Body 2 is returned only when an unexpected SQL error occurs.