使用apikey从Google Sheets API获取403 [英] Getting 403 from Google Sheets API using apikey

查看:199
本文介绍了使用apikey从Google Sheets API获取403的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我一直在使用Google表格作为我的某些应用程序的简单数据后端.基本上,这是客户希望能够轻松更改的20行x 20列.我一直通过这样的电话获取数据:

I've been using Google Sheets as a simple data backend for some apps of mine. Basically these are 20 rows by 20 columns that a client wanted to be able to easily change. I've been getting the data via a call like this:

https://sheets.googleapis.com/v4/spreadsheets/myspreadsheetid/values:batchGet?ranges=dynamicdatafromapi&majorDimension=ROWS&key=myapikeyfromgoogle

突然,这些呼叫无法正常工作.我要

All of a sudden, these calls aren't working right. I'm getting

{
"error": {
"code": 403,
"message": "The caller does not have permission",
"status": "PERMISSION_DENIED"
}
}

即使在Google API浏览器中,我也只看到有关oauth的警告.

Even within google's API explorer I'm seeing warnings about oauth only.

有什么想法吗?我无法使它正常工作.

Any idea what might be up? I can't get this to work.

在询问之前,我先阅读了以下答案:

I read these answers before asking:

  • Google Sheets API V4 403 Error
  • Google Sheet API v4
  • Google Speech API returns 403 PERMISSION_DENIED

推荐答案

在Google方面,这似乎是一个错误.今天很多人都面临这个问题.希望谷歌会尽快清除它.我们的网站因此而关闭:(

This seems to be an error on google's side. Lot of people are facing this issue today. hopefully google will clear it soon. Our site is down because of this :(

请参阅相关问题:无法使用Sheets API访问公共表

这篇关于使用apikey从Google Sheets API获取403的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆