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
Send us a ticket, we will try our best to assist you with your problem
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?