cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieve a specific row from JSON to create a new row

tshoemaker
Deputy Chef III
Deputy Chef III

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.

6 REPLIES 6

jeff-allen
Deputy Chef I
Deputy Chef I

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
Deputy Chef I
Deputy Chef I

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