jsonata merge array with aggreate

17 Views Asked by At

with this example https://try.jsonata.org/J_4M9J9JS

from this result { "123": [ { "Price": 34.45, "Qty": 2, "ProductID": 858383 }, { "Price": 34.45, "Qty": 2, "ProductID": 85838388888 } ], "Trilby hat": { "Price": 21.67, "Qty": 1, "ProductID": 858236 } } How can I group the "123". Sum the price, take the first ProductID

I expect this result

[ { "Price": 68.9, "Qty": 2, "ProductID": 858383 }, { "Price": 21.67, "Qty": 1, "ProductID": 858236 } ]

0

There are 0 best solutions below