{"info":{"_postman_id":"30d9d33b-aed5-49af-9a80-181d02642c77","name":"CloudPick External APIs","description":"

Overview

This API document will walk you through the process on how to call CloudPick via API.

Methods and Resources

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Method	Resource	Description
`GET`	`/session`	For API authentication only.
`POST`	`/pickdetailimport`	To import orders to be processed by CloudPick.
`POST`	`/query`	To query your data contained within CloudPick.

Authentication

In order to make any API request to CloudPick, you must retrieve a JWT token using your API Keys. The JWT token is valid for 24 hours after issuance.

Getting your JWT Token

Using your API keys from your sales rep, make a GET request to the /session resource with the following headers:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Key	Value	Description	Resource	Method
Authorization	`api_token`	Your CloudPick API token	Session	`GET`
X-API-Key	`api_key`	Your CloudPick API key	Session Query PickDetailImport	`GET` `POST`

API Endpoint

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Endpoint URL	Description	Version
https://api.mycloudpick.com/v1.0.0	CloudPick API Endpoint	1.0.0

Request Headers

To make a POST request to CloudPick resources /query or /pickdetailimport you must include the following in your headers:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Key	Value	Description	Resource	Method
Authorization	`jwt_token`	Your CloudPick jwt token	Query PickDetailImport	`POST`
X-API-Key	`api_key`	Your CloudPick API key	Session Query PickDetailImport	`GET` `POST`

Response Codes

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Code	Description
200 OK	The request was successfully processed.
201 Created	The request has been fulfilled and resulted in a new resource being created.
400 Bad Request	The request could not be understood by the server due to malformed syntax.
401 Unauthorized	The necessary authentication credentials are not present in the request or are incorrect.
404 Not Found	The resource was not found but could be available again in the future.
422 Unprocessable Entity	The request body was well-formed but contains semantical errors. The response body will provide more details in the errors or error parameters.
500 Internal Server Error	The server encountered an unexpected condition which prevented it from fulfilling the request.

Rate limit

You are limited to 100 requests per second and 10,000 requests per day.

CloudPickQL Search Syntax

This section provides information on the syntax for building your search query in CloudPickQL.

Query Info

Below is a list of queries that are currently available. Please see each for more detailed information on list of fields supported.

PickDetail
PickLedger

\"QueryInfo\":{\n       \"Query\":\"PickLedger\"\n    }\n

Field Selection Info

At this time we do not support the selection of specific fields.

\"FieldSelectionInfo\":{\n       \"FieldSelection\": null\n    }\n

Records Info

You can control the number of records you receive in the response. You can use this as pagination for a list of records that may be paged through.

\"RecordsInfo\":{\n       \"RecordsFirst\": 30\n    }\n

Paging Info

You can use paging info to support pagination where required.

\"PagingInfo\":{\n       \"CursorValue\": null\n    }\n

Filter Info

You can use filters to drive the selection of the records you want to see. Using fields from the available query set, you use comparators and values to make the selection. You may use as many filters as you need to construct your query. When using more than one filter it is implied that you are performing an AND query search.

\"FilterInfo\":[\n       {\n          \"FilterFields\": {\n                \"Field\":\"PL.Transaction\",\n                \"Comparator\":\"eq:Picked\"\n           }\n        },\n        {\n            \"FilterFields\": {\n                \"Field\":\"PL.UserID\",\n                \"Comparator\":\"eq:DREWJ\"\n            }\n        }\n

Filter Info Comparators

Within the 'FilterInfo' section you will be using comparators to filter on specific data. This is a list of the available comparators.

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Comparator	Description	Example
EQ	Query will look for vlaues that are equal to the comparison value.	\"Field\":\"PD.CartNumber\", \"Comparator\":\"eq:9DC3E8F4\"
NE	Query will look for values that are not equal to the comparison value.	\"Field\":\"PD.Barcode\", \"Comparator\":\"ne:790458\"
LT	Query will look for values that are less than the comparison value.	\"Field\":\"PD.PickLocation\", \"Comparator\":\"lt:CP00106G\"
GT	Query will look for values that are greater than the comparison value.	\"Field\":\"PD.QuantityToPick\", \"Comparator\":\"gt:0\"
LE	Query will look for values that are less than or equal to the comparison value.	\"Field\":\"PD.CartonID\", \"Comparator\":\"le:12345678\"
GE	Query will look for values that are greater than or equal to the comparison value.	\"Field\":\"PD.QuantityPick\", \"Comparator\":\"ge:5\"
RANGE	Query will look for values that within a range of two comparison values. Query will be inclusive of the two range values.	\"Field\":\"PD.ImportedDateTime\", \"Comparator\":\"range:2019-07-01-00.00.00.000000:2019-07-31-00.00.00.000000\"
LIST	Query will look for values that match a list of comparison values.	\"Field\":\"PD.PickedBy\", \"Comparator\":\"list:JOHND:JANED:JACKD\"
NLIST	Query will look for values that do not match a list of comparison values.	\"Field\":\"PD.PickedBy\", \"Comparator\":\"nlist:JOHND:JANED:JACKD\"
LIKE	Query will look for values that match a comparison value with a wildcard (*). Wildcard may be placed at the beginning of the string, the end of the string, or both.	\"Field\":\"PD.ItemAlias02\", \"Comparator\":\"like:Alias02\"
NLIKE	Query will look for values that do not match a comparison value with a wildcard (*). Wildcard may be placed at the beginning of the string, the end of the string, or both.	\"Field\":\"PD.ItemAlias02\", \"Comparator\":\"nlike:Alias02\"

Group Info

Grouping is used when retrieving summary information in the request. Use grouping as a level break on the summarized totals. The group should match the sort in this instance.

\"GroupInfo\": [\n        {\n            \"GroupFields\": {\n                \"Field\": \"PD.CartonID\"\n            }\n        }\n    ]\n

Sort Info

You may control the sequencing of records in the response using sortation. The system supports ascending and descending. You must use the same sequence on all fields in order to comply with the rules of pagination.

\"SortInfo\": [\n        {\n            \"SortFields\": {\n                \"Field\": \"PD.LineID\",\n                \"Order\": \"ascending\"\n            }\n        }\n    ]\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Sort	Description	Example
Ascending	Sort the data returned in ascending order.	\"Field\":\"PD.PickedDateTime\", \"Order\":\"ascending\"
Descending	Sort the data returned in descending order.	\"Field\":\"PD.PickedDateTime\", \"Order\":\"descending\"

Pagination

You can make multiple requests to pull additional records if your initial request had further records it could have sent. Your initial response will include a Boolean value for “HasNextPage” indicating whether additional information is available. To retrieve the additional information, you can re-send the original request and include the “LastCursorValue” from the previous response. This system will respond with the next set of records. You can continue this process until the “HasNextPage” is false.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Overview","slug":"overview"},{"content":"Methods and Resources","slug":"methods-and-resources"},{"content":"Authentication","slug":"authentication"},{"content":"Response Codes","slug":"response-codes"},{"content":"Rate limit","slug":"rate-limit"},{"content":"CloudPickQL Search Syntax","slug":"cloudpickql-search-syntax"}],"owner":"9153015","collectionId":"30d9d33b-aed5-49af-9a80-181d02642c77","publishedId":"SVtYRmNr","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-04-09T15:46:39.000Z"},"item":[{"name":"session","item":[{"name":"/session","event":[{"listen":"test","script":{"id":"48693248-662a-495d-a25f-c867214cdb92","exec":["var jsonData = JSON.parse(responseBody);","pm.environment.set(\"jwt_token\", jsonData.sessionToken);"],"type":"text/javascript"}}],"id":"e085cb0d-f942-4a03-bbbd-f78c91720673","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","value":"ix4y2l4y7dUVIdeIZJHJRmU7Vt4wMfuz","type":"text"},{"key":"X-API-Key","value":"9y99VYMgbQ70A2g1ITcME4rxY73mamfC6kg10E22","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"url":"https://polmuschbb.execute-api.us-east-1.amazonaws.com/dev/session","urlObject":{"path":["session"],"host":["https://polmuschbb.execute-api.us-east-1.amazonaws.com/dev"],"query":[],"variable":[]}},"response":[{"id":"40e4ad06-9cc4-41ec-a692-2c90e87c7ff4","name":"200 OK","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{jwt_token}","type":"text"},{"key":"X-API-Key","value":"{api_key}","type":"text"}],"url":"https://api.mycloudpick.com/v1.0.0/session"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"1154"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Wed, 02 Oct 2019 20:58:48 GMT"},{"key":"x-amzn-RequestId","value":"f4e2c393-6268-4ec5-82a2-f82ec65f67f9"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"x-amz-apigw-id","value":"A89cWHnPoAMFsxQ="},{"key":"X-Amzn-Trace-Id","value":"Root=1-5d950f82-e18f189ac0806058614d291c;Sampled=0"},{"key":"X-Cache","value":"Miss from cloudfront"},{"key":"Via","value":"1.1 618a70ffeadea6f360f2647a0c2e57be.cloudfront.net (CloudFront)"},{"key":"X-Amz-Cf-Pop","value":"DFW3-C1"},{"key":"X-Amz-Cf-Id","value":"M4ub2unvR40mRFP7RImRHCE0duUjlWrflpoLx5CWF2JlNvNCzGu60A=="}],"cookie":[],"responseTime":null,"body":"{\n \"sessionToken\": \"eyJraWQiOiJZWjcyMDV1M1wiZUtDbnBFNVZxazlaUk1vSXZHKzkxc3AzVDRXTUtENWg5MD0i3423LCJhbGciOiJSUzI1NiJ9.eyJzdWIiOiJmOGNhODlmYi1lOTM3LTQxMDYtOTJmNi02MGM1NzkxNTI2N2MiLCJjdXN0b206YXBpdXNhZ2VwbGFuaWQiOiJiMHRlaWgiLCJpc3MiOiJodHRwczpcL1wvY29nbml0by1pZHAudXMtZWFzdC0xLmGtYUpvbmF3cy5jb21cL3VzLWVhc3QtMV96dm89NjB0dWgiLCJjb2duaXRvOnVzZXJuYW1lIjoiandYMERRZE4yRThhaU3Rc01FbWlrd0Q4ZWRad2F5OTg4eWtOVzg0MCIsImF1ZCI6IjM0aTE5dnE2MTVqNGk3YXZlcDdlYTBoM3NzIiwiZXZlbnRfaWQiOiI4ZjkzZGFjNi05Mjc1L432423TRhMDctYmI1OS0zMGFmYmQ2MWZhNDYiLCJ0b2tlbl91c2UiOiJpZCIsImN1c3RvbTp1cmxzZXRpZCI6IjUwMCIsImF1dGhfdGltZSI6MTU3MDA0OTkyOCwibmFtZSI6Ik15IGFwcGxpY2F0aW9uIDEiLCJjdXN0b206Y2xpZW50IjoiMTE5MjQ2MTIwNzA2ODk2ODU5NjExMTQwMDAxMDgyNDg4MjI3MDA1NzUyNjY2NDcyODYiLCJleHAiOjE1NzAwNTM1MjgsImlhdCI6MTU3MDA0OTkyOCwiZW1haWwiOiJteUVtYWlsQG15RW1haWwuY29tIn0.GGngkGm2Q0LRPjwVneuLKDQjq98XYtubROC2iO1aL9joRwFkQut_XIoSPKk91QNl59GG939pkoKRpmZMHmInJCU18C5CI1PVX-hcx5up4CAIBNYvIaEmJtnj1pG60mF3bgCna686kgUgK2kDIvAEs5x1_JSNsdCJnsc32354243RK263mGJzS5DblA0aQomwqlFimVB0VDY1lQg244fDbCQfKlWWwIe2S-nhsRg4KFUgf1X7Wctc_crgHZ2m9RV4-aJdQlI_CYcO2c98QyN6Aih_Wv0I3xAVqvVNbDN0wCFYumIPB_D062Y7ebvJxsZhm38xk0RKMFMKZaVmCBi8YkgR8w\"\n}"}],"_postman_id":"e085cb0d-f942-4a03-bbbd-f78c91720673"}],"id":"91859827-5d16-4353-a732-e67665bea9ab","_postman_id":"91859827-5d16-4353-a732-e67665bea9ab","description":""},{"name":"pickdetailimport","item":[{"name":"/pickdetailimport","id":"efcdefea-ab84-430b-9d8e-b37b848b72de","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","value":"{{jwt_token}}","type":"text"},{"key":"X-API-Key","value":"{{api_key}}","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"PickDetail\": [\n {\n \"CartonID\": \"DEMO66068601\",\n \"LineID\": 1,\n \"PickLocation\": \"LAR0101C\",\n \"Barcode\": \"6862019\",\n \"QuantityToPick\": 1,\n \"PickSequence\": null,\n \"ItemAlias01\": null,\n \"ItemAlias02\": null,\n \"ItemAlias03\": null,\n \"DropOffLocation\": \"DROP01\",\n \"DropOffLocationSequence\": null,\n \"ShortPickLocation\": \"SHORT01\"\n },\n {\n \"CartonID\": \"DEMO66068601\",\n \"LineID\": 2,\n \"PickLocation\": \"LAF0102D\",\n \"Barcode\": \"6861967\",\n \"QuantityToPick\": 2,\n \"PickSequence\": null,\n \"ItemAlias01\": null,\n \"ItemAlias02\": null,\n \"ItemAlias03\": null,\n \"DropOffLocation\": \"DROP01\",\n \"DropOffLocationSequence\": null,\n \"ShortPickLocation\": \"SHORT01\"\n }\n ]\n}"},"url":"https://api.mycloudpick.com/v1.0.0/pickdetailimport","urlObject":{"path":["pickdetailimport"],"host":["https://api.mycloudpick.com/v1.0.0"],"query":[],"variable":[]}},"response":[{"id":"eadabaef-4f88-4291-b303-b83ffd2ee13f","name":"200 OK","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"{jwt_token}","type":"text"},{"key":"X-API-Key","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n \"PickDetail\": [\n {\n \"CartonID\": \"DEMO76068601\",\n \"LineID\": 1,\n \"PickLocation\": \"LAR0101C\",\n \"Barcode\": \"6862019\",\n \"QuantityToPick\": 1,\n \"PickSequence\": null,\n \"ItemAlias01\": null,\n \"ItemAlias02\": null,\n \"ItemAlias03\": null,\n \"DropOffLocation\": \"DROP01\",\n \"DropOffLocationSequence\": null,\n \"ShortPickLocation\": \"SHORT01\"\n },\n {\n \"CartonID\": \"DEMO76068601\",\n \"LineID\": 2,\n \"PickLocation\": \"LAF0102D\",\n \"Barcode\": \"6861967\",\n \"QuantityToPick\": 2,\n \"PickSequence\": null,\n \"ItemAlias01\": null,\n \"ItemAlias02\": null,\n \"ItemAlias03\": null,\n \"DropOffLocation\": \"DROP01\",\n \"DropOffLocationSequence\": null,\n \"ShortPickLocation\": \"SHORT01\"\n }\n ]\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mycloudpick.com/v1.0.0/pickdetailimport"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"253"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Wed, 02 Oct 2019 21:42:07 GMT"},{"key":"x-amzn-RequestId","value":"7345403f-06bf-4365-ad9d-32e2c8afa112"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"x-amz-apigw-id","value":"A9DyxGPvoAMFeMw="},{"key":"X-Amzn-Trace-Id","value":"Root=1-5d9519ab-9f21c989f335577673b5c0c4;Sampled=0"},{"key":"X-Cache","value":"Miss from cloudfront"},{"key":"Via","value":"1.1 cd53a52a61fcb7bda797ab2120f02410.cloudfront.net (CloudFront)"},{"key":"X-Amz-Cf-Pop","value":"DFW3-C1"},{"key":"X-Amz-Cf-Id","value":"A43bFwtcQ2B-mW0h_WPrNL42AhIzIRB-KQGNWaoY2FREeWy6vgWEXg=="}],"cookie":[],"responseTime":null,"body":"{\n \"PickDetailResult\": [\n {\n \"CartonID\": \"DEMO76068601\",\n \"Result\": \"Success\",\n \"Reason\": \"Carton Imported.\"\n }\n ]\n}"}],"_postman_id":"efcdefea-ab84-430b-9d8e-b37b848b72de"}],"id":"2c1bb4b9-1c55-440d-8ef0-39953afd09ae","_postman_id":"2c1bb4b9-1c55-440d-8ef0-39953afd09ae","description":""},{"name":"query","item":[{"name":"/query PickDetail","id":"5a5355e5-6c9b-4b0d-8300-3f82767a4f4c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","value":"{{jwt_token}}","type":"text"},{"key":"X-API-Key","value":"{{api_key}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"QueryInfo\": {\r\n \"Query\": \"PickDetail\"\r\n },\r\n \"FieldSelectionInfo\": {\r\n \"FieldSelection\": null\r\n },\r\n \"RecordsInfo\": {\r\n \"RecordsFirst\": 10\r\n },\r\n \"PagingInfo\": {\r\n \"CursorValue\": \"\"\r\n },\r\n \"FilterInfo\": [\r\n {\r\n \"FilterFields\": null\r\n }\r\n ],\r\n \"GroupInfo\": [\r\n {\r\n \"GroupFields\": null\r\n }\r\n ],\r\n \"SortInfo\": [\r\n {\r\n \"SortFields\": {\r\n \"Field\": \"PD.CartonID\",\r\n \"Order\": \"ascending\"\r\n }\r\n },\r\n {\r\n \"SortFields\": {\r\n \"Field\": \"PD.LineID\",\r\n \"Order\": \"ascending\"\r\n }\r\n }\r\n ]\r\n}"},"url":"https://api.mycloudpick.com/v1.0.0/query","description":"

PickDetail Query

Review order details within CloudPick. Use this API to view the status of detail lines for an order.

PickDetail Fields

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Node Name	Description	Field Type	Example
PD.CartNumber	The cart number the line is assigned to.	String	9DC3E8F4
PD.TransactionID	Unique ID that notates a turn of the cart. Assigned by CloudPick at the time of import.	String	11921208094239811561017055846111000000247872391328
PD.ImportedDateTime	The date and time the record was imported to CloudPick.	Timestamp	2019-06-05-20.03.26.866000
PD.DisplayAddress	The internal address of the cart light this line was assigned to.	String	004
PD.CartonID	The carton identifier for the order.	String	11875173
PD.LineTransactionID	Unique ID that notates a single pick record. Assigned by CloudPick at the time of import.	String	11916410020445247061119000106277964000415084860111
PD.LineID	Unique line number for the carton ID.	Numeric	1
PD.PickLocation	The location to be used to fulfill the pick detail.	String	P15C0112B1
PD.CheckDigit	Alternate validation for the pick location.	String	X
PD.Barcode	The item the facility user will be prompted to pick.	String	P001-PGC45V
PD.QuantityToPick	The amount the facility user will be prompted to pick for the item.	Numeric	2
PD.UnitofMeasure	The unit of measure the quantity is to be picked. Defaults to EA (each).	String	EA
PD.DropOffLocation	Location the carton will be sorted to if picked complete.	String	DROP01
PD.DropOffLocationSequence	Drop off order of pick complete cartons for a cart. If blank, the sequence will be based on the drop off location.	1101
PD.ShortPickLocation	Location the carton will be sorted to if not picked complete.	String	SHORT01
PD.Sorted	Has the carton been sorted from the cart to a location.	Boolean	true
PD.LicensePlate	Specific license plate the picker will be prompted to pick units from.	String	LP123456
PD.RequestedLotNumber	Specific lot number the picker will be prompted to pick units from.	String	L18080101357
PD.CaptureLotNumber	Will the picker be prompted to capture a lot number.	Boolean	true
PD.LotNumberMask	Mask that is used to validate the lot number is correct for the item.	String	$###########
PD.RequestedSerialNumber	Specific serial number the picker will be prompted to pick.	String	1739102454
PD.PickSequence	The sequence for picking the product throughout the warehouse. If left blank, the system will default sorting to the pick location. If there are duplicate pick sequences, the system will sort by Pick Sequence followed by Pick Location.	String	12345
PD.PickZone	The zone the location resides in for picking. This will be displayed on the cart indicating which zone(s) the cart will pick product.	String	A1
PD.LightedPickLocation	Used in Light to Light picking only.	Boolean	false
PD.LightZone	Specify the zone the location resides in for lighted picking.	String	LZ1
PD.CaptureSerialNumber	Will the picker be prompted to capture a serial number.	Boolean	true
PD.SerialNumberMask	Mask that is used to validate the serial number is correct for the item.	String	#########
PD.ItemAlias01	Additional value that will be used to validate the item.	String	P001-PGC45VR
PD.ItemAlias02	Additional value that will be used to validate the item.	String	P001-PGC45VR1
PD.ItemAlias03	Additional value that will be used to validate the item.	String	P001-PGC45VR2
PD.AlternatePickLocation01	Additional picking location that may be used if the primary picking location does not contain enough inventory to fulfill the quantity to pick.	String	P15C0112C2
PD.AlternatePickLocationSeq01	Specify the sequence for picking the product throughout the warehouse. If left blank, the system will default sorting to the pick location. If there are duplicate pick sequences, the system will sort by Pick Sequence followed by Pick Location.	String	1423
PD.AlternatePickLocationUsed01	Was this alternate picking location used to fulfill the pick.	Boolean	true
PD.AlternatePickLocation02	Additional picking location that may be used if the primary picking location does not contain enough inventory to fulfill the quantity to pick.	String	P16D0112B1
PD.AlternatePickLocationSeq02	Specify the sequence for picking the product throughout the warehouse. If left blank, the system will default sorting to the pick location. If there are duplicate pick sequences, the system will sort by Pick Sequence followed by Pick Location.	String	15236
PD.AlternatePickLocationUsed02	Was this alternate picking location used to fulfill the pick.	Boolean	false
PD.AlternatePickLocation03	Additional picking location that may be used if the primary picking location does not contain enough inventory to fulfill the quantity to pick.	String	P17A0232G1
PD.AlternatePickLocationSeq03	Specify the sequence for picking the product throughout the warehouse. If left blank, the system will default sorting to the pick location. If there are duplicate pick sequences, the system will sort by Pick Sequence followed by Pick Location.	String	12451
PD.AlternatePickLocationUsed03	Was this alternate picking location used to fulfill the pick.	Boolean	false
PD.RecordStatus	The status of the record.	String	Picked
PD.QuantityPicked	The amount that was picked for the item.	Numeric	2
PD.QuantityShortPicked	The amount that was not picked for the item.	Numeric	1
PD.LocationPickedFrom	The location the item was picked from.	String	P15C0112B1
PD.CapturedLotNumber	The lot number that was captured for the item.	String	L18080101357
PD.CapturedSerialNumber	The serial number that was captured for the item.	String	1739102454
PD.ValidatedBarcode	The barcode that was used to validate the item number.	String	P001-PGC45V
PD.LoadedBy	The user that loaded the carton to the cart.	String	JOHND
PD.LoadedDateTime	The timestamp the carton was loaded to the cart.	Timestamp	2019-06-06-21.15.40.646000
PD.PickedBy	The user that picked the carton.	String	JANED
PD.PickedDateTime	The timestamp the carton was picked.	Timestamp	2019-06-06-21.17.43.433000
PD.EmptyBin	The facility user flagged this location as being empty during picking.	Boolean	false
PD.SkippedLocation	The facility user skipped the location validation.	Boolean	false
PD.SkippedBarcode	The facility user skipped the barcode validation.	Boolean	false
PD.SkippedLicensePlate	The facility user skipped the license plate validation.	Boolean	false
PD.ModifiedBy	The last user to modify the record.	String	JOHND
PD.ModifiedTime	The date and time of the last modification to this record.	Timestamp	2019-07-08-21.44.28.390000

","urlObject":{"path":["query"],"host":["https://api.mycloudpick.com/v1.0.0"],"query":[],"variable":[]}},"response":[{"id":"d2235a9a-7d48-4bc8-9a71-61532935b0c1","name":"\\query PickDetail 200 OK","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"{jwt_token}","type":"text"},{"key":"X-API-Key","value":"{api_key}","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"QueryInfo\": {\r\n \"Query\": \"PickDetail\"\r\n },\r\n \"FieldSelectionInfo\": {\r\n \"FieldSelection\": null\r\n },\r\n \"RecordsInfo\": {\r\n \"RecordsFirst\": 10\r\n },\r\n \"PagingInfo\": {\r\n \"CursorValue\": \"\"\r\n },\r\n \"FilterInfo\": [\r\n {\r\n \"FilterFields\": {\r\n \"Field\": \"PD.CartonID\",\r\n \"Comparator\": \"list:DEMO96068601:DEMO66068601\"\r\n }\r\n }\r\n ],\r\n \"GroupInfo\": [\r\n {\r\n \"GroupFields\": null\r\n }\r\n ],\r\n \"SortInfo\": [\r\n {\r\n \"SortFields\": {\r\n \"Field\": \"PD.CartonID\",\r\n \"Order\": \"ascending\"\r\n }\r\n },\r\n {\r\n \"SortFields\": {\r\n \"Field\": \"PD.LineID\",\r\n \"Order\": \"ascending\"\r\n }\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mycloudpick.com/v1.0.0/query"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"12162"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Wed, 02 Oct 2019 19:19:33 GMT"},{"key":"x-amzn-RequestId","value":"746dae0d-fc38-4429-a7f5-4b6c8210584a"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"x-amz-apigw-id","value":"A8u3fHiQoAMF9Gg="},{"key":"X-Amzn-Trace-Id","value":"Root=1-5d94f82f-23c243c6d3dc0a1c766e1cb0;Sampled=0"},{"key":"X-Cache","value":"Miss from cloudfront"},{"key":"Via","value":"1.1 65e0dddfab85d662d8e8e79caa7a5fe4.cloudfront.net (CloudFront)"},{"key":"X-Amz-Cf-Pop","value":"DFW53"},{"key":"X-Amz-Cf-Id","value":"mUMnclPTh5RDAKS4pmQM1bZaEDwQK5jJFQp5IsERvDBP_GJPv79e1w=="}],"cookie":[],"responseTime":null,"body":"{\r\n \"Data\": {\r\n \"Results\": [\r\n {\r\n \"Result\": {\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"ImportedDateTime\": \"2019-09-04-14.55.23.433000\",\r\n \"DisplayAddress\": \"001\",\r\n \"CartonID\": \"DEMO66068601\",\r\n \"LineTransactionID\": \"11924709552133610361114000108248822700575266439725\",\r\n \"LineID\": 1,\r\n \"PickLocation\": \"LAR0101C\",\r\n \"CheckDigit\": \"\",\r\n \"Barcode\": \"6860105302019\",\r\n \"QuantityToPick\": 1,\r\n \"UnitofMeasure\": \"\",\r\n \"DropOffLocation\": \"DROP01\",\r\n \"DropOffLocationSequence\": \"\",\r\n \"ShortPickLocation\": \"SHORT01\",\r\n \"Sorted\": false,\r\n \"LicensePlate\": \"\",\r\n \"RequestedLotNumber\": \"\",\r\n \"CaptureLotNumber\": false,\r\n \"LotNumberMask\": \"\",\r\n \"RequestedSerialNumber\": \"\",\r\n \"PickSequence\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightedPickLocation\": false,\r\n \"LightZone\": \"\",\r\n \"CaptureSerialNumber\": false,\r\n \"SerialNumberMask\": \"\",\r\n \"ItemAlias01\": \"\",\r\n \"ItemAlias02\": \"\",\r\n \"ItemAlias03\": \"\",\r\n \"AlternatePickLocation01\": \"\",\r\n \"AlternatePickLocationSeq01\": \"\",\r\n \"AlternatePickLocationUsed01\": false,\r\n \"AlternatePickLocation02\": \"\",\r\n \"AlternatePickLocationSeq02\": \"\",\r\n \"AlternatePickLocationUsed02\": false,\r\n \"AlternatePickLocation03\": \"\",\r\n \"AlternatePickLocationSeq03\": \"\",\r\n \"AlternatePickLocationUsed03\": false,\r\n \"RecordStatus\": \"Loaded\",\r\n \"QuantityPicked\": 0,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"\",\r\n \"LoadedBy\": \"JOHND\",\r\n \"LoadedDateTime\": \"2019-09-06-15.21.01.312000\",\r\n \"PickedBy\": \"\",\r\n \"PickedDateTime\": null,\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ShrtpckVld-Location\": false,\r\n \"ShrtpckVld-Barcode\": false,\r\n \"ShrtpckVld-Lic Plate\": false,\r\n \"ShrtpckVld-Lot\": false,\r\n \"ShrtpckVld-SerialNumber\": false,\r\n \"ExportedDateTime\": null,\r\n \"ModifiedTime\": \"2019-09-06-15.21.01.312000\",\r\n \"ModifiedBy\": \"\"\r\n },\r\n \"CursorValue\": \"xMXU1vb28Pb49vDxQEBAQEBAQEDw8PDw8PE=\"\r\n },\r\n {\r\n \"Result\": {\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"ImportedDateTime\": \"2019-09-04-14.55.23.715000\",\r\n \"DisplayAddress\": \"001\",\r\n \"CartonID\": \"DEMO66068601\",\r\n \"LineTransactionID\": \"11924709552141316561114000108248822700575266322731\",\r\n \"LineID\": 2,\r\n \"PickLocation\": \"LAF0102D\",\r\n \"CheckDigit\": \"\",\r\n \"Barcode\": \"6860108251967\",\r\n \"QuantityToPick\": 1,\r\n \"UnitofMeasure\": \"\",\r\n \"DropOffLocation\": \"DROP01\",\r\n \"DropOffLocationSequence\": \"\",\r\n \"ShortPickLocation\": \"SHORT01\",\r\n \"Sorted\": false,\r\n \"LicensePlate\": \"\",\r\n \"RequestedLotNumber\": \"\",\r\n \"CaptureLotNumber\": false,\r\n \"LotNumberMask\": \"\",\r\n \"RequestedSerialNumber\": \"\",\r\n \"PickSequence\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightedPickLocation\": false,\r\n \"LightZone\": \"\",\r\n \"CaptureSerialNumber\": false,\r\n \"SerialNumberMask\": \"\",\r\n \"ItemAlias01\": \"\",\r\n \"ItemAlias02\": \"\",\r\n \"ItemAlias03\": \"\",\r\n \"AlternatePickLocation01\": \"\",\r\n \"AlternatePickLocationSeq01\": \"\",\r\n \"AlternatePickLocationUsed01\": false,\r\n \"AlternatePickLocation02\": \"\",\r\n \"AlternatePickLocationSeq02\": \"\",\r\n \"AlternatePickLocationUsed02\": false,\r\n \"AlternatePickLocation03\": \"\",\r\n \"AlternatePickLocationSeq03\": \"\",\r\n \"AlternatePickLocationUsed03\": false,\r\n \"RecordStatus\": \"Picked\",\r\n \"QuantityPicked\": 1,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"LAF0102D\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"6860108251967\",\r\n \"LoadedBy\": \"JOHND\",\r\n \"LoadedDateTime\": \"2019-09-06-15.21.01.420000\",\r\n \"PickedBy\": \"JOHND\",\r\n \"PickedDateTime\": \"2019-09-06-15.46.22.378000\",\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ShrtpckVld-Location\": false,\r\n \"ShrtpckVld-Barcode\": false,\r\n \"ShrtpckVld-Lic Plate\": false,\r\n \"ShrtpckVld-Lot\": false,\r\n \"ShrtpckVld-SerialNumber\": false,\r\n \"ExportedDateTime\": null,\r\n \"ModifiedTime\": \"2019-09-06-15.46.22.378000\",\r\n \"ModifiedBy\": \"\"\r\n },\r\n \"CursorValue\": \"xMXU1vb28Pb49vDxQEBAQEBAQEDw8PDw8PI=\"\r\n },\r\n {\r\n \"Result\": {\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"ImportedDateTime\": \"2019-09-04-14.55.23.715000\",\r\n \"DisplayAddress\": \"001\",\r\n \"CartonID\": \"DEMO66068601\",\r\n \"LineTransactionID\": \"11924910462237856161523155936111000000237742647286\",\r\n \"LineID\": 2,\r\n \"PickLocation\": \"LAF0102D\",\r\n \"CheckDigit\": \"\",\r\n \"Barcode\": \"6860108251967\",\r\n \"QuantityToPick\": 1,\r\n \"UnitofMeasure\": \"\",\r\n \"DropOffLocation\": \"DROP01\",\r\n \"DropOffLocationSequence\": \"\",\r\n \"ShortPickLocation\": \"SHORT01\",\r\n \"Sorted\": false,\r\n \"LicensePlate\": \"\",\r\n \"RequestedLotNumber\": \"\",\r\n \"CaptureLotNumber\": false,\r\n \"LotNumberMask\": \"\",\r\n \"RequestedSerialNumber\": \"\",\r\n \"PickSequence\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightedPickLocation\": false,\r\n \"LightZone\": \"\",\r\n \"CaptureSerialNumber\": false,\r\n \"SerialNumberMask\": \"\",\r\n \"ItemAlias01\": \"\",\r\n \"ItemAlias02\": \"\",\r\n \"ItemAlias03\": \"\",\r\n \"AlternatePickLocation01\": \"\",\r\n \"AlternatePickLocationSeq01\": \"\",\r\n \"AlternatePickLocationUsed01\": false,\r\n \"AlternatePickLocation02\": \"\",\r\n \"AlternatePickLocationSeq02\": \"\",\r\n \"AlternatePickLocationUsed02\": false,\r\n \"AlternatePickLocation03\": \"\",\r\n \"AlternatePickLocationSeq03\": \"\",\r\n \"AlternatePickLocationUsed03\": false,\r\n \"RecordStatus\": \"PickedShort\",\r\n \"QuantityPicked\": 0,\r\n \"QuantityShortPicked\": 1,\r\n \"LocationPickedFrom\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"\",\r\n \"LoadedBy\": \"JOHND\",\r\n \"LoadedDateTime\": \"2019-09-06-15.21.01.420000\",\r\n \"PickedBy\": \"\",\r\n \"PickedDateTime\": null,\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ShrtpckVld-Location\": false,\r\n \"ShrtpckVld-Barcode\": false,\r\n \"ShrtpckVld-Lic Plate\": false,\r\n \"ShrtpckVld-Lot\": false,\r\n \"ShrtpckVld-SerialNumber\": false,\r\n \"ExportedDateTime\": null,\r\n \"ModifiedTime\": \"2019-09-06-15.46.22.378000\",\r\n \"ModifiedBy\": \"\"\r\n },\r\n \"CursorValue\": \"xMXU1vb28Pb49vDxQEBAQEBAQEDw8PDw8PI=\"\r\n },\r\n {\r\n \"Result\": {\r\n \"CartNumber\": \"\",\r\n \"TransactionID\": \"\",\r\n \"ImportedDateTime\": \"2019-10-02-14.55.15.576000\",\r\n \"DisplayAddress\": \"\",\r\n \"CartonID\": \"DEMO96068601\",\r\n \"LineTransactionID\": \"11927509551461599861114000108248822700974127496279\",\r\n \"LineID\": 1,\r\n \"PickLocation\": \"LAR0101C\",\r\n \"CheckDigit\": \"\",\r\n \"Barcode\": \"6862019\",\r\n \"QuantityToPick\": 1,\r\n \"UnitofMeasure\": \"\",\r\n \"DropOffLocation\": \"DROP01\",\r\n \"DropOffLocationSequence\": \"\",\r\n \"ShortPickLocation\": \"SHORT01\",\r\n \"Sorted\": false,\r\n \"LicensePlate\": \"\",\r\n \"RequestedLotNumber\": \"\",\r\n \"CaptureLotNumber\": false,\r\n \"LotNumberMask\": \"\",\r\n \"RequestedSerialNumber\": \"\",\r\n \"PickSequence\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightedPickLocation\": false,\r\n \"LightZone\": \"\",\r\n \"CaptureSerialNumber\": false,\r\n \"SerialNumberMask\": \"\",\r\n \"ItemAlias01\": \"\",\r\n \"ItemAlias02\": \"\",\r\n \"ItemAlias03\": \"\",\r\n \"AlternatePickLocation01\": \"\",\r\n \"AlternatePickLocationSeq01\": \"\",\r\n \"AlternatePickLocationUsed01\": false,\r\n \"AlternatePickLocation02\": \"\",\r\n \"AlternatePickLocationSeq02\": \"\",\r\n \"AlternatePickLocationUsed02\": false,\r\n \"AlternatePickLocation03\": \"\",\r\n \"AlternatePickLocationSeq03\": \"\",\r\n \"AlternatePickLocationUsed03\": false,\r\n \"RecordStatus\": \"Imported\",\r\n \"QuantityPicked\": 0,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"\",\r\n \"LoadedBy\": \"\",\r\n \"LoadedDateTime\": null,\r\n \"PickedBy\": \"\",\r\n \"PickedDateTime\": null,\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ShrtpckVld-Location\": false,\r\n \"ShrtpckVld-Barcode\": false,\r\n \"ShrtpckVld-Lic Plate\": false,\r\n \"ShrtpckVld-Lot\": false,\r\n \"ShrtpckVld-SerialNumber\": false,\r\n \"ExportedDateTime\": null,\r\n \"ModifiedTime\": \"2019-10-02-14.55.15.575000\",\r\n \"ModifiedBy\": \"\"\r\n },\r\n \"CursorValue\": \"xMXU1vn28Pb49vDxQEBAQEBAQEDw8PDw8PE=\"\r\n },\r\n {\r\n \"Result\": {\r\n \"CartNumber\": \"\",\r\n \"TransactionID\": \"\",\r\n \"ImportedDateTime\": \"2019-10-02-14.55.15.617000\",\r\n \"DisplayAddress\": \"\",\r\n \"CartonID\": \"DEMO96068601\",\r\n \"LineTransactionID\": \"11927509551462723661114000108248822700974127674006\",\r\n \"LineID\": 2,\r\n \"PickLocation\": \"LAF0102D\",\r\n \"CheckDigit\": \"\",\r\n \"Barcode\": \"6861967\",\r\n \"QuantityToPick\": 2,\r\n \"UnitofMeasure\": \"\",\r\n \"DropOffLocation\": \"DROP01\",\r\n \"DropOffLocationSequence\": \"\",\r\n \"ShortPickLocation\": \"SHORT01\",\r\n \"Sorted\": false,\r\n \"LicensePlate\": \"\",\r\n \"RequestedLotNumber\": \"\",\r\n \"CaptureLotNumber\": false,\r\n \"LotNumberMask\": \"\",\r\n \"RequestedSerialNumber\": \"\",\r\n \"PickSequence\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightedPickLocation\": false,\r\n \"LightZone\": \"\",\r\n \"CaptureSerialNumber\": false,\r\n \"SerialNumberMask\": \"\",\r\n \"ItemAlias01\": \"\",\r\n \"ItemAlias02\": \"\",\r\n \"ItemAlias03\": \"\",\r\n \"AlternatePickLocation01\": \"\",\r\n \"AlternatePickLocationSeq01\": \"\",\r\n \"AlternatePickLocationUsed01\": false,\r\n \"AlternatePickLocation02\": \"\",\r\n \"AlternatePickLocationSeq02\": \"\",\r\n \"AlternatePickLocationUsed02\": false,\r\n \"AlternatePickLocation03\": \"\",\r\n \"AlternatePickLocationSeq03\": \"\",\r\n \"AlternatePickLocationUsed03\": false,\r\n \"RecordStatus\": \"Imported\",\r\n \"QuantityPicked\": 0,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"\",\r\n \"LoadedBy\": \"\",\r\n \"LoadedDateTime\": null,\r\n \"PickedBy\": \"\",\r\n \"PickedDateTime\": null,\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ShrtpckVld-Location\": false,\r\n \"ShrtpckVld-Barcode\": false,\r\n \"ShrtpckVld-Lic Plate\": false,\r\n \"ShrtpckVld-Lot\": false,\r\n \"ShrtpckVld-SerialNumber\": false,\r\n \"ExportedDateTime\": null,\r\n \"ModifiedTime\": \"2019-10-02-14.55.15.617000\",\r\n \"ModifiedBy\": \"\"\r\n },\r\n \"CursorValue\": \"xMXU1vn28Pb49vDxQEBAQEBAQEDw8PDw8PI=\"\r\n }\r\n ],\r\n \"PagingInfo\": {\r\n \"LastCursorValue\": \"xMXU1vn28Pb49vDxQEBAQEBAQEDw8PDw8PI=\",\r\n \"HasNextPage\": false\r\n }\r\n }\r\n}"}],"_postman_id":"5a5355e5-6c9b-4b0d-8300-3f82767a4f4c"},{"name":"/query PickLedger","id":"05b44fea-9744-4555-ad15-e18948aeea55","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","value":"{{jwt_token}}","type":"text"},{"key":"X-API-Key","value":"{{api_key}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"QueryInfo\":{\r\n \"Query\":\"PickLedger\"\r\n },\r\n \"FieldSelectionInfo\":{\r\n \"FieldSelection\": null\r\n },\r\n \"RecordsInfo\":{\r\n \"RecordsFirst\": 30\r\n },\r\n \"PagingInfo\":{\r\n \"CursorValue\": null\r\n },\r\n \"FilterInfo\":[\r\n {\r\n \"FilterFields\": {\r\n \"Field\":\"PL.CartonID\",\r\n \"Comparator\":\"eq:DEMO66068601\"\r\n }\r\n },\r\n {\r\n \t\t\"FilterFields\": {\r\n \"Field\":\"PL.Transaction\",\r\n \"Comparator\":\"eq:Imported\"\r\n \t\t}\r\n }\r\n ],\r\n \"SortInfo\":[\r\n {\r\n \"SortFields\":{\r\n \"Field\":\"PL.ModifiedTime\",\r\n \"Order\":\"descending\"\r\n }\r\n }\r\n ]\r\n }"},"url":"https://api.mycloudpick.com/v1.0.0/query","description":"

PickLedger Query

Review order details within CloudPick. Use this API to view the status of detail lines for an order.

PickLedger Fields

Node Name	Description	Field Type	Example
PL.TransactionID	Unique ID that notates a turn of the cart. Assigned by CloudPick at the time of load cart.	String	119157161527283243261523155936111000000874216250368
PL.CartonID	The carton identifier for the order.	String	11875173
PL.LineID	Unique line number for the carton ID.	Numeric	1
PL.LineTransactionID	Unique ID that notates a single pick record. Assigned by CloudPick at the time of import.	String	1191641002044524706111984734106277964000415084860111
PL.CartNumber	The cart number the carton was assigned to.	String	9DC3E8F4
PL.DisplayAddress	The internal address of the cart light this line was assigned to.	String	004
PL.Barcode	The item the facility user was prompted to pick.	String	090222871434
PL.PickLocation	The location to be used to fulfill the pick.	String	P15C0112B1
PL.Transaction	The transaction that was performed for this event.	String	Imported Loaded Picked ShortPicked Sorted Completed
PL.QuantityPicked	The amount that was picked for the item.	Numeric	2
PL.QuantityShortPicked	The amount that was not picked for the item.	Numeric	0
PL.LocationPickedFrom	The location the quantity was picked from.	String	P15C0112B1
PL.DropOffLocation	The area where the carton was dropped off.	String	DROP001
PL.ShortPickLocation	The area where the carton was dropped off due to a short pick.	String	SHORT01
PL.PickZone	The zone the location resides in for picking. This will be displayed on the cart indicating which zone(s) the cart will pick product.	String	A1
PL.LightZone	Specify the zone the location resides in for lighted picking.	String	LZ1
PL.CapturedLotNumber	The lot number that was captured for the item.	String	L18080101357
PL.CapturedSerialNumber	The serial number that was captured for the item.	String	1739102454
PL.ValidatedBarcode	The barcode that was used to validate the item number.	String	P001-PGC45V
PL.UserID	The User ID of the facility user that processed the record.	Numeric	343121
PL.UserLogin	The facility user that processed the record.	String	JOHND
PL.ModifiedTime	The date and time of the last modification to this record.	Timestamp	2019-07-08-21.44.28.390000
PL.EmptyBin	The facility user flagged this location as being empty during picking.	Boolean	false
PL.SkippedLocation	The facility user skipped the location validation.	Boolean	false
PL.SkippedBarcode	The facility user skipped the barcode validation.	Boolean	false
PL.SkippedLicensePlate	The facility user skipped the license plate validation.	Boolean	false
PL.ExportedDateTime	The date and time of when this record was exported.	Timestamp	2019-07-08-21.44.28.390000

","urlObject":{"path":["query"],"host":["https://api.mycloudpick.com/v1.0.0"],"query":[],"variable":[]}},"response":[{"id":"b2955798-242b-443b-a91d-d236799dae59","name":"/query PickLedger 200 OK","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{jwt_token}"},{"key":"X-API-Key","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\r\n \"QueryInfo\":{\r\n \"Query\":\"PickLedger\"\r\n },\r\n \"FieldSelectionInfo\":{\r\n \"FieldSelection\": null\r\n },\r\n \"RecordsInfo\":{\r\n \"RecordsFirst\": 30\r\n },\r\n \"PagingInfo\":{\r\n \"CursorValue\": null\r\n },\r\n \"FilterInfo\":[\r\n {\r\n \"FilterFields\": {\r\n \"Field\":\"PL.Transaction\",\r\n \"Comparator\":\"eq:Picked\"\r\n },\r\n \"Field\":\"PL.UserID\",\r\n \"Comparator\":\"eq:DREWJ\"\r\n }\r\n ],\r\n \"SortInfo\":[\r\n {\r\n \"SortFields\":{\r\n \"Field\":\"PL.ModifiedTime\",\r\n \"Order\":\"descending\"\r\n }\r\n }\r\n ]\r\n }","options":{"raw":{"language":"json"}}},"url":"https://api.mycloudpick.com/v1.0.0/query"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"3264"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Wed, 02 Oct 2019 19:44:44 GMT"},{"key":"x-amzn-RequestId","value":"d835e838-0ba8-4e5b-8300-8fa9983c2573"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"x-amz-apigw-id","value":"A8ymZFzxoAMFZPA="},{"key":"X-Amzn-Trace-Id","value":"Root=1-5d94fe28-ee26dc52c2a27842fb1eca80;Sampled=0"},{"key":"X-Cache","value":"Miss from cloudfront"},{"key":"Via","value":"1.1 c650b968d15de7f70750f5bb6bd4f469.cloudfront.net (CloudFront)"},{"key":"X-Amz-Cf-Pop","value":"DFW50-C1"},{"key":"X-Amz-Cf-Id","value":"DmrCkw0smLAgjRfH1qu0sqOQbn5bGpxuyjrv3TeUv8G8TnWbS5pk5g=="}],"cookie":[],"responseTime":null,"body":"{\r\n \"Data\": {\r\n \"Results\": [\r\n {\r\n \"Result\": {\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"CartonID\": \"DEMO66068604\",\r\n \"LineID\": 1,\r\n \"LineTransactionID\": \"11924709552168305761114000108248822700575266172868\",\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"DisplayAddress\": \"006\",\r\n \"Barcode\": \"6860106021942\",\r\n \"PickLocation\": \"LAF0103E\",\r\n \"Transaction\": \"Picked\",\r\n \"QuantityPicked\": 2,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"LAF0103E\",\r\n \"DropOffLocation\": \"\",\r\n \"ShortPickLocation\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightZone\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"6860106021942\",\r\n \"UserID\": 2818042022,\r\n \"UserLogin\": \"JOHND\",\r\n \"ModifiedTime\": \"2019-09-06-15.46.41.170000\",\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ExportedDateTime\": null\r\n }\r\n },\r\n {\r\n \"Result\": {\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"CartonID\": \"DEMO66068601\",\r\n \"LineID\": 2,\r\n \"LineTransactionID\": \"11924709552141316561114000108248822700575266322731\",\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"DisplayAddress\": \"001\",\r\n \"Barcode\": \"6860108251967\",\r\n \"PickLocation\": \"LAF0102D\",\r\n \"Transaction\": \"Picked\",\r\n \"QuantityPicked\": 1,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"LAF0102D\",\r\n \"DropOffLocation\": \"\",\r\n \"ShortPickLocation\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightZone\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"6860108251967\",\r\n \"UserID\": 2818042022,\r\n \"UserLogin\": \"JOHND\",\r\n \"ModifiedTime\": \"2019-09-06-15.46.22.378000\",\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ExportedDateTime\": null\r\n }\r\n },\r\n {\r\n \"Result\": {\r\n \"TransactionID\": \"11924910210126833861523155936111000000237742792158\",\r\n \"CartonID\": \"DEMO66068603\",\r\n \"LineID\": 1,\r\n \"LineTransactionID\": \"11924709552161677161114000108248822700575266818173\",\r\n \"CartNumber\": \"0E1CEB52\",\r\n \"DisplayAddress\": \"003\",\r\n \"Barcode\": \"6860110041945\",\r\n \"PickLocation\": \"LAD0102F\",\r\n \"Transaction\": \"Picked\",\r\n \"QuantityPicked\": 1,\r\n \"QuantityShortPicked\": 0,\r\n \"LocationPickedFrom\": \"LAD0102F\",\r\n \"DropOffLocation\": \"\",\r\n \"ShortPickLocation\": \"\",\r\n \"PickZone\": \"\",\r\n \"LightZone\": \"\",\r\n \"CapturedLotNumber\": \"\",\r\n \"CapturedSerialNumber\": \"\",\r\n \"ValidatedBarcode\": \"6860110041945\",\r\n \"UserID\": 2818042022,\r\n \"UserLogin\": \"JOHND\",\r\n \"ModifiedTime\": \"2019-09-06-15.46.03.056000\",\r\n \"EmptyBin\": false,\r\n \"SkippedLocation\": false,\r\n \"SkippedBarcode\": false,\r\n \"SkippedLicensePlate\": false,\r\n \"ExportedDateTime\": null\r\n }\r\n }\r\n ]\r\n }\r\n}"}],"_postman_id":"05b44fea-9744-4555-ad15-e18948aeea55"}],"id":"a10f3184-f51d-4852-9998-e2a344567770","_postman_id":"a10f3184-f51d-4852-9998-e2a344567770","description":""}],"event":[{"listen":"prerequest","script":{"id":"243e008c-7f27-4684-a983-99ae1dacebb2","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"d2efa1d5-6e17-4422-8e2e-f71fb38cabcd","type":"text/javascript","exec":[""]}}],"variable":[{"key":"url","value":"https://api.mycloudpick.com/v1.0.0"},{"key":"dev.url","value":"https://polmuschbb.execute-api.us-east-1.amazonaws.com/dev"}]}