JSON.parse result to proper array of objects

Question

after my JSON.parse I have this data

 data = [
  {
      "serviceType": "service1",
      "method": "close",
      "quantity": 56
  },
  {
      "serviceType": "service1",
      "method": "divert",
      "quantity": 175
  },
  {
      "serviceType": "service1",
      "method": "reverted",
      "quantity": 80
  },
  {
      "serviceType": "service2",
      "method": "close",
      "quantity": 15
  },
  {
      "serviceType": "service2",
      "method": "divert",
      "quantity": 149
  },
  {
      "serviceType": "service2",
      "method": "reverted",
      "quantity": 149
  },
  {
      "serviceType": "service3",
      "method": "close",
      "quantity": 87
  },....
  }
]

And I need it to be like data.json from this d3 example where categorie is my serviceType, being it the first property of every object (1 object per serviceType) and then the second property of every object should be an array of objects with the method and quantity.

I've been using forEach for every object in data and I'm pushing the first of every serviceType OK (without the 2nd property). The problem is I don't know how to update the object values (second property) inside the right object (according to the current serviceType).

finalArray = [];
data.forEach(function (d, index) {
    var serviceType = d.serviceType;    
    const found = finalArray.some( el => el.serviceType === serviceType);
    if (!found) {
        var obj = createObj(d); //function returning an obj with the desired structure
        finalArray.push(obj);                
    }...
});

This is an example of how the conversion should end up being.

[
    {
        "serviceType": "service1", 
        "values": [
            {
                "quantity": 0, 
                "method": "close"
            }, 
            {
                "quantity": 4, 
                "method": "divert"
            }, 
            {
                "quantity": 12, 
                "method": "reverted"
            }, 
            {
                "quantity": 0, 
                "method": "checked"
            }
        ]
    }, 
    {
        "serviceType": "service2", 
        "values": [
            {
                "quantity": 1, 
                "method": "close"
            }, 
            {
                "quantity": 21, 
                "method": "divert"
            }, 
            {
                "quantity": 13, 
                "method": "reverted"
            },  
            {
                "quantity": 6, 
                "method": "checked"
            }
        ]
    }, ...

do you have an example of the wanted result?

Nina Scholz
– Nina Scholz

2019-10-22 17:41:40 +00:00
Commented Oct 22, 2019 at 17:41 — Nina Scholz
– Nina Scholz, Commented Oct 22, 2019 at 17:41
@NinaScholz I edited the question, thank you.

Daniel Sh.
– Daniel Sh.

2019-10-22 17:47:14 +00:00
Commented Oct 22, 2019 at 17:47 — Daniel Sh.
– Daniel Sh., Commented Oct 22, 2019 at 17:47

Nina Scholz · Accepted Answer · 2019-10-22 17:46:50Z

1

You could take aMap and group same serviceType. Later build an a array with categorie and values properties.

var data = [{ serviceType: "service1", method: "close", quantity: 56 }, { serviceType: "service1", method: "divert", quantity: 175 }, { serviceType: "service1", method: "reverted", quantity: 80 }, { serviceType: "service2", method: "close", quantity: 15 }, { serviceType: "service2", method: "divert", quantity: 149 }, { serviceType: "service2", method: "reverted", quantity: 149 }, { serviceType: "service3", method: "close", quantity: 87 }],
    result = Array.from(
        data.reduce((m, { serviceType, ...o }) => m.set(serviceType, [...(m.get(serviceType) ||  []), o]), new Map),
        ([categorie, values]) => ({ categorie, values })
    );

console.log(result);

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

answered Oct 22, 2019 at 17:46

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

1 Comment

Daniel Sh. Over a year ago

Neat, I'll dig into this to proper understand it, I'm not well versed in Map. Thank you a lot.

Nenad Vracar · Accepted Answer · 2019-10-22 17:47:50Z

You can get one object with grouped services using reduce method and then get array of values from that object.

const data = [{"serviceType":"service1","method":"close","quantity":56},{"serviceType":"service1","method":"divert","quantity":175},{"serviceType":"service1","method":"reverted","quantity":80},{"serviceType":"service2","method":"close","quantity":15},{"serviceType":"service2","method":"divert","quantity":149},{"serviceType":"service2","method":"reverted","quantity":149},{"serviceType":"service3","method":"close","quantity":87}]

const object = data.reduce((r, {serviceType: s, ...rest}) => {
  if(!r[s]) r[s] = {categorie:s, values: [rest]};
  else r[s].values.push(rest);
  return r;
}, {});

const result = Object.values(object);
console.log(result);

Andre Nuechter · Accepted Answer · 2019-10-22 17:58:26Z

0

Try this:

const result = [...new Set(data.map(e => e.serviceType))].map(serviceType => {
  const re = { serviceType };
  re.values = data
    .filter(e => e.serviceType === serviceType)
    .map(v => ({ method: v.method, quantity: v.quantity }));
  return re;
});

First I get all the serviceTypes (the part using ...new Set()), then I create an object for each thereof consisting of the serviceType-name and the values, which I get by filtering out unrelated objects and dropping the serviceType-property of the related ones.

edited Oct 22, 2019 at 17:58

answered Oct 22, 2019 at 17:52

Andre Nuechter

2,26314 silver badges20 bronze badges

Comments

Abhishek Shastri · Accepted Answer · 2019-10-22 18:00:53Z

0

data.reduce((acc, value) => {
    var {serviceType, method, quantity} = value;
    var foundExisting = acc.find(v => v.serviceType == serviceType);

    if(foundExisting){
        foundExisting.values.push({method, quantity})
    } else {
        acc.push({serviceType, values: [{method, quantity}]})
    }

    return acc;
}, [])

answered Oct 22, 2019 at 18:00

Abhishek Shastri

5873 silver badges7 bronze badges

Collectives™ on Stack Overflow

JSON.parse result to proper array of objects

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related