Grouping array of objects by property value with JSONata

Question

I want to transform this array of objects:

{
  "Phone": [
    {
      "type": "home",
      "number": "0203 544 1234"
    },
    {
      "type": "office",
      "number": "01962 001234"
    },
    {
      "type": "office",
      "number": "01962 001235"
    },
    {
      "type": "mobile",
      "number": "077 7700 1234"
    }
  ]
}

into an array of objects, which groups phone numbers by type:

[
    {
        "type": "home",
        "numbers": ["0203 544 1234"]
    },
    {
        "type": "office",
        "numbers": ["01962 001234", "01962 001235"]
    },
    {
        "type": "mobile",
        "numbers": ["077 7700 1234"]
    }
]

with JSONata. Any hints?

I've tried this:

Phone{type: number}

But that leads to a different structure:

{
  "home": "0203 544 1234",
  "office": [
    "01962 001234",
    "01962 001235"
  ],
  "mobile": "077 7700 1234"
}

mralex · Accepted Answer · 2023-06-23 08:42:03Z

0

I think you're on the right track, and you just need to apply additional transformation at the end to transform the grouped object into an array:

{
  "Phone": Phone{
    type: number
  } ~> $each(function($value, $key) {{
    "type": $key,
    "number": $value
  }})
}

Check it out on the Stedi playground: https://stedi.link/JO7kBed

answered Jun 23, 2023 at 8:42

mralex

1,1201 gold badge7 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

erz Over a year ago

Thanks a lot! That's what I needed. JSONata is awesome but sometimes quite tricky. I changed it a little (stedi.link/pfE3x7D), so single numbers are also in arrays.

Collectives™ on Stack Overflow

Grouping array of objects by property value with JSONata

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related