JSONata Tutorial

Lookup

Functions

← PreviousNext →

Lookup

Task

For each line item, create an object containing the product_id as well as a unit_type parameter. Map unit_of_measure of the input to the unit_type of the output like this:

  • 201 → EURO_PALLET
  • 202 → EURO_PALLET_HALF
  • 204 → EURO_PALLET_QUARTER
  • CT → CARTON
Your Expression
Your Result
No data
Input JSON
{
    line_items:[
      {
        product_id:1,
        unit_of_measure:"201",
        quantity:10
      },
      {
        product_id:2,
        unit_of_measure:"202",
        quantity:50
      },
      {
        product_id:3,
        unit_of_measure:"204",
        quantity:5
      },
      {
        product_id:4,
        unit_of_measure:"CT",
        quantity:200
      }
    ]
}
Expected Output
[
    {
      product_id:1,
      unit_type:"EURO_PALLET"
    },
    {
      product_id:2,
      unit_type:"EURO_PALLET_HALF"
    },
    {
      product_id:3,
      unit_type:"EURO_PALLET_QUARTER"
    },
    {
      product_id:4,
      unit_type:"CARTON"
    }
]