JSONata Tutorial

Sums

Calculation & Aggregation

← PreviousNext →

Sums

Task

Calculate the total quantity of sub_line_items per main line_item.

Your Expression
Your Result
No data
Input JSON
{
    line_items:[
      {
        product_id:1,
        sub_line_items:[
          {
            product_id:3,
            quantity:5,
            unit_price:10
          }
        ]
      },
      {
        product_id:2,
        quantity:53,
        unit_price:10.876,
        sub_line_items:[
          {
            product_id:4,
            quantity:3,
            unit_price:10.99
          },
          {
            product_id:5,
            quantity:9,
            unit_price:44.77
          }
        ]
      }
    ]
}
Expected Output
[
    {
      product_id:1,
      sub_item_quantity:5
    },
    {
      product_id:2,
      sub_item_quantity:12
    }
]