Issue adding multiple "Create JSON" output under single array

Hi everyone, i just started recently and have doubts… I have a scenario that triggers whenever theres a new google sheet row
then i do the following

  1. lookup another sheet where id = id of new row (will return multiple results)
  2. for each result i create a JSON
  3. i want to join the JSONs together under 1 array so the final output looks like
[
{json1}, {json2}, {json3}...and so on
]

the third step is where im having an issue
under create json you can see that it expectedly outputs two differnet JSON strings as the google sheets lookup returned 2 rows


however in array aggregator it doesnt combine the two jsons into a single output. how do i fix this

Hello @Jack_C,

You can map the Google Sheet->Search Rows module in the field of the array aggregator in the source module.

Screenshot 2024-03-12 175650

2 Likes