Parse Text to JSON and slice the array

In here I only want to aggregate the first 9 bundle to the text.

I have defined the JSON structure (I think it’s correct)

but then not sure what should be the next step…

Hello @Keith_Cheung,

If you only want to aggregate the first 9 bundles of the #15 Iterator, then you might try using a filter.
Click the Wrench between Iterator and Google Sheets, then filter would be Bundle Order Position <= 9.

3 Likes

it doesn’t work with bundle order because each operation could return different number of bundles and setting the bundle order =< 9 only filter the bundle within the operation but not the total bundle across different operations.

What if you try setting “Maximum number of returned rows” in Google Sheets module to 9?

3 Likes



it’s a iterator of 3 different search term in the google sheet, and I need to control the total results which is less than 9…

@samliew has suggested to use Parse JSON and Slice but i’m not sure how to operate…


ah the increment function will do the magic. problem solved!

1 Like

Heya @Keith_Cheung :wave:

I just want to quickly step in to say awesome work figuring this one out with the guidance of @Donald_Mitchell :clap:

Also, thanks a lot for circling back to the community and letting us know that the increment function got this up and running for you. This is super valuable and can be incredibly helpful to many others who are looking for similar info in the future :pray:

1 Like