JSON parse with jquery?

Question

I could use some help with the syntax when using jquery to parse this json data coming back from the server. I have tried several examples from stackoverflow and other sites and for some reason I keep getting undefined as the out put instead of the id numbers. Each one should be its own line.

{
  "ROWCOUNT":7,
  "COLUMNS":["ID"],
  "DATA":{"id":"211","212","213","221","222","223","232"]}
}

Okay I am using coldfusion to create the json using SerializeJSON(query,true) If I remove the true I get {"COLUMNS":["ID"],"DATA":[["211"],["212"],["213"],["221"],["222"],["223"],["231"]‌,["232"],["233"],["241"]]} I am currently using $.each(data, function(i,item) {output i} the i comes out now as 0 through 6 not the data. — dutchlab
– dutchlab, Commented Jan 12, 2012 at 18:46

leopic · Accepted Answer · 2012-01-12 18:34:28Z

4

If you pass your JSON through a validator such as JSONLint you'll see that the JSON is not correct, which can be the reason for the errror.

This is what JSONLint shows:

Parse error on line 8:
..."211",        "212",        "213",   
----------------------^
Expecting ':

Which is easy to spot when you add some whitespace:

{
    "ROWCOUNT": 7,
    "COLUMNS": [
        "ID"
    ],
    "DATA": {
        "id": "211",
        "212",
        "213",
        "221",
        "222",
        "223",
        "232"
    ]
}
}

answered Jan 12, 2012 at 18:34

leopic

3,0232 gold badges29 silver badges43 bronze badges

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

1 Comment

dutchlab Over a year ago

Okay I am using coldfusion to create the json using SerializeJSON(query,true) If I remove the true I get {"COLUMNS":["ID"],"DATA":[["211"],["212"],["213"],["221"],["222"],["223"],["231"],["232"],["233"],["241"]]}

BartekR · Accepted Answer · 2012-01-12 18:36:47Z

0

You have wrong syntax with square brackets:

  "DATA":{"id":"211","212","213","221","222","223","232"]}

should be:

  "DATA":{"id":["211","212","213","221","222","223","232"]}

answered Jan 12, 2012 at 18:36

BartekR

3,9973 gold badges27 silver badges33 bronze badges

Comments

Nathan Taylor · Accepted Answer · 2012-01-12 18:35:06Z

0

I don't know about what code you have so far used to to try to parse it, but I can tell you that the JSON code above is syntactically wrong. Use this instead:

{
  "ROWCOUNT":7,
  "COLUMNS":["ID"],
  "DATA":{"id":"211","212","213","221","222","223","232"}
}

You had an extra square brace.

answered Jan 12, 2012 at 18:35

Nathan Taylor

24.7k20 gold badges102 silver badges158 bronze badges

Comments

JaredPar · Accepted Answer · 2012-01-12 18:35:37Z

0

The problem appears to be that you are missing an open [ after the id declaration. It should look like the following

{"ROWCOUNT":7, "COLUMNS":["ID"], "DATA":{"id":["211","212","213","221","222","223","232"]}}

Example usage

var json = '{"ROWCOUNT":7, "COLUMNS":["ID"], "DATA":{"id":["211","212","213","221","222","223","232"]}}';
var obj = $.parseJSON(json);
console.log(obj);

answered Jan 12, 2012 at 18:35

JaredPar

759k151 gold badges1.3k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

JSON parse with jquery?

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related