Bulk Pricing Fetch via API

Prophet 21
1

I have been working with fetching pricing for a customer using the API endpoint “api/inventory/v2/parts/prices”. We have a request to fetch all of a list of item’s prices for a customer. This can been in the 100s of items. I know I can fetch multiple items in this endpoint, but have recently experienced timeout issues with requesting over 40 or 50. Does anyone know of a bulk request endpoint that has a better response rate? The source_location_id is the same for every item.

2

What about

POST {{Endpoint}}/api/ecommerce/

{
  "GetItemPrice": {
   "Request": {
    "StoreName": "same as company",
    "CustomerCode": 17345,
    "LocationID": "2215",
    "ShipToID": 17345,
    "ListOfItems": {
      "Item": [
       {
        "ItemID": "your_item",
        "Quantity": "1",
        "UnitName": "EA",
        "UnitSize": "1.0000"
       },
       {
        "ItemID": "your_next_item",
        "Quantity": "1",
        "UnitName": "EA",
        "UnitSize": "1.0000"
       },
       {
        "ItemID": "your_next_item2",
        "Quantity": "1",
        "UnitName": "EA",
        "UnitSize": "1.0000"
       },
       {
        "ItemID": "your_next_item3",
        "Quantity": "1",
        "UnitName": "EA",
        "UnitSize": "1.0000"
       },
       {
        "ItemID": "your_next_item4",
        "Quantity": "1",
        "UnitName": "EA",
        "UnitSize": "1.0000"
       }
      ]
    }
   }
  }
}
2 Likes
3

Thanks so much for your reply! I saw that endpoint, but the documentation site I see never showed me the body of that request, so your post helps a lot!

No matter what I try I am not getting anymore more than this as the reply response but again, the documentation site doesn’t give me much more on this response. I know it has somethign to do with my data, but when I pass same data to the other endpoint it comes back with pricing. Any continued help is appreciated!

<Reply>
</Reply>
<ReplyStatus>
   <Result>40</Result>
   <Message>Could not process request</Message>
   <DebugInfo></DebugInfo>
   <PerformanceLogInfo></PerformanceLogInfo>
</ReplyStatus>
4

Welp, forget what I said above. Kept playing with the values and variables and was able to figure it out.

Thanks @TFAjudson !