Converting an array of object - JSON

Question

I have an array on objects like this,

[
  {
    "link": "link1",
    "model": "model1",
    "role": "role1",
    "access": "true"
  },
  {
    "link": "link1",
    "model": "model1",
    "role": "role2",
    "access": "true"
  },
  {
    "link": "link1",
    "model": "model1",
    "role": "role3",
    "access": "true"
  },
  {
    "link": "link1",
    "model": "model1",
    "role": "role4",
    "access": "true"
  },
  {
    "link": "link1",
    "model": "model2",
    "role": "role1",
    "access": "false"
  },
  {
    "link": "link1",
    "model": "model2",
    "role": "role2",
    "access": "false"
  },
  {
    "link": "link1",
    "model": "model2",
    "role": "role3",
    "access": "false"
  },
  {
    "link": "link1",
    "model": "model2",
    "role": "role4",
    "access": "false"
  },
  {
    "link": "link2",
    "model": "model1",
    "role": "role1",
    "access": "false"
  },
  {
    "link": "link2",
    "model": "model1",
    "role": "role2",
    "access": "true"
  },
  {
    "link": "link2",
    "model": "model1",
    "role": "role3",
    "access": "false"
  },
  {
    "link": "link2",
    "model": "model1",
    "role": "role4",
    "access": "true"
  },
  {
    "link": "link2",
    "model": "model2",
    "role": "role1",
    "access": "false"
  },
  {
    "link": "link2",
    "model": "model2",
    "role": "role2",
    "access": "true"
  },
  {
    "link": "link2",
    "model": "model2",
    "role": "role3",
    "access": "false"
  },
  {
    "link": "link2",
    "model": "model2",
    "role": "role4",
    "access": "true"
  }
]

With respect to this question, the input was a CSV sample with very less number of rows. In real I have a large CSV file and I found a way to import it and convert to JSON using d3.js, but the problem is I'm unable to convert it to the desired format. I tried using the data.forEach and the output was really weird and I couldn't understand why I get model2 alone in both the links.

Code:

d3.csv('data.csv', function(data) {

            var newData = {};

            data.forEach(function(e, i) {
                newData[e.link] = {};
                newData[e.link][e.model] = {};
            })

            d3.select('main').append('pre')
                .text(JSON.stringify(newData, null, '  '));
        });

Output:

{
  "link1": {
    "model2": {}
  },
  "link2": {
    "model2": {}
  }
}

Desired Output:

"link1": {
    "model1": {
        "role1": true,
        "role2": true,
        "role3": true,
        "role4": true,
    },
    "model2": {
        "role1": false,
        "role2": false,
        "role3": false,
        "role4": false,
    }
},
"link2": {
    "model1": {
        "role1": false,
        "role2": true,
        "role3": false,
        "role4": true,
    },
    "model2": {
        "role1": false,
        "role2": true,
        "role3": false,
        "role4": true,
    }
}

Any help will be much appreciated. Thanks in advance.

This is the question, I wanted to convert the JSON in the top, like the one in the bottom. — Unknown User
– Unknown User, Commented Sep 21, 2017 at 4:40
Always this will have 4 roles? role1, role2, role3, role4 ? or is that dynamic? — Vineesh
– Vineesh, Commented Sep 21, 2017 at 4:47
No, it is not same always. Some will have 2 and some with 3 and 4 — Unknown User
– Unknown User, Commented Sep 21, 2017 at 4:53

A. Iglesias · Accepted Answer · 2017-09-21 05:43:16Z

1

In your forEach, you're not assigning the role and access pair on each iteration, and you're always emptying each section.

Change your forEach with this...

data.forEach(function(e, i) {

    // Check if this "link" already exists exists, if not, create it.
    if (!newData[e.link])
        newData[e.link] = {};

    // Check if this "model" already exists inside of this "link", if not, create it.
    if (!newData[e.link][e.model])
        newData[e.link][e.model] = {};

    newData[e.link][e.model][e.role] = e.access;
});

I hope it helps

edited Sep 21, 2017 at 5:43

answered Sep 21, 2017 at 5:27

A. Iglesias

2,6752 gold badges12 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Converting an array of object - JSON

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