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.
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.