Hi all, Related to this issue, I discovered that you can restore the original behaviour by setting the share link to "Anyone with the link can view" as shown below.
After the link is made public, the CSV (and other export types) are publicly accessible again. Is it intentional that these two settings compete? Kind regards, Bert Peters On Wednesday, November 18, 2020 at 10:09:25 AM UTC+1 ru...@channable.com wrote: > Hi, > > We are an integrator that allow our users to import data from a.o. Google > Sheets. We do this by asking users to publish their sheet to the web in > “File > Publish to web”, and then downloading the csv document from the > publishing url that ends in “pub?output=csv”. Since about 2020-11-17 19:30 > UTC, we started to see downloads for these documents fail. The ?output=csv > urls started serving a login page, rather than the csv document itself. It > appears that the html version of the sheet is still accessible, but the csv > version is not. > > Here is an example I prepared: > > > - I created a test sheet, published as shown in the screenshot below. > Access is not restricted. > - The html version at > > https://docs.google.com/spreadsheets/d/e/2PACX-1vQqRF-oue4q22BS0vWc8UcV4zEmTfQBmkQupH6K39gWrx6uNTmqclkBofMtNCz8Jw95R1Csdt3Byx0T/pubhtml > > is accessible > - The csv version at > > https://docs.google.com/spreadsheets/d/e/2PACX-1vQqRF-oue4q22BS0vWc8UcV4zEmTfQBmkQupH6K39gWrx6uNTmqclkBofMtNCz8Jw95R1Csdt3Byx0T/pub?output=csv > > shows a login page > > The login page shows when accessed without being signed in to Google, for > example when I open the ?output=csv url in a new private tab, or download > it with Curl. When I open it in a browser where I am signed in to Google, > it does serve the csv. > > [image: document-published-not-restricted.png] > > > As the html version is publicly accessible without being signed in, > requiring login for the csv version does not appear to provide extra > protection. The setting of the “Web page” versus “Comma separated values” > in the publish settings do not make a difference, the csv version remains > inaccessible. > > > Was there a change in how published sheets are handled recently, and is > requiring login for csv documents intentional? > > Kind regards, > > > Ruud van Asseldonk > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/38c82ad7-10c1-425e-9f1f-ce64fefe79ffn%40googlegroups.com.
