Access JSON Object in array

Question

Hi I'm trying to do some charting with Google Analytics and I can get the data into JSON but I get stuck from there, this is the json as seen in firebug.

{"total_results":1,"rows":[[7861]],"column_headers":[{"dataType":"INTEGER","columnType":"METRIC","name":"ga:visits"}]}

So I'm trying to extract the fact that gavisits has 7842 results for the last 30 days, this is my code

$.getJSON(
"https://api.oocharts.com/v1/query.jsonp?" //note the 'jsonp' return type
+ "query=" + "visits-by-date-cg"
+ "&key=" + "myapikey here"
+ "&start=" + "30d" //30 days from current date
+ "&callback=?"
, null, function(data) {
    console.log(JSON.stringify(data));
});

How do I loop through the 'data' to get 7842 so that I can store this as a variable?

Thank you

The thing you posted above doesn't look like a JSON. Do console.log(JSON.stringify(json)) — MightyPork
– MightyPork, Commented Jul 31, 2013 at 20:00
thanks man, the JSON.stringify gave me a more legible output, I have updated the result above — uknowit2
– uknowit2, Commented Jul 31, 2013 at 20:47
McGarnagle that did the trick without me having to use JSON.stringify, nice work, thank you — uknowit2
– uknowit2, Commented Jul 31, 2013 at 20:57

Paul · Accepted Answer · 2013-07-31 20:54:43Z

1

You won't find 7842 anywhere in that object, but there is a property called rows containing an array with one value, which itself is an array with one value, which is 7861. That's probably what you're looking for:

data.rows[0][0]

answered Jul 31, 2013 at 20:54

Paul

142k28 gold badges285 silver badges272 bronze badges

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

1 Comment

uknowit2 Over a year ago

yes sorry 7861 is what I was looking for. Thanks for the correct answer

Collectives™ on Stack Overflow

Access JSON Object in array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related