How to iterate over this strange JSON
Hello all,
I am pretty new to using jQuery, so I am sure this question will be pretty easy. I have a JSON string I need to iterate over, however it is a little different looking than your normal JSON. I mean it validates in JS lint, so it is fine, I don't don't know how to loop over it and work with it. I need to loop over every row found in the "DATA" section and add a new radio button representing that row, and the details about the time and address (found within the JSON).
Here is what it looks like. You'll see the first section is called COLUMNS, and then is the section called DATA. Columns is basically the name of the data point at that index position (this is actually a Cold Fusion query object after being converted to JSON).
{
"COLUMNS": [
"RECORDTYPEID",
"INCENTIVE_AMOUNT_PAID_FOR_STUDY__C",
"TYPE",
"STARTDATE",
"SESSION_LENGTH__C",
"TESTING_LOCATION__R",
"TIME_SLOT__C",
"PARENTID",
"RECRUITS_PER_TIME_SLOT__C",
"ID",
"NAME",
"TESTING_LOCATION__R_ID",
"TESTING_LOCATION__R_ADDRESS__C",
"TESTING_LOCATION__R_ZIP_POSTAL_CODE__C",
"TESTING_LOCATION__R_TYPE",
"TESTING_LOCATION__R_LOCATION_FULL_NAME__C",
"TESTING_LOCATION__R_STATE_PROVIDENCE__C",
"TESTING_LOCATION__R_CITY__C"
],
"DATA": [
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"10:00am",
"70140000000KlFyAAK",
54.0,
"70140000000KlG3AAK",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_10:00",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
],
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"11:45am",
"70140000000KlFyAAK",
54.0,
"70140000000KlG8AAK",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_11:45",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
],
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"2:00pm",
"70140000000KlFyAAK",
54.0,
"70140000000KlGDAA0",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_2:00",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
]
]
}
I tried using something like
$.each(sessionData, function(i, val)
{
$("##" + i).append(document.createTextNode(" - " + val));
});
but it didn't really work. If i tried to replace the document.createTextNode with an alert with the i and val variables printed out, it seemed to print the entire JSON string character by character. Don't know why it did that. Again, thanks for any help. I appreciate it.
I am pretty new to using jQuery, so I am sure this question will be pretty easy. I have a JSON string I need to iterate over, however it is a little different looking than your normal JSON. I mean it validates in JS lint, so it is fine, I don't don't know how to loop over it and work with it. I need to loop over every row found in the "DATA" section and add a new radio button representing that row, and the details about the time and address (found within the JSON).
Here is what it looks like. You'll see the first section is called COLUMNS, and then is the section called DATA. Columns is basically the name of the data point at that index position (this is actually a Cold Fusion query object after being converted to JSON).
{
"COLUMNS": [
"RECORDTYPEID",
"INCENTIVE_AMOUNT_PAID_FOR_STUDY__C",
"TYPE",
"STARTDATE",
"SESSION_LENGTH__C",
"TESTING_LOCATION__R",
"TIME_SLOT__C",
"PARENTID",
"RECRUITS_PER_TIME_SLOT__C",
"ID",
"NAME",
"TESTING_LOCATION__R_ID",
"TESTING_LOCATION__R_ADDRESS__C",
"TESTING_LOCATION__R_ZIP_POSTAL_CODE__C",
"TESTING_LOCATION__R_TYPE",
"TESTING_LOCATION__R_LOCATION_FULL_NAME__C",
"TESTING_LOCATION__R_STATE_PROVIDENCE__C",
"TESTING_LOCATION__R_CITY__C"
],
"DATA": [
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"10:00am",
"70140000000KlFyAAK",
54.0,
"70140000000KlG3AAK",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_10:00",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
],
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"11:45am",
"70140000000KlFyAAK",
54.0,
"70140000000KlG8AAK",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_11:45",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
],
[
"01240000000DiVIAA0",
40.0,
"Campaign",
"2010-05-28",
75.0,
{
"Id": "",
"Address__c": "7625 Chicago Avenue",
"Zip_Postal_Code__c": 55423.0,
"type": "Testing_Location__c",
"Location_Full_Name__c": "House Of Prayer",
"State_Providence__c": "MN",
"City__c": "Richfield"
},
"2:00pm",
"70140000000KlFyAAK",
54.0,
"70140000000KlGDAA0",
"00600-GMIS-StrawMultiGrainCheerios052810HOP_2:00",
"",
"7625 Chicago Avenue",
55423.0,
"Testing_Location__c",
"House Of Prayer",
"MN",
"Richfield"
]
]
}
I tried using something like
$.each(sessionData, function(i, val)
{
$("##" + i).append(document.createTextNode(" - " + val));
});
but it didn't really work. If i tried to replace the document.createTextNode with an alert with the i and val variables printed out, it seemed to print the entire JSON string character by character. Don't know why it did that. Again, thanks for any help. I appreciate it.