Restructure JSON in JavaScript?

Question

I recieve a JSON from the server like ExampleA but i need it to be like ExampleB,I tried a lot of things, like splice, push, spread operator but couldnt achieve my goal, it seems i'm overnesting the structure. ExampleA:

[
  {
    "year": 2017,
    "Setor": {
      "6": {
        "ID Sector": 7,
        "revenue": 5555555
      },
      "7": {
        "ID Sector": 10,
        "revenue": 5555555
      }
    }
  },
  {
    "year": 2018,
    "Setor": {
      "8": {
        "ID Sector": 7,
        "revenue": 7777777
      },
      "9": {
        "ID Sector": 10,
        "revenue": 7777777
      }
    }
  }
]

ExampleB:

 [
  {
    "7": 5555555,
    "year": 2017,
    "10": 5555555,
  },
  {
    "7": 7777777,
    "year": 2018,
    "10":7777777
  }
]

As you can see, i want a JSON where each array have a "year", and the id of Sector as a "index" and its value as its revenue.

Edit: sorry for not including my code, this is the last thing i tried:

        var Obj=[];
        this.data.items.forEach((value,index,array)=>{
            var data = value.data;
            var arraySectorsData =[];
            var actualYear = {year:data.year};
            for(var sector in data.Setor){
                var revenue = {[data.Setor[sector]['ID Sector']]:data.Setor[sector].revenue};
                arraySectorsData.splice(0, 0, revenue);
            }
            arraySectorsData.splice(0, 0, actualYear);
            Obj[index]=[...arraySetoresDados];
        });

And this is what i'm getting:

[
  [
    {
      "year": 2017
    },
    {
      "7": 5555555
    },
    {
      "10": 5555555
    }
  ],
  [
    {
      "year": 2018
    },
    {
      "7": 7777777
    },
    {
      "10": 7777777
    }
  ]
]

Your efforts so far ? ,I tried a lot of things, like splice, push, spread operator but couldnt achieve my goal, it seems i'm overnesting the structure post the code you have tried so far ? — Code Maniac
– Code Maniac, Commented Mar 1, 2019 at 17:39
what have you tried so far? what error messages have you received? there are many, many questions on Stack Overflow regarding manipulation of JSON - which ones have you investigated and why do they not solve your specific problem? if they do not apply, then please post your code here so we can better help you. — Dan O
– Dan O, Commented Mar 1, 2019 at 17:39
Remember that in S.O. you should show people that you have tried to solve the problem — rubentd
– rubentd, Commented Mar 1, 2019 at 17:40
Note that you don't have "a JSON". You have an array of objects. JSON is a string format. — Heretic Monkey
– Heretic Monkey, Commented Mar 1, 2019 at 17:40
Sorry for the inconvenience guys, I edited the post to include my code — Matheus Hatje
– Matheus Hatje, Commented Mar 1, 2019 at 18:00

Shidersz · Accepted Answer · 2019-03-01 18:12:27Z

2

One solution is to use Array.map() to map your elements to new objects. For create the new objects we use Object.assign(), Object.values() and Array.reduce():

const input = [
  {
    "year": 2017,
    "Setor": {
      "6": {"ID Sector": 7, "revenue": 5555555},
      "7": {"ID Sector": 10, "revenue": 5555555}
    }
  },
  {
    "year": 2018,
    "Setor": {
      "8": {"ID Sector": 7, "revenue": 7777777},
      "9": {"ID Sector": 10, "revenue": 7777777}
    }
  }
];

let res = input.map(
    ({year, Setor}) => Object.assign(
        {year},
        Object.values(Setor).reduce(
            (acc, o) => (acc[[o["ID Sector"]]] = o.revenue, acc),
            {}
        )
    )
);

console.log(res);

.as-console {background-color:black !important; color:lime;}
.as-console-wrapper {max-height:100% !important; top:0;}

edited Mar 1, 2019 at 18:12

answered Mar 1, 2019 at 18:07

Shidersz

17.2k2 gold badges28 silver badges52 bronze badges

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

Comments

adiga · Accepted Answer · 2019-03-03 08:07:12Z

1

You could use a nested map and reduce with Object.values() like this:

const input = [{"year":2017,"Setor":{"6":{"ID Sector":7,"revenue":5555555},"7":{"ID Sector":10,"revenue":5555555}}},{"year":2018,"Setor":{"8":{"ID Sector":7,"revenue":7777777},"9":{"ID Sector":10,"revenue":7777777}}}]

const output = input.map(({ year, Setor }) => {
  return Object.values(Setor).reduce((r, { ["ID Sector"]: sector, revenue }) => {
           r.year = year
           r[sector] = revenue;
           return r
        }, {});
}, {})

console.log(output)

edited Mar 3, 2019 at 8:07

answered Mar 1, 2019 at 17:50

adiga

35.4k9 gold badges65 silver badges88 bronze badges

Comments

trincot · Accepted Answer · 2019-03-01 18:58:13Z

1

Similar to Shidersz solution, but with spread syntax on a map()-result:

this.data = { items: [{"year": 2017,"Setor": {"6": {"ID Sector": 7,"revenue": 5555555},"7": {"ID Sector": 10,"revenue": 5555555}}},{"year": 2018,"Setor": {"8": {"ID Sector": 7,"revenue": 7777777},"9": {"ID Sector": 10,"revenue": 7777777}}}]};

const obj = this.data.items.map(({year, Setor}) => 
    Object.assign({year}, ...Object.values(Setor).map(sector => 
        ({ [sector["ID Sector"]]: sector.revenue })
    ))
);

console.log(obj);

answered Mar 1, 2019 at 18:58

trincot

357k38 gold badges282 silver badges338 bronze badges

Collectives™ on Stack Overflow

Restructure JSON in JavaScript?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related