Converting an array into JSON

Question

I need to bring in a csv doc and convert it to JSON, so far I have been able to convert it to an array and from the array I'm trying to build a JSON object.

Below is the JavaScript that builds the JSON, but its not in the structure I need, underneath is an example of the structure required.

var jsonObj = []; //declare object

for (var i=1;i<csvAsArray.length;i++) { 
  jsonObj.push({key: csvAsArray[i][0]}); //key

    for (var l=1;l<csvAsArray[0].length;l++) { 
      jsonObj.push({label: csvAsArray[0][l], values: csvAsArray[i][l]}); //label + value respectively
    }
}

Final output required:

{
  "key": "Sample 01",
  "values": [
    { 
      "label" : "Something" ,
      "value" : 1
    } , 
    { 
      "label" : "Something" ,
      "value" : 2
    }
  ]
},
{
  "key": "Sample 02",
  "values": [
    { 
      "label" : "Something" ,
      "value" : 5
    } , 
    { 
      "label" : "Something" ,
      "value" : 4
    }
  ]
}

So, your problem is to structure the data properly, not how to convert it to JSON? Please be clear about the issue. — Felix Kling
– Felix Kling, Commented Oct 9, 2013 at 3:56
Post an example of the CSV file from which you'd like to generate that output. Also I assume there's an outer [] missing in your output example, right? — Michael Geary
– Michael Geary, Commented Oct 9, 2013 at 4:13

iJade · Accepted Answer · 2013-10-09 04:05:59Z

5

Simply use JSON.stringify() to convert your array to json string

var jsonString = JSON.stringify(yourArray);

answered Oct 9, 2013 at 4:05

iJade

23.9k58 gold badges163 silver badges251 bronze badges

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

Comments

Wing Lian · Accepted Answer · 2013-10-09 04:05:23Z

3

You need to declare the values and push that onto a tmp variable before pushing that index onto the final/main object

var tmp_values, jsonObj = []; //declare object

for (var i=1;i<csvAsArray.length;i++) {
    var tmp_values = [];
    for (var l=1;l<csvAsArray[0].length;l++) { 
        tmp_values.push({label: csvAsArray[0][l], value: csvAsArray[i][l]}); //label + value respectively
    }
    jsonObj.push({key: csvAsArray[i][0], values: tmp_values}); //key
}

answered Oct 9, 2013 at 4:05

Wing Lian

2,41818 silver badges14 bronze badges

Comments

Vidya · Accepted Answer · 2013-10-09 03:53:22Z

0

This script is a common way to convert an array to JSON in JavaScript.

answered Oct 9, 2013 at 3:53

Vidya

30.4k7 gold badges48 silver badges73 bronze badges

Comments

Marty · Accepted Answer · 2013-10-09 04:15:29Z

0

I'm not a fan of answers like this, but this service in my opinion is good enough to warrant it. It can convert between various data formats including CSV, JSON, XML, HTML table, etc. It even offers variations in output structure for some of the formats.

http://shancarter.github.io/mr-data-converter/

answered Oct 9, 2013 at 4:15

Marty

39.5k19 gold badges97 silver badges164 bronze badges

Comments

Behnam · Accepted Answer · 2014-07-21 09:41:52Z

0

use this code and very simple develop for more two array

function getJSON(arrayID,arrayText) {    
    var JSON = "[";
    //should arrayID length equal arrayText lenght and both against null
    if (arrayID != null && arrayText != null && arrayID.length == arrayText.length) {
        for (var i = 0; i < arrayID.length; i++) {
            JSON += "{";
            JSON += "text:'" + arrayText[i] + "',";
            JSON += "id:'" + arrayID[i] + "'";
            JSON += "},";
        }
    }
    JSON += "]"
    JSON = Function("return " + JSON + " ;");
    return JSON();
}

and 3 array

function getJSON(arrayID, arrayText, arrayNumber) {
    var JSON = "[";  
    if (arrayID != null && arrayText != null && arrayNumber!=null && Math.min(arrayNumber.length,arrayID.length)==arrayText.length) {
        for (var i = 0; i < arrayID.length; i++) {
            JSON += "{";
            JSON += "text:'" + arrayText[i] + "',";
            JSON += "id:'" + arrayID[i] + "',";
            JSON += "number:'" + arrayNumber[i] + "'";
            JSON += "},";
        }
    }
    JSON += "]"
    JSON = Function("return " + JSON + " ;");
    return JSON();
}

answered Jul 21, 2014 at 9:41

Behnam

6,5191 gold badge44 silver badges37 bronze badges

3 Comments

moonwave99 Over a year ago

Never use your own serialization functions, please use JSON.stringify().

Behnam Over a year ago

just JSON.stringify()? no other solution

moonwave99 Over a year ago

About serialization, no. About restructuring your data you have to write your own logic of course ^^

Collectives™ on Stack Overflow

Converting an array into JSON

5 Answers 5

Comments

Comments

Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related