Convert multiple json object into array of object

Question

My data is currently stored in this format:

{
   "Site1":{
      "week":[
         {
            "access":1
         },
         {
            "access":8
         }
      ]
   },
   "Site2":{
      "week":[
         {
            "access":16
         }
      ]
   },
   "Site3":{
      "week":[
         {
            "access":2
         },
         {
            "access":6
         },
         {
            "access":2
         }
      ]
   }
}

And I need to convert it into this format:

[
   {
      "id":"Site1",
      "access":[1,8]
   },
   {
      "id":"Site2",
      "access":[16]
   },
   {
      "id":"Site3",
      "access":[2,6,2]
   }
]

As you can see, I also need to take the keys (site name) and make them the "id" values.

Any ideas on how I can do this in JavaScript (I'm using angular v9)? I'm not very good at restructuring that type of data.

Rajneesh · Accepted Answer · 2020-06-15 08:22:53Z

3

You can first take entries and then map it:

var data={ "Site1":{ "week":[ { "access":1 }, { "access":8 } ] }, "Site2":{ "week":[ { "access":16 } ] }, "Site3":{ "week":[ { "access":2 }, { "access":6 }, { "access":2 } ] }};

var result = Object.entries(data).map(([k,v])=>({id:k, access: v.week.map(p=>p.access)}));

console.log(result);

answered Jun 15, 2020 at 8:22

Rajneesh

5,3181 gold badge10 silver badges20 bronze badges

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

Comments

Nikita Madeev · Accepted Answer · 2020-06-15 07:37:43Z

2

const data = {
    Site1: {
        week: [
            {
                access: 1,
            },
            {
                access: 8,
            },
        ],
    },
    Site2: {
        week: [
            {
                access: 16,
            },
        ],
    },
    Site3: {
        week: [
            {
                access: 2,
            },
            {
                access: 6,
            },
            {
                access: 2,
            },
        ],
    },
};

const result = Object.keys(data).map(key => ({
    id: key,
    access: data[key].week.map(w => w.access),
}));

console.log(result);

answered Jun 15, 2020 at 7:37

Nikita Madeev

4,49012 silver badges23 bronze badges

1 Comment

mPissolato Over a year ago

I really appreciate your help thanks a lot! It worked for me

Piyush Jain · Accepted Answer · 2020-06-15 08:09:34Z

2

you can simply use this code for your desired result.

Object.keys(data).map(key => (
    {
        id: key,
        access: data[key].week.map(obj => obj.access),
    }
))

Let me know if you face any issue.

answered Jun 15, 2020 at 8:09

Piyush Jain

1,9863 gold badges22 silver badges40 bronze badges

Collectives™ on Stack Overflow

Convert multiple json object into array of object

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related