" PERMISSION_DENIED"在Google Spreadsheet REST API v4上 [英] "PERMISSION_DENIED" on Google Spreadsheet REST API v4

问题描述

我尝试通过http从Google表格中读取数据。我使用v4 google电子表格api：

  https://sheets.googleapis.com/v4/spreadsheets/1MZJEOzkzy5iJ9HPy2GU-Ky3vdaIzGGDQH8BMt4n3OGI/values / Sheet1！A1：D5 
  

我得到：

  {
错误：{
code：403，
message：该请求无法用客户端项目识别。，
status：PERMISSION_DENIED
} 
} 
  

工作表在线发布，每个人都可以编辑它。它也适用于api v3。

解决方案

您必须在您的URI上追加字符串key = yourAPIkey作为查询。 API密钥是在开发者控制台
中生成的

I try to read data from google sheet via http. I use v4 google spreadsheet api:

https://sheets.googleapis.com/v4/spreadsheets/1MZJEOzkzy5iJ9HPy2GU-Ky3vdaIzGGDQH8BMt4n3OGI/values/Sheet1!A1:D5

I get:

{
  "error": {
    "code": 403,
    "message": "The request cannot be identified with a client project. Please pass a valid API key with the request.",
    "status": "PERMISSION_DENIED"
  }
}

Sheet is published online and everyone can edit it. It works on api v3 too.

解决方案

You have to append the string "key=yourAPIkey" as query on your URI. The API key is generated in the developer's console

这篇关于" PERMISSION_DENIED"在Google Spreadsheet REST API v4上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！