All geek questions in one place

Did the published Google Sheets URL publish in a different format?

Usually, when I use the Google Sheets API, I get a very predictable URL structure from the Publish Sheet menu option, which I use to extract the table id with the regular expression and use it for other tasks in the Google Sheets API. This has worked for many years and the way Google documentation recommends getting the table id is from the URL.

eg.

https://docs.google.com/spreadsheets/d/{MYSPREADSHEETID}/pubhtml

However, today, when publishing a spreadsheet, now I get the following URL:

 https://docs.google.com/spreadsheets/d/e/2PACX{BUNCH OF RANDOM CHARACTERS}/pubhtml

This breaks my code since a bunch of random characters displayed using 2PAC is not a spreadsheet identifier and does not work with the API.

Does anyone know if this is an undeclared change in the structure of the Google URL or some kind of error?

+5
source share
1 answer

It seems normal again? It may be nice to know if this was a mistake or a compromised change?

0
source

Source: https://habr.com/ru/post/1260132/

More articles:


All Articles