How can I loop over this JSON result with jQuery?

Question

I'm trying to loop over the following JSON, but I can't figured out how to map the loop to the correct data item.

Alerting data[0].ID etc... keeps returning undefined, for example:

{
    "COLUMNS":
        ["ID","NAME","USECOUNT","EXCERPT"],
    "DATA":
        [
            [1443,"foo",20,null],
            [810,"bar",10,null],
            [690,"foobar",10,null]
        ]
}

karim79 · Accepted Answer · 2011-08-06 00:27:44Z

1

var obj = {
    "COLUMNS":
        ["ID","NAME","USECOUNT","EXCERPT"],
    "DATA":
        [
            [1443,"foo",20,null],
            [810,"bar",10,null],
            [690,"foobar",10,null]
        ]
}; 

// assuming you are interested only in the first elements of each DATA array
$.each(obj.DATA, function(i, val) {
    alert(val[0]); 
});

http://jsfiddle.net/AbVme/

answered Aug 6, 2011 at 0:27

karim79

343k67 gold badges420 silver badges409 bronze badges

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

2 Comments

Mohamad Over a year ago

That's done it. Thank you. Will accept as soon as it lets me.

Mohamad Over a year ago

Interesting. I'm running this in an ajax function, but it's craping out. Your JS Fiddle works. I'm using your code: [ajax snip] 'success': function(obj) { //your loop goes here }); it gives me an Uncaught TypeError: Cannot read propertly 'length' of undefined -- it's not reading the data structs...

genesis · Accepted Answer · 2011-08-06 00:22:35Z

1

jsonObject.data[0][0];

there is no ID

answered Aug 6, 2011 at 0:22

genesis

51.1k20 gold badges99 silver badges127 bronze badges

Comments

Mike Richards · Accepted Answer · 2011-08-06 00:28:01Z

1

The COLUMNS parameter and the DATA parameter are disjointed, they are two separate parameters.

If you want to do what you're talking about, you would need some way of determining which index "ID" resides at within the columns array.

var idIndex = getIndexOf("ID", jsonObject.COLUMNS);
var id = jsonObject.DATA[0][idIndex];

answered Aug 6, 2011 at 0:28

Mike Richards

5,6773 gold badges30 silver badges35 bronze badges

1 Comment

Mohamad Over a year ago

Mike, thank you. I understand. But Karim's solution seems to have taken care of it.

Collectives™ on Stack Overflow

How can I loop over this JSON result with jQuery?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related