Sales Order, Query
Queries existing Sales Orders using the provided criteria and returns a list of found Sales Orders.
URL
/api/sales-order-query
Request Method
POST
Expandable Program
Sales Order Editor (SOEOE)
Required Fields
HEADER:
(at least one field to be used as query criteria if none in LINES)
AUTH_TOKEN
LINES:
(at least one field to be used as query criteria if none in HEADER)
(at least one field to be used as query criteria if none in LINES)
AUTH_TOKEN
LINES:
(at least one field to be used as query criteria if none in HEADER)
Auth Token
This API call requires an Authentication Token ("Auth Token") for the required field AUTH_TOKEN. Auth Tokens are obtained from Auth Token, Get.
Example Request JSON
{
"CUSTOMER_ID": "ABCCORP",
"LINES": {
"PART_ID": "MOTOR003"
},
"AUTH_TOKEN": ""
}Full Request JSON
{
"SO_ID": "",
"SO_TYPE": "",
"CUSTOMER_ID": "",
"SHIP_TO_CUST": "",
"ORDER_DATE": "",
"ORDER_CLASS": "",
"CHANGE_NO": "",
"CHANGE_DATE": "",
"CHANGE_CODE": "",
"BILL_TO_CUST": "",
"CUST_PO_ID": "",
"CONFIRMED_TO": "",
"REFERENCE": "",
"SALESMAN_ID": "",
"SALES_REGION": "",
"TERMS_CODE": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"TAX_CODE": "",
"ORDER_DISC_PCT": "",
"CURR_CODE": "",
"CURR_RATE": "",
"ORDER_TAKER": "",
"ATTENTION": "",
"SO_HOLD": "",
"SO_ORDER_CAT": "",
"SO_STATUS": "",
"PAYMENT_TYPE": "",
"BANK_CARD_GUID": "",
"CARD_TYPE": "",
"BANK_CARD_ID": "",
"EXPIRATION": "",
"TRANS_TYPE": "",
"AUTH_CODE": "",
"DATE_LAST_PRINT": "",
"DATE_APPROVED": "",
"DATE_LAST_SHIP": "",
"SHIP_NOTE_1": "",
"SHIP_NOTE_2": "",
"DELAY_INVOICE": "",
"DELAY_DAYS": "",
"SOFOM_USER_1": "",
"SOFOM_USER_2": "",
"SOFOM_USER_3": "",
"SOFOM_USER_4": "",
"SOFOM_USER_5": "",
"SOFOM_USER_6": "",
"SOFOM_USER_7": "",
"SOFOM_USER_8": "",
"SOFOM_USER_9": "",
"SOFOM_USER_10": "",
"SOFOM_USER_11": "",
"SOFOM_USER_12": "",
"SOFOM_USER_13": "",
"SOFOM_USER_14": "",
"SOFOM_USER_15": "",
"SOFOM_USER_16": "",
"SOFOM_USER_17": "",
"SOFOM_USER_18": "",
"SOFOM_USER_19": "",
"SOFOM_USER_20": "",
"SOFOM_USER_21": "",
"SOFOM_USER_22": "",
"SOFOM_USER_23": "",
"SOFOM_USER_24": "",
"SOFOM_USER_25": "",
"SOFOM_USER_26": "",
"SOFOM_USER_27": "",
"SOFOM_USER_28": "",
"SOFOM_USER_29": "",
"SOFOM_USER_30": "",
"SOFOM_USER_31": "",
"SOFOM_USER_32": "",
"SOFOM_USER_33": "",
"SOFOM_USER_34": "",
"SOFOM_USER_35": "",
"SOFOM_USER_36": "",
"SOFOM_USER_37": "",
"SOFOM_USER_38": "",
"SOFOM_USER_39": "",
"SOFOM_USER_40": "",
"SOFOM_USER_41": "",
"SOFOM_USER_42": "",
"SOFOM_USER_43": "",
"SOFOM_USER_44": "",
"SOFOM_USER_45": "",
"SOFOM_USER_46": "",
"SOFOM_USER_47": "",
"SOFOM_USER_48": "",
"SOFOM_USER_49": "",
"SOFOM_USER_50": "",
"SOFOM_USER_51": "",
"SOFOM_USER_52": "",
"SOFOM_USER_53": "",
"SOFOM_USER_54": "",
"SOFOM_USER_55": "",
"SOFOM_USER_56": "",
"SOFOM_USER_57": "",
"SOFOM_USER_58": "",
"SOFOM_USER_59": "",
"SOFOM_USER_60": "",
"SOFOM_USER_61": "",
"SOFOM_USER_62": "",
"SOFOM_USER_63": "",
"SOFOM_USER_64": "",
"SOFOM_USER_65": "",
"SOFOM_USER_66": "",
"SOFOM_USER_67": "",
"SOFOM_USER_68": "",
"SOFOM_USER_69": "",
"SOFOM_USER_70": "",
"SOFOM_USER_71": "",
"SOFOM_USER_72": "",
"SOFOM_USER_73": "",
"SOFOM_USER_74": "",
"SOFOM_USER_75": "",
"SOFOM_USER_76": "",
"SOFOM_USER_77": "",
"SOFOM_USER_78": "",
"SOFOM_USER_79": "",
"SOFOM_USER_80": "",
"SOFOM_USER_81": "",
"SOFOM_USER_82": "",
"SOFOM_USER_83": "",
"SOFOM_USER_84": "",
"SOFOM_USER_85": "",
"SOFOM_USER_86": "",
"SOFOM_USER_87": "",
"SOFOM_USER_88": "",
"CC_SECURITY_ID": "",
"CCVERIFY_MMYY": "",
"CC_AUTH_AMT": "",
"SLX_CREATE_DATE": "",
"SLX_TRANS_DATE": "",
"DATE_LAST_EDI": "",
"E_MAIL": "",
"E_MAIL_DATE": "",
"CC_RTG_ID": "",
"COMPLETE_ONLY": "",
"MA_GEO": "",
"CHANGE_NO_EDI": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": "",
"LINES": {
"SO_LINE_NO": "",
"PART_ID": "",
"SO_DESC": "",
"SO_UM": "",
"DWG_REV": "",
"ECN": "",
"CUST_PART_ID": "",
"CONFIG_ID": "",
"STORES_CODE": "",
"COMPANY_ID": "",
"SALES_DEPT": "",
"SALES_ACCT": "",
"PRODUCT_LINE": "",
"SALESMAN_ID": "",
"SALES_REGION": "",
"SALES_COMM": "",
"COMMISSION_PCT": "",
"REQ_SHIP_DATE": "",
"PRIORITY_CODE": "",
"SCH_SHIP_DATE": "",
"REV_SHIP_DATE": "",
"ORDER_QTY": "",
"REV_ORDER_QTY": "",
"PRICE_CODE": "",
"SO_UNIT_COST": "",
"SO_UNIT_PRICE": "",
"ITEM_DISC_PCT": "",
"TAX_CODE": "",
"VAT_CODE": "",
"AMOUNT": "",
"LINE_TAX_AMT": "",
"LINE_TAX_2": "",
"LINE_TAX_3": "",
"LINE_TAX_4": "",
"LINE_TAX_5": "",
"LINE_TAX_6": "",
"LINE_TAX_7": "",
"LINE_TAX_8": "",
"LINE_TAX_9": "",
"LINE_TAX_10": "",
"LINE_VAT": "",
"LINE_ORDER_DISC": "",
"LINE_OTHER": "",
"PARTIAL_SHIP": "",
"SHIP_GROUP": "",
"SO_LINE_HOLD": "",
"SO_LINE_STATUS": "",
"SO_LINE_CAT": "",
"SHIP_TYPE": "",
"SHIP_TO_CUST": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"ATP_DATE": "",
"PICK_PRINT_DATE": "",
"PICK_DATE": "",
"DATE_LAST_ACT": "",
"LAST_SHIP_NO": "",
"SHIPPED_QTY": "",
"RETURNED_QTY": "",
"BALANCE_DUE": "",
"SN_REQD": "",
"SN_ENTERED": "",
"CHANGE_NO": "",
"CHANGE_DATE": "",
"CHANGE_CODE": "",
"EARLY_SHIP": "",
"LC_UNIT_PRICE": "",
"LC_AMOUNT": "",
"PART_UM": "",
"INV_ORDER_QTY": "",
"INV_REVISED_QTY": "",
"INV_SHIP_QTY": "",
"INV_RETN_QTY": "",
"INV_BAL_DUE": "",
"SALE_CONV": "",
"SALE_DEC": "",
"CATG_CODE": "",
"OPTION_TYPE": "",
"PICK_TYPE": "",
"RA_REASON": "",
"JOB_ID": "",
"EXPECTED_SN": "",
"XREF_SO_ID": "",
"XREF_SO_LINE": "",
"XREF_TYPE": "",
"BASE_PRICE": "",
"PRICE_CONV": "",
"PRICE_UM": "",
"PROD_DISC_CODE1": "",
"PROD_DISC_CODE2": "",
"PROD_DISC_CODE3": "",
"PROD_DISC_AMT1": "",
"PROD_DISC_AMT2": "",
"PROD_DISC_AMT3": "",
"CUST_PO_LINE": "",
"NEXT_PICK_QTY": "",
"SOFOD_USER_1": "",
"SOFOD_USER_2": "",
"SOFOD_USER_3": "",
"SOFOD_USER_4": "",
"SOFOD_USER_5": "",
"SOFOD_USER_6": "",
"SOFOD_USER_7": "",
"SOFOD_USER_8": "",
"SOFOD_USER_9": "",
"SOFOD_USER_10": "",
"SOFOD_USER_11": "",
"SOFOD_USER_12": "",
"SOFOD_USER_13": "",
"SOFOD_USER_14": "",
"SOFOD_USER_15": "",
"SOFOD_USER_16": "",
"SLX_TICKET_ID": "",
"CREATE_PO": "",
"PO_ID": "",
"LINE_NUMBER": "",
"TO_STORES": "",
"PICKED_QTY": "",
"PACK_SHIP_ID": "",
"BOXED_QTY": "",
"EXPECTED_LOT": "",
"TAX_CALC_REQD": "",
"KIT_ID": "",
"SKFKD_INFO_1": "",
"SKFKD_INFO_2": "",
"SKFKD_INFO_3": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": ""
},
"AUTH_TOKEN": ""
}QBE Notation
This query uses Expandable Query By Example (QBE) Notation. QBE Notation allows for conditional query criteria.
Not Equal To:
Greater Than:
Greater Than Or Equal To:
Less Than:
Less Than Or Equal To:
Between:
In:
Wildcard (any length):
Wildcard (single character):
Not Equal To:
"SO_STATUS": "<>X"Greater Than:
"ON_HAND_QTY": ">0"Greater Than Or Equal To:
"EFFECTIVE_DATE": ">=2016-01-01"Less Than:
"AMOUNT": "<100"Less Than Or Equal To:
"DATE_APPROVED": "<=2019-05-30"Between:
"ORDER_QTY": "BETWEEN 10 AND 100"In:
"LOT_STATUS": "IN A,C"Wildcard (any length):
"PART_ID": "MOTOR%"Wildcard (single character):
"SERIAL_NUMBER": "GC0000406_"Success Response
Returned HTTP status indicates success:
200/OK
Returned JSON contains the Sales Orders which were found by the query:
200/OK
Returned JSON contains the Sales Orders which were found by the query:
[
{
"SO_ID": "",
"SO_TYPE": "",
"CUSTOMER_ID": "",
"CUSTOMER_NAME": "",
"SHIP_TO_CUST": "",
"SHIP_NAME": "",
"ORDER_DATE": "",
"ORDER_CLASS": "",
"CHANGE_NO": "",
"CHANGE_DATE": "",
"CHANGE_CODE": "",
"BILL_TO_CUST": "",
"BILL_NAME": "",
"CUST_PO_ID": "",
"CONFIRMED_TO": "",
"REFERENCE": "",
"SALESMAN_ID": "",
"SALES_REGION": "",
"TERMS_CODE": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"TAX_CODE": "",
"ORDER_DISC_PCT": "",
"CURR_CODE": "",
"CURR_RATE": "",
"ORDER_TAKER": "",
"ATTENTION": "",
"SO_HOLD": "",
"SO_ORDER_CAT": "",
"SO_STATUS": "",
"PAYMENT_TYPE": "",
"BANK_CARD_GUID": "",
"CARD_TYPE": "",
"BANK_CARD_ID": "",
"EXPIRATION": "",
"TRANS_TYPE": "",
"AUTH_CODE": "",
"DATE_LAST_PRINT": "",
"DATE_APPROVED": "",
"DATE_LAST_SHIP": "",
"SHIP_NOTE_1": "",
"SHIP_NOTE_2": "",
"DELAY_INVOICE": "",
"DELAY_DAYS": "",
"SOFOM_USER_1": "",
"SOFOM_USER_2": "",
"SOFOM_USER_3": "",
"SOFOM_USER_4": "",
"SOFOM_USER_5": "",
"SOFOM_USER_6": "",
"SOFOM_USER_7": "",
"SOFOM_USER_8": "",
"SOFOM_USER_9": "",
"SOFOM_USER_10": "",
"SOFOM_USER_11": "",
"SOFOM_USER_12": "",
"SOFOM_USER_13": "",
"SOFOM_USER_14": "",
"SOFOM_USER_15": "",
"SOFOM_USER_16": "",
"SOFOM_USER_17": "",
"SOFOM_USER_18": "",
"SOFOM_USER_19": "",
"SOFOM_USER_20": "",
"SOFOM_USER_21": "",
"SOFOM_USER_22": "",
"SOFOM_USER_23": "",
"SOFOM_USER_24": "",
"SOFOM_USER_25": "",
"SOFOM_USER_26": "",
"SOFOM_USER_27": "",
"SOFOM_USER_28": "",
"SOFOM_USER_29": "",
"SOFOM_USER_30": "",
"SOFOM_USER_31": "",
"SOFOM_USER_32": "",
"SOFOM_USER_33": "",
"SOFOM_USER_34": "",
"SOFOM_USER_35": "",
"SOFOM_USER_36": "",
"SOFOM_USER_37": "",
"SOFOM_USER_38": "",
"SOFOM_USER_39": "",
"SOFOM_USER_40": "",
"SOFOM_USER_41": "",
"SOFOM_USER_42": "",
"SOFOM_USER_43": "",
"SOFOM_USER_44": "",
"SOFOM_USER_45": "",
"SOFOM_USER_46": "",
"SOFOM_USER_47": "",
"SOFOM_USER_48": "",
"SOFOM_USER_49": "",
"SOFOM_USER_50": "",
"SOFOM_USER_51": "",
"SOFOM_USER_52": "",
"SOFOM_USER_53": "",
"SOFOM_USER_54": "",
"SOFOM_USER_55": "",
"SOFOM_USER_56": "",
"SOFOM_USER_57": "",
"SOFOM_USER_58": "",
"SOFOM_USER_59": "",
"SOFOM_USER_60": "",
"SOFOM_USER_61": "",
"SOFOM_USER_62": "",
"SOFOM_USER_63": "",
"SOFOM_USER_64": "",
"SOFOM_USER_65": "",
"SOFOM_USER_66": "",
"SOFOM_USER_67": "",
"SOFOM_USER_68": "",
"SOFOM_USER_69": "",
"SOFOM_USER_70": "",
"SOFOM_USER_71": "",
"SOFOM_USER_72": "",
"SOFOM_USER_73": "",
"SOFOM_USER_74": "",
"SOFOM_USER_75": "",
"SOFOM_USER_76": "",
"SOFOM_USER_77": "",
"SOFOM_USER_78": "",
"SOFOM_USER_79": "",
"SOFOM_USER_80": "",
"SOFOM_USER_81": "",
"SOFOM_USER_82": "",
"SOFOM_USER_83": "",
"SOFOM_USER_84": "",
"SOFOM_USER_85": "",
"SOFOM_USER_86": "",
"SOFOM_USER_87": "",
"SOFOM_USER_88": "",
"CC_SECURITY_ID": "",
"CCVERIFY_MMYY": "",
"CC_AUTH_AMT": "",
"SLX_CREATE_DATE": "",
"SLX_TRANS_DATE": "",
"DATE_LAST_EDI": "",
"E_MAIL": "",
"E_MAIL_DATE": "",
"CC_RTG_ID": "",
"COMPLETE_ONLY": "",
"MA_GEO": "",
"CHANGE_NO_EDI": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": "",
"ORDER_SUBTOTAL": "",
"ORDER_DISC_AMT": "",
"ORDER_TAX_AMT": "",
"ORDER_TAX_2": "",
"ORDER_TAX_3": "",
"ORDER_TAX_4": "",
"ORDER_TAX_5": "",
"ORDER_TAX_6": "",
"ORDER_TAX_7": "",
"ORDER_TAX_8": "",
"ORDER_TAX_9": "",
"ORDER_TAX_10": "",
"ORDER_VAT": "",
"ORDER_TOTAL": "",
"NOTES": "",
"ATTACHMENTS": "",
"LINES": [
{
"SO_LINE_NO": "",
"PART_ID": "",
"SO_DESC": "",
"SO_UM": "",
"DWG_REV": "",
"ECN": "",
"CUST_PART_ID": "",
"CONFIG_ID": "",
"STORES_CODE": "",
"COMPANY_ID": "",
"SALES_DEPT": "",
"SALES_ACCT": "",
"PRODUCT_LINE": "",
"SALESMAN_ID": "",
"SALES_REGION": "",
"SALES_COMM": "",
"COMMISSION_PCT": "",
"REQ_SHIP_DATE": "",
"PRIORITY_CODE": "",
"SCH_SHIP_DATE": "",
"REV_SHIP_DATE": "",
"ORDER_QTY": "",
"REV_ORDER_QTY": "",
"PRICE_CODE": "",
"SO_UNIT_COST": "",
"SO_UNIT_PRICE": "",
"ITEM_DISC_PCT": "",
"TAX_CODE": "",
"VAT_CODE": "",
"AMOUNT": "",
"LINE_TAX_AMT": "",
"LINE_TAX_2": "",
"LINE_TAX_3": "",
"LINE_TAX_4": "",
"LINE_TAX_5": "",
"LINE_TAX_6": "",
"LINE_TAX_7": "",
"LINE_TAX_8": "",
"LINE_TAX_9": "",
"LINE_TAX_10": "",
"LINE_VAT": "",
"LINE_ORDER_DISC": "",
"LINE_OTHER": "",
"PARTIAL_SHIP": "",
"SHIP_GROUP": "",
"SO_LINE_HOLD": "",
"SO_LINE_STATUS": "",
"SO_LINE_CAT": "",
"SHIP_TYPE": "",
"SHIP_TO_CUST": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"ATP_DATE": "",
"PICK_PRINT_DATE": "",
"PICK_DATE": "",
"DATE_LAST_ACT": "",
"LAST_SHIP_NO": "",
"SHIPPED_QTY": "",
"RETURNED_QTY": "",
"BALANCE_DUE": "",
"SN_REQD": "",
"SN_ENTERED": "",
"CHANGE_NO": "",
"CHANGE_DATE": "",
"CHANGE_CODE": "",
"EARLY_SHIP": "",
"LC_UNIT_PRICE": "",
"LC_AMOUNT": "",
"PART_UM": "",
"INV_ORDER_QTY": "",
"INV_REVISED_QTY": "",
"INV_SHIP_QTY": "",
"INV_RETN_QTY": "",
"INV_BAL_DUE": "",
"SALE_CONV": "",
"SALE_DEC": "",
"CATG_CODE": "",
"OPTION_TYPE": "",
"PICK_TYPE": "",
"RA_REASON": "",
"JOB_ID": "",
"EXPECTED_SN": "",
"XREF_SO_ID": "",
"XREF_SO_LINE": "",
"XREF_TYPE": "",
"BASE_PRICE": "",
"PRICE_CONV": "",
"PRICE_UM": "",
"PROD_DISC_CODE1": "",
"PROD_DISC_CODE2": "",
"PROD_DISC_CODE3": "",
"PROD_DISC_AMT1": "",
"PROD_DISC_AMT2": "",
"PROD_DISC_AMT3": "",
"CUST_PO_LINE": "",
"NEXT_PICK_QTY": "",
"SOFOD_USER_1": "",
"SOFOD_USER_2": "",
"SOFOD_USER_3": "",
"SOFOD_USER_4": "",
"SOFOD_USER_5": "",
"SOFOD_USER_6": "",
"SOFOD_USER_7": "",
"SOFOD_USER_8": "",
"SOFOD_USER_9": "",
"SOFOD_USER_10": "",
"SOFOD_USER_11": "",
"SOFOD_USER_12": "",
"SOFOD_USER_13": "",
"SOFOD_USER_14": "",
"SOFOD_USER_15": "",
"SOFOD_USER_16": "",
"SLX_TICKET_ID": "",
"CREATE_PO": "",
"PO_ID": "",
"LINE_NUMBER": "",
"TO_STORES": "",
"PICKED_QTY": "",
"PACK_SHIP_ID": "",
"BOXED_QTY": "",
"EXPECTED_LOT": "",
"TAX_CALC_REQD": "",
"KIT_ID": "",
"SKFKD_INFO_1": "",
"SKFKD_INFO_2": "",
"SKFKD_INFO_3": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": ""
}
],
"COMMENTS": [
{
"SO_LINE_NO": "",
"PRINT_INVOICE": "",
"COMMENT_TEXT": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": ""
}
],
"EXTENDED_USER": [
{
"SO_LINE_NO": "",
"SOFDXU_USER_1": "",
"SOFDXU_USER_2": "",
"SOFDXU_USER_3": "",
"SOFDXU_USER_4": "",
"SOFDXU_USER_5": "",
"SOFDXU_USER_6": "",
"SOFDXU_USER_7": "",
"SOFDXU_USER_8": "",
"SOFDXU_USER_9": "",
"SOFDXU_USER_10": "",
"SOFDXU_USER_11": "",
"SOFDXU_USER_12": "",
"SOFDXU_USER_13": "",
"SOFDXU_USER_14": "",
"SOFDXU_USER_15": "",
"SOFDXU_USER_16": "",
"SOFDXU_USER_17": "",
"SOFDXU_USER_18": "",
"SOFDXU_USER_19": "",
"SOFDXU_USER_20": "",
"SOFDXU_USER_21": "",
"SOFDXU_USER_22": "",
"SOFDXU_USER_23": "",
"SOFDXU_USER_24": "",
"SOFDXU_USER_25": "",
"SOFDXU_USER_26": "",
"SOFDXU_USER_27": "",
"SOFDXU_USER_28": "",
"SOFDXU_USER_29": "",
"SOFDXU_USER_30": "",
"SOFDXU_USER_31": "",
"SOFDXU_USER_32": "",
"SOFDXU_USER_33": "",
"SOFDXU_USER_34": "",
"SOFDXU_USER_35": "",
"SOFDXU_USER_36": "",
"SOFDXU_USER_37": "",
"SOFDXU_USER_38": "",
"SOFDXU_USER_39": "",
"SOFDXU_USER_40": "",
"SOFDXU_USER_41": "",
"SOFDXU_USER_42": "",
"SOFDXU_USER_43": "",
"SOFDXU_USER_44": "",
"SOFDXU_USER_45": "",
"SOFDXU_USER_46": "",
"SOFDXU_USER_47": "",
"SOFDXU_USER_48": "",
"SOFDXU_USER_49": "",
"SOFDXU_USER_50": "",
"SOFDXU_USER_51": "",
"SOFDXU_USER_52": "",
"SOFDXU_USER_53": "",
"SOFDXU_USER_54": "",
"SOFDXU_USER_55": "",
"SOFDXU_USER_56": "",
"SOFDXU_USER_57": "",
"SOFDXU_USER_58": "",
"SOFDXU_USER_59": "",
"SOFDXU_USER_60": "",
"SOFDXU_USER_61": "",
"SOFDXU_USER_62": "",
"SOFDXU_USER_63": "",
"SOFDXU_USER_64": "",
"SOFDXU_USER_65": "",
"SOFDXU_USER_66": "",
"SOFDXU_USER_67": "",
"SOFDXU_USER_68": "",
"SOFDXU_USER_69": "",
"SOFDXU_USER_70": "",
"SOFDXU_USER_71": "",
"SOFDXU_USER_72": "",
"SOFDXU_USER_73": "",
"SOFDXU_USER_74": "",
"SOFDXU_USER_75": "",
"SOFDXU_USER_76": "",
"SOFDXU_USER_77": "",
"SOFDXU_USER_78": "",
"SOFDXU_USER_79": "",
"SOFDXU_USER_80": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": ""
}
]
}
]Failure Response
Returned HTTP status indicates failure:
400/Request JSON is invalid.
401/Auth Token was not provided.
401/Auth Token is malformed.
401/Auth Token login failure.
405/Request method must be POST.
500/(Error Message)
Returned JSON contains error information for the failed Sales Order query:
400/Request JSON is invalid.
401/Auth Token was not provided.
401/Auth Token is malformed.
401/Auth Token login failure.
405/Request method must be POST.
500/(Error Message)
Returned JSON contains error information for the failed Sales Order query:
{
"MESSAGE": "",
"MESSAGE_CODE": ""
}