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
- lookup another sheet where id = id of new row (will return multiple results)
- for each result i create a JSON
- 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