Convert a multidimensional array to JSON with node.js

Question

I'm getting a BIG multidimensional array after combining few simple arrays, now I need to convert it in a JSON string right before sending it to Mongodb. Here is the array structure:

[ '0',
  [ [ 'id', 1 ],
    [ 'country', 0 ],
    [ 'people', 3 ],
    [ 'name', 'WELLINGTON ALFRED' ],
    [ 'location', 'hill' ],
    [ 'filename', 243245.PDF]]]

What's the best practice to do it in Node.js? Thank's in advance!

@Explosion Pills I'm iterating the BIG array and sending each sub array to Mongodb, this is only a sub-array with '0' as index. — Cris69
– Cris69, Commented Nov 27, 2013 at 16:05

igor · Accepted Answer · 2013-11-27 16:38:23Z

2

you totally can use JSON.stringify

string_for_mongo = JSON.stringify(your_array)

but you also can use any of these drivers for mongodb

if you want to convert these arrays to object you can just use something like this

pairs = {}
for ( pair in your_array[1] ) { pairs[your_array[1][pair][0]] = your_array[1][pair][1] }
objekt = {}
objekt[your_array[0]] = pairs

I think there is no better solution than not to use such an arrays. Try to form data in objects from the beginning.

edited Nov 27, 2013 at 16:38

answered Nov 27, 2013 at 16:15

igor

2,9253 gold badges22 silver badges24 bronze badges

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

2 Comments

Cris69 Over a year ago

this is the result of

console.log(string_for_mongo); ["0",[["id",1],["country",0],["people",3],["name","WELLINGTON ALFRED"],["location","hill"],["filename","243245.PDF"]]]

Cris69 Over a year ago

...and yes this is a valid JSON for JSONLint (JSON validator).

Deepam Gupta · Accepted Answer · 2020-05-16 08:39:01Z

There is no built-in method for the same.

You can use the following function:

//array
var arr = [
    ["Status", "Name", "Marks", "Position"], 
    ["active", "Akash", 10.0, "Web Developer"],
    ["active", "Vikash", 10.0, "Front-end-dev"],
    ["deactive", "Manish", 10.0, "designer"],
    ["active", "Kapil", 10.0, "JavaScript developer"],
    ["active", "Manoj", 10.0, "Angular developer"],
];

//javascript create JSON object from two dimensional Array
function arrayToJSONObject (arr){
    //header
    var keys = arr[0];

    //vacate keys from main array
    var newArr = arr.slice(1, arr.length);

    var formatted = [],
    data = newArr,
    cols = keys,
    l = cols.length;
    for (var i=0; i<data.length; i++) {
            var d = data[i],
                    o = {};
            for (var j=0; j<l; j++)
                    o[cols[j]] = d[j];
            formatted.push(o);
    }
    return formatted;
}

Reference: Click Here

Note: This might not give the output required for the input given in the question. I've provided the type of input this will work in arr.

Collectives™ on Stack Overflow

Convert a multidimensional array to JSON with node.js

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related