parse JSON 3rd level child

Question

Hi all I'm new to json and I am trying to get the price of gold 3rd level contents->MyFeed->XAUCAD->bid H get this feed from php proxy can someone help be in how to get the gold price

$(document).ready(function () {
    $.getJSON("http://feed.php",
        function (data) {
            alert(data.gold);
        });
});

JSON

{
    "headers": {
        "Cache-Control": "private",
        "Content-Type": "application/json; charset=utf-8",
        "Server": "Microsoft-IIS/7.0",
        "X-AspNet-Version": "4.0.30319",
        "X-Powered-By": "ASP.NET",
        "X-Served-By": "",
        "Date": "Wed, 22 Jan 2014 06:35:06 GMT",
        "Content-Length": "200"
    },
    "status": {},
    "contents": {
        "MyFeed": {
            "@Provider": "FastMarkets",
            "XAUCAD": {
                "@name": "Gold Canadian $",
                "bid_time": "20140122063506",
                "bid": "1360.44"
            },
            "XAGCAD": {
                "@name": "Silver Canadian $",
                "bid_time": "20140122063507",
                "bid": "21.76"
            }
        }
    }
}

you want to get the output by php or javascript? – user2936213 Jan 22 '14 at 06:42 — user2936213, Jan 22 '14 at 06:42

score 2 · Accepted Answer · answered Jan 22 '14 at 06:42

2

console.log(data.contents.MyFeed.XAUCAD.bid);

answered Jan 22 '14 at 06:42

Ohgodwhy

49,779
11
80
110

score 1 · Answer 2 · answered Jan 22 '14 at 06:46

I have considered that data = JSON file that you have mentioned

$(document).ready(function () {
    $.getJSON("http://feed.php",
        function (data) {
//This should open alert dialog containing gold bid
            alert(data.contents.MyFeed.XAUCAD.bid);
    });
});

score 0 · Answer 3 · answered Jan 22 '14 at 06:47

You can get this way

var a ={
    "headers": {
        "Cache-Control": "private",
        "Content-Type": "application/json; charset=utf-8",
        "Server": "Microsoft-IIS/7.0",
        "X-AspNet-Version": "4.0.30319",
        "X-Powered-By": "ASP.NET",
        "X-Served-By": "",
        "Date": "Wed, 22 Jan 2014 06:35:06 GMT",
        "Content-Length": "200"
    },
    "status": {
    },
    "contents": {
        "MyFeed": {
            "@Provider": "FastMarkets",
            "XAUCAD": {
                "name": "Gold Canadian $",
                "bid_time": "20140122063506",
                "bid": "1360.44"
            },
            "XAGCAD": {
                "name": "Silver Canadian $",
                "bid_time": "20140122063507",
                "bid": "21.76"
            }
        }
    }
}

$(document).ready(function(){
    alert(a.contents.MyFeed.XAUCAD.bid);
});

Fiddle Demo

parse JSON 3rd level child

3 Answers3