I'm trying to plot data on a website via the Google Visualization API and a Google Spreadsheet as the datasource. Using google.visualization.Query() and the instructions provided at https://developers.google.com/chart/interactive/docs/spreadsheets initially everything works perfectly. After I close the Google Spreadsheet however, about 10-30 minutes later (haven't been able to determine the exact amount of time) the chart on the website is drawn with data from a previous version of the Google Spreadsheet and not the latest save. If I reopen the Spreadsheet, refresh the webpage, the chart is redrawn with the latest data. Close the Spreadsheet, wait 10-30 minutes, refresh the webpage, and it again reverts to an old version of the Google Spreadsheet.
The only conclusion I can draw at this point is it may be some issue with the way Google caches spreadsheet data when it's not actively being used? I've tried different "fixes" such as a script that updates a lone cell every 10 minutes or inserting =NOW() into a cell and also changing the Recalculation settings to "on change and every minute" but the older data persistently reappears on the chart. Any help is appreciated! -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
