Yes, I am able to access Central in my browser...no issues at all.
When I try to access the Odata feed in Excel, I copy and paste the OData feed from the browser version of ODK Central and enter my logon credentials, it gives me a 403 error...
Any ideas or areas to further investigate? Thank you for helping me troubleshoot this so far.
What version of ODK Central are you using? If you don't know, you can find out by appending /version.txt to your base URL. For example, for the Central sandbox, it is https://sandbox.central.opendatakit.org/version.txt.
Hi.
Great. I am using versions:
75f11f18b6d697a73b025b46a9d0e7f6e2e5f0c0
a45a941b108803a7930ae98c1bf581fc1b5ac4fa client (v0.6.1-beta.0)
268ec9e380d3e16b1c52e59599dadef5c0784d36 server (v0.6.0-beta.0).
Yes, I copied and pasted the OData URL correctly.
I do have access to Central sandbox, however I am unable to download an OData feed from one of the forms in the sandbox as well...
I know you reset your stored credentials before, but did you also reset them before accessing the OData feed from the sandbox? Did Excel prompt you for your email address and password for the sandbox? I just want to be sure that you're not able to access an OData feed from the sandbox.
I also wanted to ask about the role that your user has within Central. Your sandbox user is a sitewide administrator, right? In your own installation, is the user whose credentials you're entering in Excel also a sitewide administrator? Does the user definitely have access to the project and form whose OData feed you're attempting to access? (Is the same user able to view the form in the browser?)
I reset my stored credentials before accessing OData feed from the sandbox. Excel did prompt me for my username and password.
My role in my own installation is sitewide administrator. In the sandbox, my role is the same (I believe). I am using Internet Explorer (although I do not think this should matter as I am trying to pull an OData feed). I definitely have access in my own installation as well.
I'm not sure what the issue could be. Out of curiosity, are you able to access the OData feed in PowerBI? (I think there is a free version available if you don't have PowerBI already.) Excel and PowerBI both use Power Query under the hood, but it'd be useful to see whether there are any differences in terms of your ability to access the OData feed.
My pleasure! If you're able to, it'd be very useful if you could tell us more about the user error, in case other users run into the same error. Is there a way that the Central documentation could be improved to help users avoid the error?
I am facing an exactly similar problem as yours (Getting 403 error when trying to connect in Excel). My server is residing in Amazon cloud (AWS). Authentication credentials are also correct. I assume firewalls are also open and allowing (else it would have given connection timeout instead of 403 error). Can you help in explaining how you fixed the thing?
I finally got my hands on a Windows machine (eww) with Power BI installed (yay) and needed to delete my cached credentials. Could this be worth a mention in the OData modal?