Zoho Inventory: getRecords OR query
Has anyone discovered a way to perform a query to the Inventory getRecords api in Deluge that accepts multiple optional value for a field.
To put this in context:
We are attempting to get Inventory items by Category and are currently doing something like this:
We are attempting to get Inventory items by Category and are currently doing something like this:
- query = Map();
- category_id = thisapp.functionThatResolvesThisForUs();
- ...
- query.put("category_id", category_id);
- ...
- inventory_response = zoho.inventory.getRecords("Items",thisapp.getOrgId(),query,"zoho_inventory");
For singular categories, this functions as expected and we do not have a problem. Our problem occurs when we want to fetch all the items in multiple categories at once. We cannot use the following as any subsequent uses of query.put("category_id",some_id) overwrites the first key/value pair and we only end up searching for the last.
We also attempted to write a criteria field that looked like "query.put("criteria", "(category_id:equals:12345)or(category_id:equals:67890))" in the hope that it would be consumed like the criteria parameter on the Search Records API but this isn't filtering anything so our educated guess is that it doesn't match any accepted filter the query and is being ignored.
Anyone found a way around this or do we need to set up further api calls to handle each category individually and then merge the results, maybe?
We'll do that if necessarily but it would be shame as it may well add up to more api calls overall and us burning through allocation for the sake of no way to perform an OR query.
We'll do that if necessarily but it would be shame as it may well add up to more api calls overall and us burning through allocation for the sake of no way to perform an OR query.
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Daniel
Dharshan S
Sticky Posts
Zoho Finance Workshop 2023 is coming to the USA. Meet the experts, get exclusive training on Zoho Finance apps and more.
Hello all, We'd like to invite you to our biggest Zoho Finance workshop in the United States. After a brief break, we are excited to be back. This year, we're bringing together our customers and community members for two days of curated hands-on sessions,Celebrating our Zoho Community SuperBuds
The SuperBud program recognizes the efforts Zoho users put in to help the rest of the community thrive and grow in their individual Zoho journeys. Be it the ZUG meetups or these forums, several Zoho users including our MVPs andZUG leaders, have steppedAuthtoken Deprecation for Zoho Inventory APIs
UPDATE (7 July 2021): We've extended the deadline to 30 August 2021 for converting Authtokens to OAuth. Hello everyone, The usage of Authtokens to authenticate API calls is being deprecated on 30 August 2021 across Zoho's Finance suite of products,ZOHO Inventory - Early Access
https://twitter.com/zoho/status/646715717849493504
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー