How do I merge objects within array in JMESPath?

Question

How can I merge objects within array?

{
  "input": [
    {
      "company_name": "Test",
      "property_space": 151821
    },
    {
      "company_name": "Test",
      "property_space": 145236
    }
  ]
}

I want to get an output like this

{
  "output": [
    {
      "company_name": "Test",
      "property_space": 297057
    }               
  ]
}

I fear your example is over simplified. Are your expecting to have a `group by` like in SQL? — β.εηοιτ.βε, Jul 20 '22 at 20:52
Or are you going to have only one company in your input and just what to sum the `property_space`? — β.εηοιτ.βε, Jul 20 '22 at 20:54

score 0 · Answer 1 · answered Jul 20 '22 at 21:14

Mind that there is no proper grouping capacity build in JMESPath at the moment, although there is a proposition to offer one in a fork of the official repository. ^reference

But, if what you want to achieve is just to sum the property_space properties, then a way to do it would be:

{  
  "output": [
    {
      company_name: input[0].company_name, 
      property_space: sum(input[].property_space)
    }
  ]
}

Which, on your example JSON would indeed give you the expected

{
  "output": [
    {
      "company_name": "Test",
      "property_space": 297057
    }
  ]
}

How do I merge objects within array in JMESPath?

1 Answers1