Parsing JSON object within a JSON response

Question

I'm trying to get a bit of javascript working to pull back a currency conversion.

Using the API from fixer.io, I'm requesting http://api.fixer.io/latest?symbols=USD&base=GBP

I get an object back, but I don't know how to drill down to the currency value I need.

My code so far:

function GetMarketRate() {

    var url = 'http://api.fixer.io/latest?symbols=_CURR&base=GBP'.replace("_CURR", "@Model.CurrencyId");

    var xhr = new XMLHttpRequest();
    xhr.open('GET', url, true);

    xhr.onload = function () {
        var res = window.JSON.parse(xhr.responseText);

        //Drill down

    };

    xhr.onerror = function () {
        //Process error
    };

    xhr.send();

};

I'm using MVC and Razor to amend the URL to get the Currency. I will then take the decimal value and insert it into an inline div as the page loads.

The only problem I have is actually getting to that value. My API request is such that it will only ever pull back one value - don't know if that helps things.

Since we don't know how the JSON is organised, we can't tell you (short of writing a complete guide to how to access object properties and loop over data in JS). — Quentin, Jun 18 '15 at 15:43
console.log(res) returns: Object {base: "GBP", date: "2015-06-18", rates: Object} — Stuart Frankish, Jun 18 '15 at 15:49

score 0 · Accepted Answer · answered Jun 18 '15 at 15:49

0

The returned object looks like:

{"base":"GBP","date":"2015-06-18","rates":{"USD":1.5912}}

So you should be able to use:

res.rates.USD // 1.5912

answered Jun 18 '15 at 15:49

Jason Cust

10,743
2
33
45

I need to be able to use @Model.CurrencyId in Razor to define the currency. How do I code it to include this? – Stuart Frankish Jun 18 '15 at 15:52
This has actually helped alot. I can use res.rates.@Model.CurrencyId which gets me what I need. Thank you! – Stuart Frankish Jun 18 '15 at 15:55
I'm not familiar with Razor but as long as it preprocesses the code then it sounds like it should work. – Jason Cust Jun 18 '15 at 15:59
Razor is an ASP.NET view engine, long story short, yes it preprocesses the page before returning the response to the browser. – Stuart Frankish Jun 18 '15 at 19:44

Parsing JSON object within a JSON response

1 Answers1