Page 1 of 1

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

PostPosted: Fri Jul 10, 2026 6:15 pm
by 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?

Re: How to fetch Multiple Inventory Items in a Single API ca  Topic is solved

PostPosted: Mon Jul 13, 2026 1:15 pm
by 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

Re: How to fetch Multiple Inventory Items in a Single API ca

PostPosted: Mon Jul 13, 2026 5:38 pm
by 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!

Re: How to fetch Multiple Inventory Items in a Single API ca

PostPosted: Mon Jul 13, 2026 6:11 pm
by Mike.Sheen
edithbeatrice wrote: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.