JSONata Tutorial

Array Filtering

Array Mapping

← PreviousNext →

Array Filtering

Task

Write a JSONata expression that pulls out the item_description_7008 field for all objects where description_format_code_7077 = 'A'.

Your Expression
Your Result
No data
Input JSON
{
    item_description_IMD_list:[
      {
        description_format_code_7077:"A",
        item_characteristic_C272:{},
        item_description_C273:{
          item_description_code_7009:"CU",
          item_description_7008:"Relevant Description"
        }
      },
      {
        description_format_code_7077:"B",
        item_characteristic_C272:{},
        item_description_C273:{
          item_description_code_7009:"CU",
          item_description_7008:"Irrelevant description"
        }
      }
    ]
}
Expected Output
{
    item_description:"Relevant Description"
}