Hi
I am trying to connect my Excel to my Kobo dataset. I tested this method with demo data and it worked well. Now when I try with new data in a new Excel, I get an error message in Excel saying:
“Unable to connect”
We encountered an error while trying to connect. Details: “Web.contents failed to get contents from ‘https://xxxxxxx’ (404): Not Found”.
I followed the instructions from the great online tutorials. I got the synchronous exports URL from the ‘KoboToolbox Form Building API’. (if I paste this into the browser the data downloads’.
However when in Excel I go to Data - Get data - From other sources - from web - and paste the URL I get the error above.
Please can someone assist?
Thank you very much in advance!
Welcome to the community, @karenvdw! Could you also let us know the sever you are using? Are you using one of our public servers or are you on a private server?
Morning
Apologies for the delay. I got it working last time. But I sit with the same problem again. I am using the Global KoboToolbox Server.
Hi @karenvdw,
Do you provide any credentials? such as username/password or API key? I believe this 404 usually a cause of not providing the correct credentials. It will work in the browser because you already logged in your account. So i believe if you provide the correct credentials, it should work in the excel as well
Thank you. It may be because I have previously connected to a different API with another user’s details and now I am using a different user.
But I cannot add the new user name and password for the API code that I am trying to call.
I have also noticed that the error message now is slightly different to my original question. It says:
"Unable to connect.
We encounted an error while trying to connect. Details: “The remote name could not be resolved: ‘kf.kobotoolbox.org’”
Thank you for the assistance and apologies for the back and forth.
To login to different user name, you can just click get data, Data source Setting and delete clear the permissions that used for kf.kobotoolbox.org. so next time it will ask you for a username and password.
Other option, you can use Token instead of username and password, under advance option. You can replace the xxxxxxxx with your token that you can find it under settings in Kobo
Fantastic, thank you very much!
Please can you explain where exactly I can find the token?
Click the icon on the top right corner of the web page. It looks like orange “O” in my case due to my user name, but it appear as first letter of your user name, then click account settings. under the security you will find API key, click display next to it and you can copy and paste it
Thank you for your help!
