How to format json object by specific value in NODEjs

Question

I have a json object in NODE like this:

{
    "data": [
      {
        "groupname": "TestGroup001",
        "description": "Test Gruppe für xyz...",
        "mgID": 1,
        "uID": 1,
        "username": "Max M.",
        "email": "[email protected]"
      },
      {
        "groupname": "TestGroup001",
        "description": "Test Gruppe für xyz...",
        "mgID": 1,
        "uID": 98,
        "username": "Susanne S.",
        "email": "[email protected]"
      },
      {
        "groupname": "TestGroup002",
        "description": "Test Gruppe für abc...",
        "mgID": 22,
        "uID": 96,
        "username": "Moritz A.",
        "email": "[email protected]"
      },
      {
        "groupname": "TestGroup002",
        "description": "Test Gruppe für abc...",
        "mgID": 22,
        "uID": 95,
        "username": "Lennart H",
        "email": "[email protected]"
      }
    ]
  }

and i need it grouped by "groupname" or better by "mgID" like that..

{
    "data": [
      {
        "groupname": "TestGroup001",
        "description": "Test Gruppe für xyz...",
        "mgID": 1,
        "users": [
          {
            "uID": 1,
            "username": "Max M.",
            "email": "[email protected]"
          },
          {
            "uID": 98,
            "username": "Susanne S.",
            "email": "[email protected]"
          }
        ]
      },
      {
        "groupname": "TestGroup002",
        "description": "Test Gruppe für abc...",
        "mgID": 22,
        "users": [
          {
            "uID": 96,
            "username": "Moritz A.",
            "email": "[email protected]"
          },
          {
            "uID": 95,
            "username": "Lennart H",
            "email": "[email protected]"
          }
        ]
      }
    ]
  }

i tried it with object.map...without success also with object.entries...also without success

i dont need working code...just some keywords.

Does this answer your question? javascript | Object grouping — Konrad
– Konrad, Commented Apr 12, 2023 at 11:07
Is it a duplicate (subset) of this question: stackoverflow.com/questions/31558996/… — George 2.0 Hope
– George 2.0 Hope, Commented Apr 12, 2023 at 11:10

Konrad · Accepted Answer · 2023-04-12 11:17:47Z

A code like this will do that:

const result = {
  data: Object.values(
    input.data.reduce((groups, current) => {
      const { mgID, description, groupname, ...rest } = current;
      if (!(mgID in groups)) {
        groups[mgID] = {
          mgID,
          description,
          groupname,
          users: [],
        };
      }
      groups[mgID].users.push(rest);
      return groups;
    }, {})
  ),
};

const input = {
  data: [
    {
      groupname: "TestGroup001",
      description: "Test Gruppe für xyz...",
      mgID: 1,
      uID: 1,
      username: "Max M.",
      email: "[email protected]",
    },
    {
      groupname: "TestGroup001",
      description: "Test Gruppe für xyz...",
      mgID: 1,
      uID: 98,
      username: "Susanne S.",
      email: "[email protected]",
    },
    {
      groupname: "TestGroup002",
      description: "Test Gruppe für abc...",
      mgID: 22,
      uID: 96,
      username: "Moritz A.",
      email: "[email protected]",
    },
    {
      groupname: "TestGroup002",
      description: "Test Gruppe für abc...",
      mgID: 22,
      uID: 95,
      username: "Lennart H",
      email: "[email protected]",
    },
  ],
};

const result = {
  data: Object.values(
    input.data.reduce((groups, current) => {
      const { mgID, description, groupname, ...rest } = current;
      if (!(mgID in groups)) {
        groups[mgID] = {
          mgID,
          description,
          groupname,
          users: [],
        };
      }
      groups[mgID].users.push(rest);
      return groups;
    }, {})
  ),
};
console.log(result);

Collectives™ on Stack Overflow

How to format json object by specific value in NODEjs

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related