api/Lot/Query (POST)
Queries existing Lots using the provided query data.
HTTP Method: POST
Required Fields: At least one field as search criteria
Requires an Authentication Token in the AuthToken HTTP header. Authentication Tokens are obtained from api/Security/Login (POST).
Returns all found Lots.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| RequestData | This is a JSON object containing Lot query data.
Query Single Lot Using Key Fields Example:
{
"PART_ID": "MOTOR003",
"LOT_ID": "MTR3-007-42"
}
Returns 1 Lot if successful.
This is like 'Find' in Expandable.
Query Multiple Lots Using Other Fields Example:
{
"LOT_STATUS": "E",
"LOT_TYPE": "M"
}
Returns 1 or more Lots if successful.
This is like 'QBE' in Expandable.
Query Multiple Lots Using QBE Conditional Notation Example:
{
"PART_ID": "MOTOR003",
"LOT_STATUS": "IN 'A','C'"
}
Returns 1 or more Lots if successful.
This is like 'QBE' in Expandable.
Accepted Lot Fields:
CREATED_BY, DATE_CREATED, DATE_LAST_ISSUE, DATE_LAST_RECPT,
DATE_LAST_UPDT, DATE_MODIFIED, DILUTION, DWG_REV,
ECN, EXPIRE_DATE, LINE_NUMBER, LOT_HOLD_CODE,
LOT_ID, LOT_STATUS, LOT_TYPE, LTFLM_USER_1,
LTFLM_USER_2, LTFLM_USER_3, LTFLM_USER_4, LTFLM_USER_5,
LTFLM_USER_6, LTFLM_USER_7, LTFLM_USER_8, LTFLM_USER_9,
LTFLM_USER_10, LTFLM_USER_11, LTFLM_USER_12, LTFLM_USER_13,
LTFLM_USER_14, LTFLM_USER_15, LTFLM_USER_16, LTFLM_USER_17,
LTFLM_USER_18, LTFLM_USER_19, LTFLM_USER_20, LTFLM_USER_21,
LTFLM_USER_22, LTFLM_USER_23, LTFLM_USER_24, LTFLM_USER_25,
LTFLM_USER_26, LTFLM_USER_27, LTFLM_USER_28, LTFLM_USER_29,
LTFLM_USER_30, LTFLM_USER_31, LTFLM_USER_32, MFG_ID,
MFG_LOT_ID, MFG_NAME, MFG_VENDOR_ID, MODIFIED_BY,
OPERATOR_ID, ORDER_ID, ORIGINAL_QTY, PART_ID,
POTENCY, RETEST_DATE, TIME_LAST_UPDT, TXN_NOTE |
Define this parameter in the request body. |
Response Information
Success:200/OK
Body contains JSON array with found Lots.
Error:
400/Request JSON is invalid.
401/AuthToken was not provided.
401/AuthToken is malformed.
401/AuthToken is expired.
401/AuthToken login failure.
500/(Message)
Body contains JSON object with Message and MessageCode.
Returned Lot Fields:
ATTACHMENTS, CREATED_BY, DATE_CREATED, DATE_LAST_ISSUE, DATE_LAST_RECPT, DATE_LAST_UPDT, DATE_MODIFIED, DILUTION, DWG_REV, ECN, EXPIRE_DATE, LINE_NUMBER, LOT_HOLD_CODE, LOT_ID, LOT_STATUS, LOT_TYPE, LTFLM_USER_1, LTFLM_USER_2, LTFLM_USER_3, LTFLM_USER_4, LTFLM_USER_5, LTFLM_USER_6, LTFLM_USER_7, LTFLM_USER_8, LTFLM_USER_9, LTFLM_USER_10, LTFLM_USER_11, LTFLM_USER_12, LTFLM_USER_13, LTFLM_USER_14, LTFLM_USER_15, LTFLM_USER_16, LTFLM_USER_17, LTFLM_USER_18, LTFLM_USER_19, LTFLM_USER_20, LTFLM_USER_21, LTFLM_USER_22, LTFLM_USER_23, LTFLM_USER_24, LTFLM_USER_25, LTFLM_USER_26, LTFLM_USER_27, LTFLM_USER_28, LTFLM_USER_29, LTFLM_USER_30, LTFLM_USER_31, LTFLM_USER_32, MFG_ID, MFG_LOT_ID, MFG_NAME, MFG_VENDOR_ID, MODIFIED_BY, NOTES, OPERATOR_ID, ORDER_ID, ORIGINAL_QTY, PART_ID, POTENCY, RETEST_DATE, TIME_LAST_UPDT, TXN_NOTE