How do I access variables in this JSON return using jQuery

Question

How do I access the returned JSON Data? e.g the name array? to work

JSON...

{"COLUMNS":["NAME"],"DATA":[["Item 1"],["Item 2"]]}

The data.NAME[1] doesn't seem to have any data in it..

 $.getJSON('url/json.php',
     function(data){
    $('#debug').html('data:' + data.NAME[1]);
            });
        });

jAndy · Accepted Answer · 2010-07-02 06:10:11Z

2

Parsing your JSON string

{"COLUMNS":["NAME"],"DATA":[["Item 1"],["Item 2"]]}

will return a javascript object like:

var data = {
    COLUMNS: ["NAME"],
    DATA: [["Item 1"], ["Item 2"]]   
}

so there is no identifier for data.NAME[1].

You may access data.COLUMNS[0] returning "NAME" or data.DATA[0][0] returning "Item 1".

edited Jul 2, 2010 at 6:10

answered Jul 2, 2010 at 6:01

jAndy

237k57 gold badges313 silver badges363 bronze badges

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

1 Comment

Anurag Over a year ago

+1 nice answer. You probably meant data.DATA[0][0] there. Weird JSON structure.

deceze · Accepted Answer · 2010-07-02 05:30:46Z

1

Not sure what you're trying to access.
data.COLUMNS[0] should get you "NAME".
data.DATA[0] should get you the ["Item 1"] array.

answered Jul 2, 2010 at 5:30

deceze♦

525k89 gold badges807 silver badges954 bronze badges

Comments

Iain · Accepted Answer · 2010-07-02 05:33:13Z

0

If you are using aspx make sure that you check data.d not data. (this was a recent change?)

answered Jul 2, 2010 at 5:33

Iain

2,3091 gold badge16 silver badges18 bronze badges

1 Comment

Brett Over a year ago

its from coldfusion actually, SeralizeJSON function...oddness

Collectives™ on Stack Overflow

How do I access variables in this JSON return using jQuery

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related