โ01-26-2022 05:45 PM
I did a search of a database that returns about 10 rows of data into JSON... It seems that the only way that I can now search inside that dataset is to do a loop and an IF inside that loop to find the record I want.
What I WANT to do is to select one of the rows (create a new json with one row?) so that I can use the datapills in following steps.
โ01-26-2022 05:54 PM
It sound like you may want to look at the .WHERE and .PLUCK options available in formulas. This can be used to select specific rows from a list.
โ01-26-2022 06:53 PM
Thank you Jeff Allen. This really helped. I was able to use the .where.pluck to grab the item I wanted and set a variable.
โ01-27-2022 12:21 AM
another option might be to look at collections. Collections act like in memory DB's where you can perform set operations and most normal sql operations
โ01-27-2022 12:45 PM
I love Collections and the capabilities it affords. I'm very much looking forward to the persistence mechanism that is an enhancement on the Workato roadmap, which will allow Collections to persist and be available across recipes/Jobs and not just within a single Job.