• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
New Topic
Discussions Recipe Building Tips & Tricks!
S

Saul Macht

started a topic 8 months ago

Lookup table - Retrieve entries matching any of specified values

Hi there, I have a lookup table containing user records info. I wish to retrieve entries from the lookup table by searching a column where user id is stored. 


I have a dynamic list of users, could be 1 or 10. I wish to retrieve entries that match based on id. Is there a way to make a single query on the lookup table to get all matching records, or do I have to loop through each item on my list of users to run a search for each item?


Thank you.

Amanda Wong

said 8 months ago

Hi Saul,


It is possible to use a single search action to query for matching lookup table entries based on an input containing an array of values.


Check out this recipe: https://www.workato.com/recipes/1159831-lookup-table-search-by-specifying-multiple-values-in-array#recipe

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato