OECD API connection

[juan_diego]

Guys, greetings!

Has anyone from you connected to the OECD API?

[mborriero]

Hi @juan_diego, just now. Please find sample attached.

[juan_diego]

@mborriero, A thousand thanks.

 this is the workflow I am has been built, but I could not organize the data .JSON.

regards

[mborriero · Accepted solution]

@juan_diegounfortunately it is a bit more complicated that that.

Each JSON files can be structured in a different way, depending from the source.

The attached workflow should give you the data that you need.

I am not sure about the column "order" that I have created.

Hope it helps.

[juan_diego]

@mbrriero thousan thanks!!!

This workflow was very useful

[fabianrudolf]

Hi,

for future reference: one could also connect to the API via Python Tool integration downloading files directly as csv for some datasets, e.g. with the following code snippet adapted from this discussion on stackoverflow.

import pandas as pd

def oecd_request(sdmx_query):
    return pd.read_csv(f"https://stats.oecd.org/SDMX-JSON/data/{sdmx_query}?contentType=csv")

sdmx_query = "MEI_FIN/IRLT.AUS.M/OECD"
result = oecd_request(sdmx_query)
Alteryx.write(result, "#1")

Like this, you can now avoid parsing any JSON.

Kind regards,