2

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"
}
}

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:

Kyle Pennell
  • 5,747
  • 4
  • 52
  • 75
  • Also related: https://stackoverflow.com/q/51261332/9337071 – tehhowch Jul 18 '18 at 20:48
  • For closure, Google has fixed the problem. At least my use of an API key to read data from a spreadsheet shared as "anyone with the link can view" is now working. – Neil Erdwien Jul 19 '18 at 18:16

1 Answers1

2

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 :(

See related question: Cannot access public sheet with Sheets API

gopi
  • 46
  • 3