Convert Multiple JSON Bundles to a Single Bundle

[jefftala]

I have rows of data in Google Sheets that I want to convert into JSON. I have it working but it takes every row and makes it into a distinct objects (or “output bundle”). I want them all grouped into a single object called “deals” (“single bundle”).

What am I doing wrong? I’ve tried adding a second JSON aggregator but that made it worse (nothing outputted because of issues with the data structure I believe).

EDIT 24 Hours Later: I solved this, but I will leave this post up if anyone has the same problem in the future. This excellent video from minute 17 breaks it down: https://www.youtube.com/watch?v=PJZkq1qmLVM&t=625s

Essentially, I needed a different structure: Google Sheets (Get Ranged Values) → Arrary Aggregator → Create JSON and I was able to get all my rows into a single object.

[Shornalatha]

Hi @jefftala .

This is the data structure I used for this example:

And the result looks like this:

I’ve added a Parse JSON module to group it into a single object:

Hope this helps.