Nested json?

[ariloc]

Hi, I was trying to get a currency value (from USD to ARS) using Open Exchange Rates API. I use HTTP Request (GET https://openexchangerates.org/api/lates ... id=MYAPPID) to get a JSON response. I have seen several discussions on the forum about JSON and the most near I could get was this in order to get what I want to use:

data = fromJSON(response);
variable = data[0]["ARS"];

However, I could not get it to work as I see that the value I want to get is nested into another one called "rates". How do I do in order to get a nested value.

Sorry for my incomprehensible English and I don't know much about JSON actually.

API documentation: https://docs.openexchangerates.org/

[Desmanto]

I also don't know much about JSON. Currently I am also trying to digest XML lesson, and need hours just make 2-3 script

But if you don't mind the way, you can use Regex to capture the value. I am still learning it, automagic regex tester has been very helpful.

data = findAll(findAll(response, "ARS: \\d+\\.\\d+"), "\\d+\\.\\d+");
ars = data[0];

I know regex can have non capturing group. However, so far I tested in Automagic, i have to capture it twice to remove the non capturing group ("ARS: "). Hopefully someone can show me how. But currently this is my best solution. Result got from findAll() always in list form. So, to access the result in value, we have to get the first element only.

[Martin]

Hi,

This is the example JSON provided in the documentation:

Code: Select all

{
    disclaimer: "https://openexchangerates.org/terms/",
    license: "https://openexchangerates.org/license/",
    timestamp: 1449877801,
    base: "USD",
    rates: {
        AED: 3.672538,
        AFN: 66.809999,
        ALL: 125.716501,
        AMD: 484.902502,
        ANG: 1.788575,
        AOA: 135.295998,
        ARS: 9.750101,
        AUD: 1.390866
    }
}

The JSON itself is a map that has the keys disclaimer, timestamp, base and rates. rates itself is also a map with keys AED, AFN etc.

data["rates"] evaluates to the entire map containing all rates so you could write it like this:

Code: Select all

data = fromJSON(response);
rates_map = data["rates"];
variable = rates_map["ARS"];

or the more condensed form without storing the rates map in it's own variable first:

Code: Select all

data = fromJSON(response);
variable = data["rates"]["ARS"];

Regards,
Martin