api/VendorPart/Query (POST)
Queries existing Vendors Parts 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 Vendor Parts.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| RequestData | This is a JSON object containing Vendor Part query data.
Query Single Vendor Part Using Key Fields Example:
{
"PART_ID": "MOTOR003",
"VENDOR_ID": "XYZCORP",
"VENDOR_PART_ID": "MOTOR_240V"
}
Returns 1 Vendor Part if successful.
This is like 'Find' in Expandable.
Query Multiple Vendor Parts Using Other Fields Example:
{
"CONTRACT": "XYZCORP-001",
"BUY_STATUS": "A"
}
Returns 1 or more Vendor Parts if successful.
This is like 'QBE' in Expandable.
Query Multiple Vendor Parts Using QBE Conditional Notation Example:
{
"LAST_PO_PRICE": ">100",
"QC_FLAG": "IN 'I','Q'"
}
Returns 1 or more Vendor Parts if successful.
This is like 'QBE' in Expandable.
Accepted Vendor Part Fields:
APPR_MFG_LEVEL, APPR_VEND_LEVEL, BUY_CONV, BUY_DEC,
BUY_STATUS, BUY_UM, BUYER_ID, COMMENT_1,
COMMENT_2, COMMENT_3, COMMENT_4, COMMENT_ID,
CONTRACT, CREATED_BY, CURR_CODE, DATE_CREATED,
DATE_LAST_PO, DATE_LAST_QUOTE, DATE_LAST_UPDT, DATE_MODIFIED,
DEF_STORES_CODE, DEMAND_DAYS, DEMAND_PCT, DWG_REV,
EARLY_RECEIPT, ECN, ITEM_DISC_PCT, LAST_DISC_PCT,
LAST_PO_ID, LAST_PO_PRICE, LAST_PO_QTY, LAST_PO_UM,
LOT_SIZE, MFG_ID, MFG_NAME, MFG_VENDOR_ID,
MODIFIED_BY, OPERATOR_ID, PART_ID, PARTIAL_SHIP,
PO_DESC, POFVP_USER_1, POFVP_USER_2, POFVP_USER_3,
POFVP_USER_4, POFVP_USER_5, POFVP_USER_6, POFVP_USER_7,
POFVP_USER_8, POFVP_USER_9, POFVP_USER_10, POFVP_USER_11,
POFVP_USER_12, POFVP_USER_13, POFVP_USER_14, PRICE_CHG,
PRICE_CODE, QC_FLAG, QC_SAMPLE_CODE, QUOTE_QTY,
QUOTE_UNIT_PRIC, REFERENCE, ROHS_COMP_COMM, ROHS_COMP_DATE,
ROHS_COMP_ST, ROHS_DOC_COMM, ROHS_DOC_DATE, ROHS_DOC_ST,
ROHS_PROC_COMM, ROHS_PROC_DATE, ROHS_PROC_ST, TAX_CODE,
TIME_LAST_UPDT, VAT_CODE, VENDOR_ID, VENDOR_PART_ID,
VENDR_LEAD_TIME, WEEE_RECY_COMM, WEEE_RECY_DATE, WEEE_RECY_ST |
Define this parameter in the request body. |
Response Information
Success:200/OK
Body contains JSON array with found Vendor Parts.
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 Vendor Part Fields:
ATTACHMENTS, APPR_MFG_LEVEL, APPR_VEND_LEVEL, BUY_CONV, BUY_DEC, BUY_STATUS, BUY_UM, BUYER_ID, COMMENT_1, COMMENT_2, COMMENT_3, COMMENT_4, COMMENT_ID, CONTRACT, CREATED_BY, CURR_CODE, DATE_CREATED, DATE_LAST_PO, DATE_LAST_QUOTE, DATE_LAST_UPDT, DATE_MODIFIED, DEF_STORES_CODE, DEMAND_DAYS, DEMAND_PCT, DWG_REV, EARLY_RECEIPT, ECN, ITEM_DISC_PCT, LAST_DISC_PCT, LAST_PO_ID, LAST_PO_PRICE, LAST_PO_QTY, LAST_PO_UM, LOT_SIZE, MFG_ID, MFG_NAME, MFG_VENDOR_ID, MODIFIED_BY, NOTES, OPERATOR_ID, PART_ID, PARTIAL_SHIP, PO_DESC, POFVP_USER_1, POFVP_USER_2, POFVP_USER_3, POFVP_USER_4, POFVP_USER_5, POFVP_USER_6, POFVP_USER_7, POFVP_USER_8, POFVP_USER_9, POFVP_USER_10, POFVP_USER_11, POFVP_USER_12, POFVP_USER_13, POFVP_USER_14, PRICE_CHG, PRICE_CODE, QC_FLAG, QC_SAMPLE_CODE, QUOTE_QTY, QUOTE_UNIT_PRIC, REFERENCE, ROHS_COMP_COMM, ROHS_COMP_DATE, ROHS_COMP_ST, ROHS_DOC_COMM, ROHS_DOC_DATE, ROHS_DOC_ST, ROHS_PROC_COMM, ROHS_PROC_DATE, ROHS_PROC_ST, TAX_CODE, TIME_LAST_UPDT, VAT_CODE, VENDOR_ID, VENDOR_PART_ID, VENDR_LEAD_TIME, WEEE_RECY_COMM, WEEE_RECY_DATE, WEEE_RECY_ST