1

I'm trying to getJSON the following json data:

{
  "count": 96,
  "value": {
    "title": "cotripWeatherStations",
    "description": "Pipes Output",
    "link": "http:\/\/pipes.yahoo.com\/pipes\/pipe.info?_id=f43ccc14ab9d1c88d537236e93c1525e",
    "pubDate": "Mon, 03 Sep 2012 02:17:48 +0000",
    "generator": "http:\/\/pipes.yahoo.com\/pipes\/",
    "callback": "",
    "items": [
      {
        "ws:Location": {
          "global:Latitude": "37.086807",
          "global:Longitude": "-104.521294"
        },
        "ws:Device": {
          "global:DeviceId": "6796",
          "global:CommonName": "025N008  RATON PASS (RWIS)",
          "global:Status": "enabled",
          "global:EntityId": "1",
          "global:RoadId": "31",
          "global:RoadName": "I-25",
          "global:Direction": "North",
          "global:MileMarker": "8",
          "global:LastUpdateDate": "2012-08-26T13:52:00.000-06:00",
          "global:Icon": "theme\/cotrip.org\/images\/devices\/icon_device_weather_station_with_cam_16x23.gif"
        }
      }
   ]
}

the following code gives me an alert with output, but no data:

var weather = $.getJSON("http://pipes.yahoo.com/pipes/pipe.run?_id=f43ccc14ab9d1c88d537236e93c1525e&_render=json&_callback=?", function(json) {
  alert("JSON Data: " + json.value["items"]);
});

how do I traverse further into this JSON to 'ws:Devise - "global:CommonName"

kinakuta
  • 9,029
  • 1
  • 39
  • 48
Loghome Finishing
  • 13
  • 1
  • 5

1 Answers1

6

How about

json.value.items[0]['ws:Device']['global:CommonName']

?

http://jsfiddle.net/zerkms/D2JKR/

zerkms
  • 249,484
  • 69
  • 436
  • 539
  • thanks zerkms, that works great! here is my jsFiddle showing the alert http://jsfiddle.net/tutone/8k4AV/3/ most importantly I can move forward now that I know how to work with this complex data! – Loghome Finishing Sep 03 '12 at 03:24