I am getting a bad gateway response when trying to access my data using the API URL

[tomisin]

@Kal_Lam

Good day.

I have a Kobo-power bi setup which has been up and running successfully for over 2 years until recently when I started getting the error message below. I have been trying to resolve it, but, still to no avail.

[tomisin]

Dear @Kal_Lam,

I am getting a bad gateway response when trying to access my data using the API URL.

[tomisin]

This is the error message I am getting when trying to access the link to the JSON API on the web browser.

[osmanburcu]

Hi @tomisin

Url to kobo has changed as 1th September, you need to edit your power bi link. replace the kobo.humanitarianresponse.info with eu.kobotoolbox.org, It will work perfectlt after

[tomisin]

Thank you so much @osmanburcu

The URL to kobo change was noted and I had edited the URL into the new one at a point, but the page was not found.

Every other thing with the old URL still working perfectly or you might just be redirected…

See the screenshot with the edit to the URL as suggested.

[Kal_Lam]

@tomisin, would you mind trying out this API instead?

https://kc-eu.kobotoolbox.org/api/v2/data

This should solve your issue!

[tomisin]

@Kal_Lam , I have tried using the specified URL. But still returning the same error message.

[Kal_Lam]

@tomisin, may bad! Please use v2 instead of v1. Have also fixed it in my previous post!

[osmanburcu]

I tried the same api/v1. It worked perfectly as Kal suggested

[tomisin]

Thank you so much, team.

@Kal_Lam , I think the issue of not being able to access the data affects about two forms out of the many on that account. Even exporting data from the particular form has been challenging for about one month now, see screenshot below.

I have tried using v2, but, it keeps redirecting me to v1 within the URL once I click on enter.

[tomisin]

@Kal_Lam , I think the issue of not being able to access the data affects about two forms out of the many on that account. Even exporting data from the particular form has been challenging for about one month now, see screenshot below.

[tomisin]

@osmanburcu and @Kal_Lam

Thank you so much, team.

@Kal_Lam, I think the issue of not being able to access the data affects about two forms out of the many on that account. Even exporting data from the particular form has been challenging for about one month now, see screenshot below.

[timsimp]

@tomisin As of September 1st, the URL for Kobo has changed. To update your Power BI link, replace “kc.humanitarianresponse.info” with “eu.kobotoolbox.org.” After making this change, your link should work perfectly.