Recently Updated Support Article: Pulling Data Into Excel Power Query

[Kal_Lam]

Dear All,

Would like to inform you that we have recently updated our support article Pulling Data Into Excel Power Query.

Please visit our Help Center Page to learn more about other support articles.

[nat]

Thanks @Kal_Lam it’s brilliant that the support article has been updated. Just one thing to check though - this support article still refers to /api/v1 but I thought you were encouraging everyone to move to v2?
https://support.kobotoolbox.org/api.html

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…

@jnm what’s the current expectation around API versions? Are both v1 and v2 supported equally for the foreseeable future?

Thanks again for the documentation update @Kal_Lam

[Josh]

Hi @nat, currently only the KC v1 API has synchronous XLS exports and therefore will continue to be supported until a new (and improved) equivalent is released in KPI’s v2 API. I imagine there will be an overlap where the v1 endpoint will hang around until we eventually phase it out in favour of v2.