Retrieving array values from JSON array

Question

I am trying to retreive the values present in the JSON Array.However,my code is failing to get it executed.Below posted is how the file looks like.

{
  "meta" : {
    "view" : {
      "description" : "This data set shows the location of Baltimore City's Services.",
      "columns" : [{
          "cachedContents" : {
            "top" : [{
                "item" : "American Rescue Workers"
              }
            ]
          }
        }
      ]
    }
  }

My Apologies if my JSON file has got some syntax issues.I am trying to access the item element present in cachedContents.Below posted is the code.

$(document).ready(function () {

    $.get("https://data.baltimorecity.gov/api/views/hyq3-8sxr/rows.json", function (data) {
        $.each(data.meta.view, function (i, obj) {
            if (i == "name")
                $("#result").append("<p align='center'>" + obj + "</p>");
            if (i == "description")
                $("#result").append("<p>" + obj + "</p>");
            if (i == "columns")
                $.each(obj.i.cachedContents, function (i1, obj) {
                    $("#result").append("<p>" + "hi" + "</p>");
                });
        });
    });

});

Any suggestions would be highly helpful.

you never really access the item element...you do not event try to... — Dimitris Papageorgiou
– Dimitris Papageorgiou, Commented Dec 8, 2015 at 4:57

Yeldar Kurmangaliyev · Accepted Answer · 2015-12-08 05:32:50Z

3

Your JSON contains a lot of fields, and iterating through them and using if may have some performance issues.

You can directly access every member instead:

$(document).ready(function () {

  $.get("https://data.baltimorecity.gov/api/views/hyq3-8sxr/rows.json", function (data) {			
    $("#result").append("<p align='center'>" + data.meta.view.name + "</p>");
    $("#result").append("<p>" + data.meta.view.description + "</p>");

    data.meta.view.columns.forEach(function(c) {
      // here, 'c' is a column
      $("#result").append("<p>Column " + c.name + "</p>");
    });
  });

});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<div id="result"></div>

edited Dec 8, 2015 at 5:32

answered Dec 8, 2015 at 4:59

Yeldar Kurmangaliyev

34.3k13 gold badges64 silver badges104 bronze badges

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

1 Comment

mohan babu Over a year ago

However,It is not printing the cachedContents in it right?

Ajey · Accepted Answer · 2015-12-08 04:58:55Z

1

It should be

$.each(obj[0].cachedContents, function(i1, obj) {
      $("#result").append("<p>" + "hi" + "</p>");
    });

Object[0] not "i".

answered Dec 8, 2015 at 4:58

Ajey

8,25212 gold badges66 silver badges89 bronze badges

2 Comments

Dimitris Papageorgiou Over a year ago

does this code actually appends anything at all in #result?

iplus26 Over a year ago

No, I don't think so. The OP may want to iterate the obj to append something, not only the obj[0]

Collectives™ on Stack Overflow

Retrieving array values from JSON array

2 Answers 2

1 Comment

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Related