Integromat Question... Aggregate Multiple JSON Values Grouped By Location?

[Darren_Alderman]

Still trying to get comfortable in Integromat and struggle with what modules to use for this…

I have data that is basically this:

[
   {
       "location": "A",
       "hours": 4,
       "wages": 40
   },
   {
       "location": "A",
       "hours": 1,
       "wages": 10
   },
   {
       "location": "B",
       "hours": 2,
       "wages": 20
   },
   {
       "location": "B",
       "hours": 3,
       "wages": 30
   }
]

How can I get the sum of hours and the sum of wages grouped by location in integromat so that I can add a row for each location in a Google Sheet?

[Darren_Murphy]

I think what you probably want is an Iterator module after the Parse JSON module.

[DarrenHumphries]

Sorry for asking this if it’s an obvious answer but is there a reason you can’t do the sums in Glide or a formula in the target google sheet?

[Darren_Alderman]

Row count!

We don’t need to know the individual payments, just the sum. If we stored all the rows it could be 100s added every day. If we sum before writing to the sheet, it’s only 7 rows.

[DarrenHumphries]

Ah, gotcha.

[Darren_Alderman]

Finally got it! And I think I understand it