Thanks Eric. What are there plans to support getting data from a Spreadsheet that is only "Published to Web"?
On Wednesday, June 29, 2016 at 9:20:18 AM UTC-5, Eric Koleda wrote: > > Unlike the v3 API, the v4 API doesn't use the published setting to > determine access. Instead, it uses the sharing settings, and you need to > share the spreadsheet to "Anyone with the link". > > - Eric > > On Tuesday, June 28, 2016 at 3:44:26 PM UTC-6, Alan Clayton wrote: >> >> Yep. Sheets API is enabled. >> >> On Tuesday, June 28, 2016 at 4:11:17 PM UTC-5, [email protected] wrote: >>> >>> Have you enabled the new API in the developer console? >>> >>> On Tuesday, June 28, 2016 at 8:29:04 AM UTC-7, Alan Clayton wrote: >>>> >>>> Using v3 Sheets API we can get cell data when a Spreadsheet is >>>> "Published to Web". >>>> >>>> Example v3 api URL: >>>> >>>> >>>> https://spreadsheets.google.com/feeds/cells/1Kt6OrUCZJC0rw8K5QgqiuqrIqDW_VEJm1MxdxXY7twQ/1/public/full >>>> >>>> >>>> Using v4 Sheets API to get data from the same Spreadsheet that is >>>> "Published to Web" returns >>>> >>>> { >>>> "error": { >>>> "code": 403, >>>> "message": "The caller does not have permission", >>>> "status": "PERMISSION_DENIED" >>>> } >>>> } >>>> >>>> >>>> >>>> >>>> Example v4 api URL (less API Key) >>>> >>>> >>>> https://sheets.googleapis.com/v4/spreadsheets/1Kt6OrUCZJC0rw8K5QgqiuqrIqDW_VEJm1MxdxXY7twQ/values/Sheet1?key=<YOUR-KEY-HERE> >>>> >>>> >>>> >>>> -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
