We are encountering an issue when attempting to import data from our form into Power Query. For the past week, when opening the Excel file connected to the data source (https://kc.kobotoolbox.org/api/v1/data/1292869), we receive the following error message:
“[DataSource.Error] Web.Contents failed to get contents from ‘https://kc.kobotoolbox.org/api/v1/data/1292869’ (500): Internal Server Error.”
We understand that API v1 may no longer be supported and that API v2 should be used instead. Could you please confirm this? Additionally, could you provide guidance on how we can resolve this issue and continue with our data import?
Thank you for your assistance.
Hi, @matskevych, Welcome to community!
Can you try to add .json to in the end of your link? It might solve your problem
https://kc.kobotoolbox.org/api/v1/data/1292869.json
1 Like
Hi @osmanburcu ,
Thank you for your suggestion. I tried adding .json to the end of the link, as you advised.
However, I am still encountering the same issue with the error message:
“[DataSource.Error] Web.Contents failed to get contents from ‘https://kc.kobotoolbox.org/api/v1/data/1292869.json’ (500): Internal Server Error.”
Could you please provide further guidance or any alternative solutions to resolve this problem?
Thank you for your continued support.
I checked the link, link is perfectly fine. can you log in your account and paste the link in same browser to check if you are able to see your data in json format
1 Like
Dear @osmanburcu
link is not working, the same issue
I believe you are not using the Global server, you are using the humanitarian server thats why your first link were not working because you were not loged in to global server. The error you got know is about the authorization. You need to provide the authoriziation header to be able to connet your data.
1 Like
