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 believe Workato is increasing the row limits in Collections as part of the persistence enhancement. If I am not mistaken, even the row limit for the current (non-persistent) Collections was increased. Perhaps someone from Workato Product can comment/clarify (@Deven Maru).