I am attempting to use a Google Sheet as a Remote Dataset in Xibo CMS 2.3.7, but the “test data URL” keeps failing with “400 Bad Request” response.
The Google Sheet is published to the web as a CSV file, but it does require a login to access it, it is not public. This is a requirement of our company, we cannot make Google docs public. I have supplied a username and password on the Authentication tab, but the test still fails. It appears to be failing because of the login requirement.
Has anyone else been able to link a Google sheet published as a CSV successfully when credentials are required? I have not been able to find much in the way of instructions for doing this.