我正在尝试从 cron 中读取文档:
https://sheets.googleapis.com/v4/spreadsheets/<sheet_id>?key=<api_key>
知道链接的任何人都可以使用我的文档。
My #1 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - I added my external IP address.
- API restrictions - none
My #2 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - I added my external IP address.
- API restrictions - Google Sheets API
My #3 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - I added my external IP address.
- API restrictions - Google Sheets API, Google Drive API
My #4 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - none
- API restrictions - Google Sheets API
My #5 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - none
- API restrictions - Google Sheets API, Google Drive API
My #6 key settings:
Application restrictions:
- IP addresses (web servers, cron jobs, etc.) - none
- API restrictions - none
当我尝试使用每个键打开文档时,出现 403 错误:
{
"error": {
"code": 403,
"message": "The caller does not have permission",
"status": "PERMISSION_DENIED"
}
}
使用 API Explorer 时也会出现同样的错误(https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get).
同时,文档本身可以从任何计算机和任何浏览器的链接成功打开,甚至对未经授权的用户也是如此。
此问题于 7 月 9 日晚上 09:35 (UTC+0) 开始。
在此错误之前,我使用以下命令成功接收了文档中的数据#1 key settings
.
Update:
我发现了另一个奇怪的细微差别:在所有其他文档上都没有这样的问题。在一份特定文档上发现错误。我将访问设置与其他设置进行了比较 - 它们是相同的。
更新2:
我尝试复制该表并通过 API 打开它 - 错误是相同的。
一个小时后我再次尝试——一切都成功了。