Hi Culley, The problem you are having *might* be related to the change of how queries are made in the last release, such that they are now more secure. Older versions of spreadsheets can't process the queries in the new way, hence the failure, so one solution might be to convert your spreadsheet to a new version (by creating a new spreadsheet, and copying in the contents from the old one). Another solution might be to use an older version of Google Charts.
Hope that helps. On Sat, Mar 20, 2021 at 5:29 AM Culley Harrelson <[email protected]> wrote: > Hi Ray, > > I will read up on oauth! But this is the example from the developer > documentation. The spreadsheet they are working with produces JSON output: > > http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&pub=1 > > and is unrestricted. > > culley > > > On Friday, March 19, 2021 at 5:41:59 PM UTC-7 Ray Thomas wrote: > >> Hi Culley, >> >> I think it's the authorization key causing this. You'll need to read >> https://developers.google.com/chart/interactive/docs/spreadsheets#authorization >> which explains how to obtain your own OAuth credentials. >> >> My own preference is to simply make the spreadsheet readable to anyone >> with the link. The same page explains how to do that and use either the GID >> or the name of the sheet to read the data from it. >> >> I don't use OAuth often. My own feeling is that I'm drawing a public >> chart from a Google sheet and anything I'd prefer to be kept private >> shouldn't be in the same sheet anyway. >> >> Ray >> >> On Friday, March 19, 2021 at 1:23:15 PM UTC-4 [email protected] wrote: >> >>> I am working with the sample code seen here: >>> >>> >>> https://developers.google.com/chart/interactive/docs/reference#chartwrapperobject >>> >>> I have copied the content of the "using setter methods" example and >>> published it here: >>> >>> http://www.k2tog.com/test.html >>> >>> As you can see, the example does not work because of the XSS settings. >>> Is this something I can fix with the server headers? I have also tried it >>> locally and got the same error. >>> >>> culley >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/7d4d0b78-39cd-4d95-a9b6-ab513386ecdan%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/7d4d0b78-39cd-4d95-a9b6-ab513386ecdan%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- • Daniel LaLiberte • SWE • Cambridge MA • [email protected] <[email protected]> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMxRAfrhXGm%2B5n0%3DNPTOgN-jJO0q-VRkSj7p6%3Dr0LogAg%40mail.gmail.com.
