Accessing JSON data

Question

If I am given the following data by a web-service:

{
    "d": [
        {
            "col1": "col 1 data 1",
            "col2": "col 2 data 1"
        },
        {
            "col1": "col 1 data 2",
            "col2": "col 1 data 2"
        }
    ]
}

how do I access the second col1?

As the following:

success: function( data ) {
         alert( data.d ) ;
},

gives me:

[object Object],[object Object]

score 10 · Accepted Answer · answered Jul 15 '11 at 11:32

10

Its an array with 2 elements containing col1 and col2, so something like:

alert(data.d[1].col1);

(0 is the first element, and then you choose "col1")

answered Jul 15 '11 at 11:32

Nanne

63,347
16
116
159

score 4 · Answer 2 · answered Jul 15 '11 at 11:35

4

success:function(data){
data = JSON.parse(data); // you will have to parse the data first
alert(data.d[0].col1);

answered Jul 15 '11 at 11:35

Rafay

30,714
5
66
99

4

when using the jQuery `$.ajax()` function with the `dataType` specified as JSON it'll automatically parse it. – Ben Everard Jul 15 '11 at 11:36
Fair point, I just made the assumption it was already JSON as he could access the first level of the object :-) – Ben Everard Jul 15 '11 at 11:41

score 3 · Answer 3 · answered Jul 15 '11 at 11:35

alert( data.d[1].col1 ) ;

In human:

start at data variable
go to d property.
d is an array, so look up the value at index 1 (second value)
look up the col1 property of that value.

May I suggest console.log? In Chrome and with Firefox/Firebug it will give you a nice log message which tells you more about your data.

score 2 · Answer 4 · answered Jul 15 '11 at 11:33

Try this:

var json = {
    "d": [
        {
            "col1": "col 1 data 1",
            "col2": "col 2 data 1"
        },
        {
            "col1": "col 1 data 2",
            "col2": "col 1 data 2"
        }
    ]
};

alert(json.d[1].col1);

Specify the array index of d (starts with 0, so this would be 1) and then you can access child items. Here's a working example on jsFiddle.

Accessing JSON data

4 Answers4

Linked

Related