Parsing JSON using JQuery

Question

I have a JSON as follows

{
  columns      : [RULE_ID,COUNTRY_CODE],
  RULE_ID      : [1,2,3,7,9,101,102,103,104,105,106,4,5,100,30], 
  COUNTRY_CODE : [US,US,CA,US,FR,GB,GB,UM,AF,AF,AL,CA,US,US,US]
}

I need to retrive the column names from the columns entry and then use it to search the rest of the entries using jquery. For example I get each column using

jQuery.each(data.columns, function(i,column))

I need to loop throgh the rest of the entries using the values I get from the previous loop. ie without hardcoding COUNTRY_CODE or RULE_ID. What is the best way to do that using Jquery?

nitpicking: this is a JavaScript object, but it's not JSON (the string-based data interchange format) — orip
– orip, Commented Dec 9, 2008 at 12:25

Paolo Bergantino · Accepted Answer · 2008-12-09 11:58:36Z

9

jQuery.each(data.columns, function(i,column) {
    jQuery.each(data[column], function(i, row) {
    ....
    });
});

answered Dec 9, 2008 at 11:58

Paolo Bergantino

490k83 gold badges523 silver badges437 bronze badges

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

Comments

Vincent Robert · Accepted Answer · 2008-12-09 22:53:00Z

Some comments:

Paolo is right, you can use data[column] to get the list of values:

jQuery.each(data.columns, function(iCol,column) {
    jQuery.each(data[column], function(iRow, row) {
    ....
    });
});

Do you need the columns information ? You could get the list of "columns" by iterating directly over data:

for( var column in data )
{
    jQuery.each(data[column], function(i, row) {
    ....
    });
}

Not really a question but your JSON is not valid JSON, I hope this was only an example and not your real data:

{
  "columns"      : ["RULE_ID","COUNTRY_CODE"],
  "RULE_ID"      : [1,2,3,7,9,101,102,103,104,105,106,4,5,100,30], 
  "COUNTRY_CODE" : ["US","US","CA","US","FR","GB","GB","UM","AF","AF","AL","CA","US","US","US"]
}

Collectives™ on Stack Overflow

Parsing JSON using JQuery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related