api/ProductPrice/Query (POST)

Queries existing Product Prices 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 Product Prices.

Request Information

Parameters

NameDescriptionAdditional information
RequestData 
This is a JSON object containing Product Price query data.

Query Single Product Price Using Key Fields Example:
{
  "PART_ID": "646-7202",
  "PRICE_CODE": "LP",
  "EFFECTIVE_DATE": "10/10/2014",
  "ORDER_QTY": "1000"
}
Returns 1 Product Price if successful.
This is like 'Find' in Expandable.

Query Multiple Product Prices Using Other Fields Example:
{
  "END_DATE": "12/31/2029",
  "SO_UNIT_PRICE": "10"
}
Returns 1 or more Product Prices if successful.
This is like 'QBE' in Expandable.

Query Multiple Product Prices Using QBE Conditional Notation Example:
{
  "END_DATE": "12/31/2029",
  "SO_UNIT_PRICE": "BETWEEN 10 AND 20"
}
Returns 1 or more Product Prices if successful.
This is like 'QBE' in Expandable.

Accepted Product Price Fields:
CREATED_BY, CURR_CODE, DATE_CREATED, DATE_MODIFIED, 
EFFECTIVE_DATE, END_DATE, ITEM_DISC_PCT, MODIFIED_BY, 
ORDER_QTY, PART_ID, PRICE_CHG, PRICE_CODE, 
SALES_COMM, SO_UNIT_PRICE

Define this parameter in the request body.

Response Information

Success:
200/OK
Body contains JSON array with found Product Prices.

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 Product Price Fields:
ATTACHMENTS, CREATED_BY, CURR_CODE, DATE_CREATED, DATE_MODIFIED, EFFECTIVE_DATE, END_DATE, ITEM_DISC_PCT, MODIFIED_BY, NOTES, ORDER_QTY, PART_ID, PRICE_CHG, PRICE_CODE, SALES_COMM, SO_UNIT_PRICE