Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

OECD API connection

juan_diego
6 - Meteoroid

Guys, greetings!

Has anyone from you connected to the OECD API?

5 REPLIES 5
mborriero
11 - Bolide

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

juan_diego
6 - Meteoroid

@mborriero, A thousand thanks.

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

regards

mborriero
11 - Bolide

@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
6 - Meteoroid

@mbrriero thousan thanks!!!

 

This workflow was very useful

fabianrudolf
5 - Atom

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,

 

Labels