Retrieve a specific row from JSON to create a new row

[tshoemaker]

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.

[jeff-allen]

Any chance they mentioned increasing the row limits in Collections on the roadmap you are referring to? They are great when the dataset is smaller.

[gwilkinson]

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