0

I have a set of json data that has been output via a url. The data has got different levels and I need to access one level and then use that data in a jquery loop to manipulate some functions.

The json url outputs data like this:

{
"id": 32,
"title": "sascas",
"synopsis": "<p>cxcxcx</p>\r\n",
"body": "<p>cxccxxc</p>\r\n",
"created_at": "2014-09-25T14:12:06.345Z",
"updated_at": "2014-09-25T14:12:06.345Z",
"author": {
"name": "A test author",
"biography": "/system/authors/avatars/000/000/024/original/photo.JPG?1411472688",
"id": 24
},
"schools": {
"schools": [
{
"id": 5,
"school_name": "Another london school Inner Circle Regent's Park, London",
"website": null,
"book_id": 32,
"created_at": "2014-09-25T14:12:06.413Z",
"updated_at": "2014-09-25T14:12:06.413Z"
},
{
"id": 6,
"school_name": "city of london school 107 Queen Victoria St London",
"website": null,
"book_id": 32,
"created_at": "2014-09-25T14:12:06.417Z",
"updated_at": "2014-09-25T14:12:06.417Z"
}
]
}
}

I am basically trying to access the schools data only in this loop within a js function. Currently the function uses and each loop and adds markers onto a map. What I want to know is can my function get the schools data only? Here is my js function for it:

var initMap = function () {

# The url that is generated in the html for me to grab
var info = $('#map').data('book-title');
$.get(info, {}, function(response) {
setMarkers(map, response);
# some other js stuff for map here inside the $get
}, 'json');

}

Then in the setmarkers function I have this:

function setMarkers(map, json) {
jQuery.each(json, function (index, city) {
var school = city['schools'];
console.log(school);
});
}

In the output in console I get this:

[Object, Object]0: Object book_id: 32 created_at: "2014-09-25T14:12:06.413Z"id: 5school_name: "Another london school Inner Circle Regent's Park, London" updated_at: "2014-09-25T14:12:06.413Z" website: null__proto__: Object__define Getter__: function __defineGetter__() { [native code] }__defineSetter__: function __defineSetter__() { [native code] }__lookupGetter__: function __lookupGetter__() { [native code] }__lookupSetter__: function __lookupSetter__() { [native code] }constructor: function Object() { [native code] }hasOwnProperty: function hasOwnProperty() { [native code] }isPrototypeOf: function isPrototypeOf() { [native code] }propertyIsEnumerable: function propertyIsEnumerable() { [native code] }toLocaleString: function toLocaleString() { [native code] }toString: function toString() { [native code] }valueOf: function valueOf() { [native code] }get __proto__: function __proto__() { [native code] }set __proto__: function __proto__() { [native code] }1: Objectbook_id: 32created_at: "2014-09-25T14:12:06.417Z"id: 6school_name: "city of london school 107 Queen Victoria St London"updated_at: "2014-09-25T14:12:06.417Z"website: null__proto__: Objectlength: 2__proto__: Array[0]

I need to access specific data from this array namely school_name. Is this possible at all?

000
  • 26,951
  • 10
  • 71
  • 101
M dunbavan
  • 1,157
  • 5
  • 22
  • 57
  • 2
    Of course. `city['schools']` is an array of schools, so just iterate over that. See [Access / process (nested) objects, arrays or JSON](http://stackoverflow.com/questions/11922383/access-process-nested-objects-arrays-or-json) – Felix Kling Sep 25 '14 at 16:43
  • 1
    Felix is a wizard here. If he refers you to an article, read the article. Study it. Understand it. True happiness will be yours. – cssyphus Sep 25 '14 at 16:50
  • I can use the `console.log(data['school_name']);` to get the name of one school but this is within a .each loop already so I did ` jQuery.each(json['schools'], function (index, city)` which goes through the array and gets the schools data. I just need inside the loop to get each school name thats all. – M dunbavan Sep 25 '14 at 17:34

2 Answers2

0
console.dir(school)

-- May give you a clearer view of what you're seeing.

As another poster said, since school is an array of schools, you best bet is to iterate over that. You can use the .each method you're currently utilizing elsewhere via jQuery or a standard for loop in javascript.

for (var i = 0; i < schools.length; i++) {
  //Party with stuff in here
}

Best of luck!

Christopher Robot
  • 301
  • 1
  • 8
0

This jQuery.each will print school data:

 jQuery.each(response.schools.schools, function (i, school) {
        console.log( "id " + school["id"] + ", school_name: " + school["school_name"]  );
  });

or alternative 

jQuery.each(response.schools.schools, function (i, school) {
    console.log( "id " + school.id + ", school_name: " + school.school_name  );
});

Prints:

id 5, school_name: Another london school Inner Circle Regent's Park, London

id 6, school_name: city of london school 107 Queen Victoria St London

Note my fiddle was done without JSON request.

jyrkim
  • 2,849
  • 1
  • 24
  • 33
  • 1
    can I use that inside my jQuery.each? – M dunbavan Sep 25 '14 at 18:40
  • @Mdunbavan yes, it looks like jQuery.each and For loop do the same thing. This was actually the first time I used jQuery.each method and it seems very handy indeed :-) – jyrkim Sep 26 '14 at 09:04