Vendor, Query
Queries existing Vendors using the provided criteria and returns a list of found Vendors.
URL
/api/vendor-query
Request Method
POST
Expandable Program
Vendor Master Editor (POEVM)
Required Fields
(at least one field to be used as query criteria)
AUTH_TOKEN
AUTH_TOKEN
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
{
"COUNTRY": "US",
"STATE": "IN 'FL','GA'",
"AUTH_TOKEN": ""
}Full Request JSON
{
"VENDOR_ID": "",
"VENDOR_NAME": "",
"SEARCH_NAME": "",
"BUYER_ID": "",
"AL_VEND_NAME": "",
"ADDRESS_1": "",
"ADDRESS_2": "",
"ADDRESS_3": "",
"CITY": "",
"STATE": "",
"ZIP_CODE": "",
"COUNTRY": "",
"PAY_TO_VENDOR": "",
"PO_CONTACT": "",
"PO_PHONE_NO": "",
"FAX_NO": "",
"TAX_CODE": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"NAICS_CODE": "",
"SIC_CODE": "",
"BUSINESS_TYPE": "",
"ORDER_DISC_PCT": "",
"EARLY_RECEIPT": "",
"PARTIAL_SHIP": "",
"VENDOR_TYPE": "",
"AP_CONTACT": "",
"AP_PHONE_NO": "",
"COMPANY_ID": "",
"EXP_DEPT": "",
"EXP_ACCOUNT": "",
"TERMS_CODE": "",
"DAYS_LATE": "",
"VARIANCE_AMT": "",
"VARIANCE_PCT": "",
"TAX_1099_NO": "",
"TAX_1099_TYPE": "",
"BANK_CODE": "",
"LANGUAGE": "",
"CURR_CODE": "",
"AUTO_PO_HOLD": "",
"VENDOR_STATUS": "",
"DATE_LAST_PO": "",
"CURRENT_BALANCE": "",
"LC_CURRENT_BAL": "",
"DATE_LAST_CHECK": "",
"LAST_CHECK_AMT": "",
"NUMBER_PO_YTD": "",
"PURCHASES_YTD": "",
"PAYMENTS_YTD": "",
"DISCOUNTS_YTD": "",
"DISC_LOST_YTD": "",
"LAST_YR_PAID": "",
"LAST_YR_DISC": "",
"LAST_YR_LOST": "",
"POFVM_USER_1": "",
"POFVM_USER_2": "",
"POFVM_USER_3": "",
"POFVM_USER_4": "",
"POFVM_USER_5": "",
"POFVM_USER_6": "",
"POFVM_USER_7": "",
"POFVM_USER_8": "",
"POFVM_USER_9": "",
"POFVM_USER_10": "",
"POFVM_USER_11": "",
"POFVM_USER_12": "",
"POFVM_USER_13": "",
"POFVM_USER_14": "",
"POFVM_USER_15": "",
"POFVM_USER_16": "",
"POFVM_USER_17": "",
"POFVM_USER_18": "",
"POFVM_USER_19": "",
"POFVM_USER_20": "",
"POFVM_USER_21": "",
"POFVM_USER_22": "",
"POFVM_USER_23": "",
"POFVM_USER_24": "",
"POFVM_USER_25": "",
"POFVM_USER_26": "",
"POFVM_USER_27": "",
"POFVM_USER_28": "",
"POFVM_USER_29": "",
"POFVM_USER_30": "",
"POFVM_USER_31": "",
"POFVM_USER_32": "",
"COMMENT_ID": "",
"COMMENT_1": "",
"COMMENT_2": "",
"COMMENT_3": "",
"COMMENT_4": "",
"COMMENT_5": "",
"COMMENT_6": "",
"COMMENT_7": "",
"COMMENT_8": "",
"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 Vendors which were found by the query:
200/OK
Returned JSON contains the Vendors which were found by the query:
[
{
"VENDOR_ID": "",
"VENDOR_NAME": "",
"SEARCH_NAME": "",
"BUYER_ID": "",
"AL_VEND_NAME": "",
"ADDRESS_1": "",
"ADDRESS_2": "",
"ADDRESS_3": "",
"CITY": "",
"STATE": "",
"ZIP_CODE": "",
"COUNTRY": "",
"PAY_TO_VENDOR": "",
"PO_CONTACT": "",
"PO_PHONE_NO": "",
"FAX_NO": "",
"TAX_CODE": "",
"SHIP_METHOD": "",
"FOB": "",
"FREIGHT_CODE": "",
"NAICS_CODE": "",
"SIC_CODE": "",
"BUSINESS_TYPE": "",
"ORDER_DISC_PCT": "",
"EARLY_RECEIPT": "",
"PARTIAL_SHIP": "",
"VENDOR_TYPE": "",
"AP_CONTACT": "",
"AP_PHONE_NO": "",
"COMPANY_ID": "",
"EXP_DEPT": "",
"EXP_ACCOUNT": "",
"TERMS_CODE": "",
"DAYS_LATE": "",
"VARIANCE_AMT": "",
"VARIANCE_PCT": "",
"TAX_1099_NO": "",
"TAX_1099_TYPE": "",
"BANK_CODE": "",
"LANGUAGE": "",
"CURR_CODE": "",
"AUTO_PO_HOLD": "",
"VENDOR_STATUS": "",
"DATE_LAST_PO": "",
"CURRENT_BALANCE": "",
"LC_CURRENT_BAL": "",
"DATE_LAST_CHECK": "",
"LAST_CHECK_AMT": "",
"NUMBER_PO_YTD": "",
"PURCHASES_YTD": "",
"PAYMENTS_YTD": "",
"DISCOUNTS_YTD": "",
"DISC_LOST_YTD": "",
"LAST_YR_PAID": "",
"LAST_YR_DISC": "",
"LAST_YR_LOST": "",
"POFVM_USER_1": "",
"POFVM_USER_2": "",
"POFVM_USER_3": "",
"POFVM_USER_4": "",
"POFVM_USER_5": "",
"POFVM_USER_6": "",
"POFVM_USER_7": "",
"POFVM_USER_8": "",
"POFVM_USER_9": "",
"POFVM_USER_10": "",
"POFVM_USER_11": "",
"POFVM_USER_12": "",
"POFVM_USER_13": "",
"POFVM_USER_14": "",
"POFVM_USER_15": "",
"POFVM_USER_16": "",
"POFVM_USER_17": "",
"POFVM_USER_18": "",
"POFVM_USER_19": "",
"POFVM_USER_20": "",
"POFVM_USER_21": "",
"POFVM_USER_22": "",
"POFVM_USER_23": "",
"POFVM_USER_24": "",
"POFVM_USER_25": "",
"POFVM_USER_26": "",
"POFVM_USER_27": "",
"POFVM_USER_28": "",
"POFVM_USER_29": "",
"POFVM_USER_30": "",
"POFVM_USER_31": "",
"POFVM_USER_32": "",
"COMMENT_ID": "",
"COMMENT_1": "",
"COMMENT_2": "",
"COMMENT_3": "",
"COMMENT_4": "",
"COMMENT_5": "",
"COMMENT_6": "",
"COMMENT_7": "",
"COMMENT_8": "",
"CREATED_BY": "",
"DATE_CREATED": "",
"MODIFIED_BY": "",
"DATE_MODIFIED": "",
"OPERATOR_ID": "",
"DATE_LAST_UPDT": "",
"TIME_LAST_UPDT": "",
"NOTES": "",
"ATTACHMENTS": ""
}
]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 Vendor 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 Vendor query:
{
"MESSAGE": "",
"MESSAGE_CODE": ""
}