Link requires google account, anyone have a synopsis?

diabeetusman · on Nov 23, 2020

Created issue. A short description of the issue:

Private Sheet public CSV export requires authentication when set not to

What steps will reproduce the problem?

1. create a private(!) Google Sheet

2. set public CSV export publication

3. access the endpoint without credentials

What is the expected output? What do you see instead? If you see error messages, please provide them.

You should receive a CSV file, you get HTML5 login form.

Please provide any additional information below.

Setting the Sheet to Public with a link fixes the problem, there's an obvious bug with the permissions taken from the Sheet, not the Export.

jakear · on Nov 23, 2020

Thanks! Perhaps the issuetracker and sheets teams will be able to work together on a new permission-less access policy. ;)

advisedwang · on Nov 23, 2020

Someone reported the bug, a @google.com replies verifying they reproduced it and have forwarded internally (attaching a private "blocked by" bug).

So it sounds like they accept this is an issue.

brundolf · on Nov 23, 2020

Note that a comment further down says:

> I have heard that this appears to not be a bug, rather an intentional change that they didn't announce in advance.

Not sure where "I have heard" comes from, but