Trouble with accessing object in JSON array

Question

I can't seem to figure out how to get this code snippet to work. I am trying to access the 'Name' object in this json snippet. Any help would be appreciated.

<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js">
</script>
<script>
$(document).ready(function () {
	$.getJSON('https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22AAPL%22)&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=', function(data) {
    	$('#demo').text(data[0].Name);
    });
});
</script>
</head>
<body>

<p id="demo"></p>

</body>
</html>

Please provide a sample of the actual JSON in the question itself. There may be people who can help you, but can't access the API url. — Heretic Monkey
– Heretic Monkey, Commented Feb 13, 2017 at 18:39

Matt Spinks · Accepted Answer · 2017-02-13 18:37:20Z

1

Use this:

$(document).ready(function () {
    $.getJSON('https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22AAPL%22)&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=', function(data) {
        $('#demo').text(data.query.results.quote.Name);
    });
});

answered Feb 13, 2017 at 18:37

Matt Spinks

6,7404 gold badges32 silver badges57 bronze badges

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

2 Comments

jrseriel Over a year ago

Thank you! I see that i need to access each object before I grab the one I want

Matt Spinks Over a year ago

You're welcome. You might take a look at this for reference: w3schools.com/js/js_json.asp

yBrodsky · Accepted Answer · 2017-02-13 18:36:35Z

0

{
    "query": {
        "count": 1,
        "created": "2017-02-13T18:34:48Z",
        "lang": "es-419",
        "results": {
            "quote": {
              "name": "Blabla"

So you have data.query.results.quote.name

answered Feb 13, 2017 at 18:36

yBrodsky

5,0614 gold badges24 silver badges35 bronze badges

Comments

mhodges · Accepted Answer · 2017-02-13 18:38:11Z

0

Your API call does not return an array, it returns a JSON object.

Try: $('#demo').text(data.query.results.quote.Name);

Here's what the data structure that is being returned looks like:

{
    "query": {
        "count": 1,
        "created": "2017-02-13T18:34:12Z",
        "lang": "en-us",
        "results": {
            "quote": {
                // other props...
                "Name": "Apple Inc.",
                // other props...
            }
        }
    }
}

answered Feb 13, 2017 at 18:38

mhodges

11.2k2 gold badges32 silver badges48 bronze badges

Collectives™ on Stack Overflow

Trouble with accessing object in JSON array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related