Order Lines

Attributes

  • id uuid

    Unique identifier for the object.

  • number integer

    The sequence number of the order line.

  • isProcessed boolean

    A true/false whether the order line has been picked or put.

  • hostIdentification string

    A unique value at the order line level that can be carried through from ERP to PPG and back to ERP.

  • serialNumber string

  • lot string

  • progressType integer

  • materialId uuid

    The material on the order line.

  • materialName string

    The material name of the items.

  • quantityRequested float

    The quantity to be processed.

  • quantityConfirmed float

    The quantity that was processed. Only shows if the order line has been processed.

  • quantityDeviated float

    The quantity that was missing. Only shows if the order line has been processed.

  • expiryDate datetime

    The Expiry date to be processed on the order line.

  • releaseDate datetime

    The Release date to be processed on the order line.

  • productionDate datetime

    The Production date to be processed on the order line.

  • isProcessed boolean

    True if the order line has been successfully picked or put.

  • processedDate datetime

    When the order line was individually processed.

  • creationDate datetime

    The date when the order line was created.

  • info1 string

    A generic field for custom use.

  • info2 string

    A generic field for custom use.

  • info3 string

    A generic field for custom use.

  • info4 string

    A generic field for custom use.

  • info5 string

    A generic field for custom use.

  • [DynamicField] string

Endpoints

List Order Lines

get /api/order_lines

Arguments

  • limit integer

    A limit on the number of objects to be returned. Limit can range between 1 and 1000, and the default is 25.

  • offset integer

    Will return items, but only those after the integer amount.

  • createdAfter datetime

    Only return orders that were created after a certain date.

  • createdBefore datetime

    Only return orders that were created before a certain date.

  • processedAfter datetime

    Filter order lines only after a certain time or date. Can create a date range when combined with processedBefore.

  • processedBefore datetime

    Filter order lines only before a certain time or date. Can create a date range when combined with processedAfter.

  • countOnly boolean

    When true, will only return a count of the amount of items in the query.

  • materialName string

    Filter order lines only by a certain material.

  • isProcessed boolean

    A boolean whether or not order lines have been picked or put.

  • type integer

    Specify whether you want Pick or Put order lines.

  • quantity integer

    Filter by a certain quantity.

  • [DynamicField]

    Any dynamic fields that have been set up can be used as a filter.

Request with curl
curl "http://[Your IP]/api/order_lines" \ -X get \-H "Content-Type: application/json" \-H "Authorization: Bearer [Your JWT Access Token]"
Example Response
{ "order lines": [{ "id": "CAE60ED9-8B57-40B9-98D5-3CB5068E4D81", "number": "22", "isProcessed": "true", "hostIdentification": "AIFBE123F", "serialNumber": "string", "lot": "string", "progressType": "integer", "materialId": "30A295F8-D3EC-44C5-8825-00A2358E4280", "materialName": "ITEM0241", "quantityRequested": "10", "quantityConfirmed": "8", "quantityDeviated": "2", "expiryDate": "datetime", "releaseDate": "datetime", "productionDate": "datetime", "isProcessed": "False", "processedDate": "datetime", "creationDate": "2020-02-10 00:36:00.327", "info1": "string", "info2": "string", "info3": "string", "info4": "string", "info5": "string", "[DynamicField]": "string", }] }] }

Create Order Line

post /api/order_lines

Create an order line, to be imported by PowerPick.

Body Parameters

  • number integer REQUIRED

    The sequence number of the order line.

  • materialName string REQUIRED

    The name of the material on the order line.

  • orderNumber REQUIRED

    The number of the order this order line belongs to.

  • quantity integer REQUIRED

    The quantity to be processed on the order line.

  • hostIdentification string

    A unique value at the order line level that can be carried through from ERP to PPG and back to ERP.

  • batchName string

    The Lot or Batch number of the material on the order line.

  • qualification string

    A specified attribute of the material on the order line.

  • serialNumber string

    The unique serial number at the unit level of the material on the order line.

  • expiry datetime

    The Expiry date to be processed on the order line.

  • releaseDate datetime

    The Release date to be processed on the order line.

  • productionDate datetime

    The Production date to be processed on the order line.

  • info1 string

  • info2 string

  • info3 string

  • info4 string

  • info5 string

  • [DynamicField]

    Any field set up in PowerPick.

Request with curl
curl "http://[Your IP]/api/order_lines" \ -X post \ -H "Content-Type: application/json" \-H "Authorization: Bearer [Your JWT Access Token]" \ -d '{ "number": "integer", "materialName": "string", "orderNumber": "", "quantity": "integer", }'
Example Response
{ "orderline": { "id": "CAE60ED9-8B57-40B9-98D5-3CB5068E4D81", "number": "22", "isProcessed": "true", "hostIdentification": "AIFBE123F", "serialNumber": "string", "lot": "string", "progressType": "integer", "materialId": "30A295F8-D3EC-44C5-8825-00A2358E4280", "materialName": "ITEM0241", "quantityRequested": "10", "quantityConfirmed": "8", "quantityDeviated": "2", "expiryDate": "datetime", "releaseDate": "datetime", "productionDate": "datetime", "isProcessed": "False", "processedDate": "datetime", "creationDate": "2020-02-10 00:36:00.327", "info1": "string", "info2": "string", "info3": "string", "info4": "string", "info5": "string", "[DynamicField]": "string", } }

Show Order Line

get /api/order_lines/[id]

Get a specific order line from the PPG database and return a JSON response. The order will be pulled from the MasterOrderLine table.

Arguments

Request with curl
curl "http://[Your IP]/api/order_lines/[id]" \ -X get \-H "Content-Type: application/json" \ -H "Authorization: Bearer [Your JWT Access Token]"
Example Response
{ "orderline": { "id": CAE60ED9-8B57-40B9-98D5-3CB5068E4D81, "number": 22, "isProcessed": true, "hostIdentification": "AIFBE123F", "serialNumber": "string", "lot": "string", "progressType": integer, "materialId": 30A295F8-D3EC-44C5-8825-00A2358E4280, "materialName": "ITEM0241", "quantityRequested": 10, "quantityConfirmed": 8, "quantityDeviated": 2, "expiryDate": datetime, "releaseDate": datetime, "productionDate": datetime, "isProcessed": False, "processedDate": datetime, "creationDate": 2020-02-10 00:36:00.327, "info1": "string", "info2": "string", "info3": "string", "info4": "string", "info5": "string", "[DynamicField]": "string", } }

Delete Order Line

get /api/order_lines/[id]/delete

Delete an order line.

Arguments

Request with curl
curl "http://[Your IP] /api/order_lines/[id]/delete" \ -X get \-H "Content-Type: application/json" \-H "Authorization: Bearer [Your JWT Access Token]"
Example Response
{"deleted": "true" }