How to connect API to excel

[governalert]

I used to get the URL API link from this https://kc.humanitarianresponse.info/api/v1/data but as of today May 9th, 2024, the link seems not to work again. please, how do get the URL link of governalert?

Thank you

[osmanburcu]

Hi @governalert, You can use the links below and i will add a youtube link if needed. It is for Power BI but it same for Power Query.

https://support.kobotoolbox.org/api.html?highlight=api

KoBo API examples, using new KPI endpoints

This is copied from some private correspondence I had a while ago. Perhaps it’s useful to someone in this format, until more official documentation is developed for the new API In writing “new,” I’m contrasting KPI to the old KoBoCAT (/api/v1) API. KoBo API Examples I’ve used curl to demonstrate these API calls. You’ll notice that all my curl commands begin with curl --silent --user jnm_api:some-secret-phrase --header 'Accept: application/json' and end by being piped to python -m…

How to import data from Kobo Toolbox to Power BI and Update it Automatically

[Kal_Lam]

@osmanburcu,

[Kal_Lam]

@governalert, you can also refer to this support article Connecting KoboToolbox to Microsoft Excel for further learning.