Transform json array of objects

Question

I have a json with "proceds" and "teams".

Id´like to transform it grouping it by team.

Next, I show a snippet what I want achieve.

How can I do it?

dados:{
proceds:[
 {id:'1', proc:'11', teams:[{team_id:1},{team_id:2}]},
 {id:'2', proc:'12', teams:[{team_id:1},{team_id:3}]},
 {id:'3', proc:'13', teams:[{team_id:2},{team_id:3}]},
]
}

I´d like to transform "dados" to:

dados:{
 teams:[
  {team_id:1, proceds:[{id:'1', proc:'11'},{id:'2', proc:'12'}],
  {team_id:2, proceds:[{id:'1', proc:'11'},{id:'3', proc:'13'}]
  {team_id:3, proceds:[{id:'2', proc:'12'},{id:'3', proc:'13'}]
 ]
}

Hassan Imam · Accepted Answer · 2020-07-10 17:49:21Z

2

You can create an object lookup for each team id and then generate the result using Object.entries and array#map.

const data = [ {id:'1', proc:'11', teams:[{team_id:1},{team_id:2}]}, {id:'2', proc:'12', teams:[{team_id:1},{team_id:3}]}, {id:'3', proc:'13', teams:[{team_id:2},{team_id:3}]}, ],
    result = Object.entries(data.reduce((r, o) => {
      o.teams.forEach(({ team_id }) => {
        r[team_id] = r[team_id] || [];
        r[team_id].push({ id: o.id, proc: o.proc });
      });
      return r;
    }, {})).map(([team_id, proceds]) => ({ team_id, proceds }));
console.log(result);

.as-console-wrapper{min-height:100% !important; top: 0; }

answered Jul 10, 2020 at 17:49

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

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

Comments

Arun Saini · Accepted Answer · 2020-07-10 18:27:04Z

1

You need to iterate each object to make groups.

let dados = {
proceds:[
 {id:'1', proc:'11', teams:[{team_id:1},{team_id:2}]},
 {id:'2', proc:'12', teams:[{team_id:1},{team_id:3}]},
 {id:'3', proc:'13', teams:[{team_id:2},{team_id:3}]},
]
};

const groupByTeams = [];
dados.proceds.forEach(item=> {
  let  {teams, ...teamItems} = item;
teams.forEach(team=>{
groupByTeams.find(x=>x.team_id==team.team_id)?groupByTeams.find(x=>x.team_id==team.team_id).proceds.push({...teamItems}):groupByTeams.push({...team, proceds: [{...teamItems}]});
});
});

console.log({dados:{teams:groupByTeams}});

edited Jul 10, 2020 at 18:27

answered Jul 10, 2020 at 18:18

Arun Saini

7,9641 gold badge24 silver badges26 bronze badges

Comments

Bruno Joaquim · Accepted Answer · 2020-07-10 18:35:13Z

1

You can combine reduce with Object.keys

const asObject = dados.proceds.reduce((acc, curr) => {
    curr.teams.forEach(t => acc[t.team_id] = [...(acc[t.team_id] || []), { id: curr.id, proc: curr.proc }])
    return acc
}, {})

const result = {
    teams: Object.keys(asObject).map(k => ({ team_id: k, proceds: asObject[k] }))
}

answered Jul 10, 2020 at 18:35

Bruno Joaquim

1,4731 gold badge16 silver badges15 bronze badges

Comments

Pavlos Karalis · Accepted Answer · 2020-07-11 08:21:24Z

1

const dados = {
    proceds:[
     {id:'1', proc:'11', teams:[{team_id:1},{team_id:2}]},
     {id:'2', proc:'12', teams:[{team_id:1},{team_id:3}]},
     {id:'3', proc:'13', teams:[{team_id:2},{team_id:3}]},
    ]
}

function transform(object) {
    object.teams = object.proceds.map((obj) => ({
        team_id: parseInt(obj.id),
        proceds: [
            ...obj.teams.map(team => ({
                id: team.team_id.toString(),
                proc: object.proceds.find(proc => proc.id == team.team_id).proc
            }))
        ]
    }))
    delete object.proceds;
    return object; 
}

console.log(transform(dados))

edited Jul 11, 2020 at 8:21

answered Jul 10, 2020 at 18:01

Pavlos Karalis

2,9761 gold badge9 silver badges15 bronze badges

Collectives™ on Stack Overflow

Transform json array of objects

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related