How to fetch Multiple Inventory Items in a Single API call?

[edithbeatrice]

I'm integrating with the Jiwa Financial API and noticed there is an endpoint for retrieving a single inventory item.

Is there an API endpoint or query parameter that allows retrieving multiple inventory items in a single request? For example, if I need inventory items with codes `A`, `B`, and `C`, can I request them together instead of making three separate API calls?

If this isn't currently supported, what is the recommended or most efficient approach for retrieving multiple inventory items?

[Scott.Pearce]

There is an AutoQuery route you can use:

http://localhost/Queries/IN_Main

Then you can use AutoQuery functionality to limit the results thus:

http://localhost/Queries/IN_Main?PartNoIn=8100044,8100052

To go further, you can also choose which columns are returned:

http://localhost/Queries/IN_Main?PartNoIn=8100044,8100052&Fields=InventoryID,PartNo,Description

[edithbeatrice]

Hi Pierre,

Thank you for your response. I tried it, and it worked perfectly.

I have another question. Currently, I'm updating inventory items individually. Is there a way to update multiple selected inventory items in a single API request?

I need to update both standard inventory fields and their custom fields for multiple items. Is there a bulk update endpoint or a recommended approach for doing this efficiently?

Thanks in advance!

[Mike.Sheen]

Is there a way to update multiple selected inventory items in a single API request?

I need to update both standard inventory fields and their custom fields for multiple items. Is there a bulk update endpoint or a recommended approach for doing this efficiently?

Short answer is no.

How many items are you needing to update? a few hundred inventory patch requests with only the fields you need to update won't take very long and shouldn't cause any issues.

Longer answer is you can create a custom service method to accept a custom payload which is essentially an array of inventory item patch requests, and that custom service method can then invoke the inventory patch method internally and return a response which is an array of inventory part no's and the response status and message of each.

only a couple of hours of effort to make a plugin to add that custom service method - if you're interested in getting us to do it, create a ticket on our helpdesk to get that process started.