Question

72

Extracting data from json object in jQuery or JS

rated 0 times [ 75] [ 3] / answers: 1 / hits: 42104 / 12 Years ago, thu, june 7, 2012, 12:00:00

I want to use the currency data provided by https://raw.github.com/currencybot/open-exchange-rates/master/latest.json

As an initial test, I've created a cut-down version of this as an inline object:

var obj = [

{

    disclaimer: This data is collected from various providers and provided free of charge for informational purposes only, with no guarantee whatsoever of accuracy, validity, availability, or fitness for any purpose; use at your own risk. Other than that, have fun! More info: http://openexchangerates.org/terms/,

    license: Data collected from various providers with public-facing APIs; copyright may apply; not for resale; no warranties given. Full license info: http://openexchangerates.org/license/,

    timestamp: 1339036116,

    base: USD,

    rates: {

        EUR: 0.795767,

        GBP: 0.645895,

        JPY: 79.324997,

        USD: 1

    }

}];

All I want to be able to do is somehow query/grep/filter the json object with, for example, EUR as the criteria and have it return a variable called 'rate' with a value of '0.795767' as a result.

I've looked at the JQuery grep and filter functions but I can't figure out how to isolate just the 'rates' section of the object and then to get the rate I want.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

ulysses

Add To Favorites

Follow

Total Points: 111

Total Questions: 118

Total Answers: 113

Location: Zambia

Member since Sat, Oct 31, 2020

4 Years ago

answered 12 Years ago bryantc · Accepted Answer

var obj = [

{

    disclaimer: This data is collected from various providers and provided free of charge for informational purposes only, with no guarantee whatsoever of accuracy, validity, availability, or fitness for any purpose; use at your own risk. Other than that, have fun! More info: http://openexchangerates.org/terms/,

    license: Data collected from various providers with public-facing APIs; copyright may apply; not for resale; no warranties given. Full license info: http://openexchangerates.org/license/,

    timestamp: 1339036116,

    base: USD,

    rates: {

        EUR: 0.795767,

        GBP: 0.645895,

        JPY: 79.324997,

        USD: 1

    }

}];



obj[0].rates.EUR; // output: 0.795767

or

obj[0].rates['EUR']; output: //0.795767

DEMO

If you want to isolate rates in another variable and use that variable then try like following:

var rates = obj[0].rates;

Now,

rates.EUR;

rates.GBP;

and so on.