Javascript jquery json

Question

OK, so I have a json structure as follows.

Basically, what I want to do is loop over the json file and pull out the data if Country is equal to a specific value.

I'm sure this is pretty easy but i just can't work it out.

    {
"Site ID": 19955,
"Hotels": "Ramada Salzburg City Centre",
"Stadt": "Salzburg",
"Country": "Austria",
"Region": "Central & Eastern Europe",
"Link DE": "",
"Link EN": "",
"Link TR": "",
"Lat": 47.8137521,
"Long": 13.044259,
"Image": "/Salzburg.jpg"
     }

"pull out the data" - please explain this phrase, it's nonsensical — Jaromanda X, Nov 21 '16 at 00:30
Already answered there http://stackoverflow.com/questions/40711728/jquery-loop-through-json-objects/40716131#40716131 — Debug Diva, Nov 21 '16 at 08:59

score 2 · Answer 1 · answered Nov 21 '16 at 00:29

2

Use Array.prototype.filter

let austrianSites = sites.filter(site => site.Country === 'Austria')

answered Nov 21 '16 at 00:29

Phil

157,677
23
242
245

score 2 · Answer 2 · answered Nov 21 '16 at 00:29

2

Try

for (var i = 0, len = structure.length; i < len; i++) {
  if (structure[i].Country === someValue) {
    // do something here
  }
}

answered Nov 21 '16 at 00:29

rfornal

5,072
5
30
42

score 0 · Answer 3 · answered Nov 21 '16 at 00:38

How about checking if the JSON object has a property "Country" and if it does then output it. Hope it helps!

var jsonObject =  {
"Site ID": 19955,
"Hotels": "Ramada Salzburg City Centre",
"Stadt": "Salzburg",
"Country": "Austria",
"Region": "Central & Eastern Europe",
"Link DE": "",
"Link EN": "",
"Link TR": "",
"Lat": 47.8137521,
"Long": 13.044259,
"Image": "wp-content/themes/wyndham-hotels/img/Salzburg.jpg"
     }

for(var i in jsonObject){
  if(jsonObject.hasOwnProperty("Country")){
    var x = jsonObject.Country;
  }
}
document.write("The Country is: " + x);

score 0 · Answer 4 · answered Nov 21 '16 at 00:38

Please try this following:

var places = [{
  "Site ID": 19955,
  "Hotels": "Ramada Salzburg City Centre",
  "Stadt": "Salzburg",
  "Country": "Austria",
  "Region": "Central & Eastern Europe",
  "Link DE": "",
  "Link EN": "",
  "Link TR": "",
  "Lat": 47.8137521,
  "Long": 13.044259,
  "Image": "/Salzburg.jpg"
}, {
  "Site ID": 1211,
  "Hotels": "test",
  "Stadt": "Salzburg",
  "Country": "NZ",
  "Region": "Central & Eastern Europe",
  "Link DE": "",
  "Link EN": "",
  "Link TR": "",
  "Lat": 47.8137521,
  "Long": 13.044259,
  "Image": "/Salzburg.jpg"
}]

var filtered = places.filter(function(p) {
  return p.Country === "NZ";
})
console.log(filtered);

Javascript jquery json

4 Answers4