Hi The end of the url contains "&pub=1". This directs the query to the "published" version of the spreadsheet, which has some caching for the purposes of high query rate. For the purposes of a presentation (and not for exampling for publishing this chart on the web), you can try to remove the last part and it would probably remove this extra caching.
Hope this helps, Viz Kid On Wed, Apr 25, 2012 at 11:07 PM, Nathan Jones < [email protected]> wrote: > For a presentation I am working on, I would like to display live survey > results from a Google Form. I am using the Google Visualization API and > running the following query as a data source for a Chart: > > > http://spreadsheets.google.com/tq?key=0AtYRGrmtKkx8dGN5cFRsX1E5M0pkcU1BenZubTR3aWc&range=Responses!A3:B5&pub=1 > > The Chart is working perfectly using the data retrieved from the query, > but the data from the query seems to be caching for around 30-60 seconds. > Even though the actual spreadsheet has changed, Google responds with a "not > modified" error. I have discovered that if you use the static image method > of publishing a chart, the results are always live, but I would prefer to > use the Visualization API. > > Is there any way to prevent this caching and retrieve fresh data through > the Visualization API Query? > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-visualization-api/-/FTekScG0zkwJ. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
