pixi Developer & Integration Documentation

pixiGetSOrders

Description

API which retrieves supplier orders with corresponding suppliers. Pixi_GetSOrders drop because API call replaced this procedure.


Request Parameters

# Name Type Required Example Description
1 LocationID string 0 Sample text Location on which you search for supplier orders.
2 RLimit integer 0 123 Number of returned records.
3 ShowNew boolean 0 0/1 Filter: Display supplier orders on status NEW.
4 ShowOrd boolean 0 0/1 Filter: Display supplier orders on status BES.
5 ShowCon boolean 0 0/1 Filter: Display supplier orders on status CON.
6 ShowCls boolean 0 0/1 Filter: Display supplier orders on status CLS.
7 ShowDueDate boolean 0 0/1 Decide whether to return overdue SOrders. Only orders that are/were already ordered are considered.
8 ShowNoDate boolean 0 0/1 Decide whether to return SOrders with no estimated delivery date set. Only orders that are/were already ordered are considered.
9 StatusChangeDateFrom string 0 2017-01-01 00:00:00.000 Filter result to supplier orders where status change timestamp is before the parameter value.
10 StatusChangeDateTo string 0 2017-01-31 23:23:59.996 Filter result to supplier orders where status change timestamp is after the parameter value.
11 ExtOrderNrs string 0 <ExtOrders> <ExtOrder> <ExtOrderNr>EXT_001</ExtOrderNr> </ExtOrder> <ExtOrder> <ExtOrderNr>EXT_002</ExtOrderNr> </ExtOrder> </ExtOrders> Filter list of External order numbers in XML format.

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:pixiGetSOrders>
         <dem:LocationID>Sample text</dem:LocationID>
         <dem:RLimit>123</dem:RLimit>
         <dem:ShowNew>0/1</dem:ShowNew>
         <dem:ShowOrd>0/1</dem:ShowOrd>
         <dem:ShowCon>0/1</dem:ShowCon>
         <dem:ShowCls>0/1</dem:ShowCls>
         <dem:ShowDueDate>0/1</dem:ShowDueDate>
         <dem:ShowNoDate>0/1</dem:ShowNoDate>
         <dem:StatusChangeDateFrom>2017-01-01 00:00:00.000</dem:StatusChangeDateFrom>
         <dem:StatusChangeDateTo>2017-01-31 23:23:59.996</dem:StatusChangeDateTo>
         <dem:ExtOrderNrs><ExtOrders>
    <ExtOrder>
        <ExtOrderNr>EXT_001</ExtOrderNr>
    </ExtOrder>
    <ExtOrder>
        <ExtOrderNr>EXT_002</ExtOrderNr>
    </ExtOrder>
</ExtOrders></dem:ExtOrderNrs>
      </dem:pixiGetSOrders>
   </soapenv:Body>
</soapenv:Envelope>

Response


Body 1: Supplier orders

# Name Type Description
1 OrderNr integer Order number in pixi*
2 SupplNr string Supplier number (code)
3 SupplGroup string Supplier group
4 OrderDate string Supplier order date
5 Status string Supplier order status
6 CreateDate string Create date
7 CreateEmp string Creator of the record (pixi* user)
8 UpdateDate string Last update date of the record
9 UpdateEmp string User who last updated the record
10 SOrderLocation string Location of supplier order
11 RecordBatchNr integer Always "NULL"
12 SOrderKey integer Supplier order ID
13 ExtOrderNr string External supplier order number
14 XMLsent boolean Indicator that XML was sent
15 SupplierFulfillment boolean Indicator of direct fulfillment order
16 SOrdersNote string Supplier order note
17 SupplName string Supplier name
18 PixiOrderCreated boolean Always "NULL"
19 GoodsReceipts string List of SDelHNr (Supplier Delivery Header Nr) separated by semicolon.

Additional Notes