getAllVendorProductPricing
Retrieve all vendor products pricing.
Query parameters
Retrieve active products (optional). Default to Y, if not provided.
Name of bid sheet to retrieve (optional) (case sensitive full name search).
Retrieve products under contract (Y/N) - optional.
Retrieve products relevant for this date (optional). API retrieves products with a beginDate less than or equal to the EffectiveDate and an endDate greater than the EffectiveDate. EffectiveDate is current date by default. Hint: If you want to see bids that end 'today', enter the date for the day before.
Name of market to retrieve (optional) (case sensitive full name search).
The number of minutes since a vendor product pricing or contract record was last updated. Use to set how far back to search.
Name of product to retrieve (optional) (case sensitive full name search).
Product number to retrieve. (case sensitive).
Retrieve products from secondary markets, if market param is provided. If market param is filled and secondaryMarket equals to "Y", API returns products not only from the market provided, but from secondary markets linked to the market, if there are any.
Fetch substitute products (optional).
Name of vendor to retrieve (optional) (case sensitive full name search).
Specify 'true' to output null data elements.
Headers
Secure token for API authentication.
Password for the Crunchtime Application User.
Crunchtime site identifier. (test or production)
User ID for the Crunchtime Application User.
Optional trace identifier for troubleshooting.
Response
Success
Example response
{
"vendorProductPricingRows": [
{
"beginDate": "11/10/2023",
"bidSheet": "QGF000",
"contractStatus": "Y",
"endDate": "11/10/2012",
"inventoryUnit": "12/12 OZ",
"lastChangeDate": "11/10/2020",
"market": "My Market",
"preferredUnit": "12/12 OZ",
"price": 100,
"productBrand": "Nestle",
"productName": "My Company",
"productNumber": "000222",
"secondaryMarket": "Y",
"secondaryVendorProducts": [
{
"beginDate": "11/10/2023",
"endDate": "11/10/2012",
"lastChangeDate": "11/10/2020",
"price": 100,
"primaryAltPrimary": "Y",
"productBrand": "Nestle",
"splitFlag": "N",
"vendorPackSize": "12/12 OZ",
"vendorProductName": "My Milk",
"vendorProductNumber": "p-0222",
"substitute": "Y",
"substituteNotApproved": "N",
"substituteRestricted": "Y",
"taxCode": "T08"
}
],
"splitFlag": "N",
"vendor": "My Vendor Company",
"vendorCode": "000222",
"vendorPackSize": "12/12 OZ",
"vendorProductNumber": "p-0222",
"contractLastChangeDate": "11/10/2020 09:23:35",
"taxCode": "T08",
"contractInfo": {
"referenceNumber": "AB123321",
"lineNumber": "12",
"expirationDate": "11/10/2020"
}
}
]
}