Group by functionality in table

[ScottR]

@jordanp

2. create a 'Query JSON with SQL' resource to modify the result of the original JS query.

This would be the way to go....

Also, this post may put you in the right direction:

Access items in array with JSON SQL

I have a JSON response which includes an array within each object as per screenshot "totalSales": { "amount": 1564.51, "currencyCode": "GBP" } There are x amount of items in array. How do I sum all occurences of 'amount'? I can only seem to access each individually with this SQL query: select * from {{Amazon_SalesAPI_SALES.data.payload['0'].totalSales.amount}} I know I need to do select sum(*) from X but not sure what the correct structure is to access 'amount' within the totalSales arra…