Copying JSON data in to array

Question

I want to get the data from a JSON file and copy the key and value pair to the array. For example:

jsondata = {
    'Name': {'text': {'name': 'John'}},
    'Age': {'number': {'age': '22'}}
}

in to

array=[["Name","text","name","John"]
       ["Age","number","age","22"]]

Is this possible?

Looking into the lodash package. I'm pretty sure there's a function for that — m_callens
– m_callens, Commented Jul 28, 2016 at 20:58

georg · Accepted Answer · 2016-07-28 21:30:49Z

2

In vanilla js it could be something like this:

data = {
    'Name': {'text': {'name': 'John'}},
    'Age': {'number': {'age': '22'}}
}

function linearize(obj) {
    if (typeof obj !== 'object')
        return [obj];
    var res = [];
    for (var key in obj) {
        for (var a of linearize(obj[key])) {
            res.push([key].concat(a))
        }
    }
    return res;
}

r = linearize(data)
console.log(r)

answered Jul 28, 2016 at 21:30

georg

216k57 gold badges324 silver badges401 bronze badges

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

3 Comments

Jason Sperske Over a year ago

This approach assume the nesting is always 2 steps deep, my code assume there is only ever one child per nested object, @javier's code assume you have access to .map and arrow functions, the moral of the story is lodash has probably solved this kind of problem already :)

georg Over a year ago

@JasonSperske: this approach assume the nesting is always 2 steps deep - why?

Jason Sperske Over a year ago

Totally missed the recursive call in your inner for-loop, my bad. Apparently we were both working on the same approach but yours is more flexible

Javier Conde · Accepted Answer · 2016-07-28 21:11:47Z

2

Without using external libraries, you can try:

function concatify (json) {
    return typeof json == "string" ? json : Object.keys(json).reduce((x,y) => x.concat(y).concat(concatify(json[y])), []);
}

Object.keys(jsondata).map(k => [k].concat(concatify(jsondata[k])));

or

Object.keys(json).map(k => [k].concat(JSON.stringify(json[k]).replace(/["\{\}]/g,'').split(':')))

edited Jul 28, 2016 at 21:11

answered Jul 28, 2016 at 21:00

Javier Conde

2,58322 silver badges27 bronze badges

Collectives™ on Stack Overflow

Copying JSON data in to array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related