I am using google.visualization.Query into a google app script linked to a google site. The problem is that the following query var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/xxxxxx/gviz/tq?sheet=yyyy&headers=2'); fails for timeout error BUT ONLY IF the user has not permission to access the speradsheet. This is a problem because the app script is deployed to run with the permission of the owner of the script (that, of course, has all the rights on the spreadsheet) not the permission of the user that is currently running the script (or gadget). In other words the purpose is to access to the file programmatically without sharing the file itself with the users, allowing them to visulize the data through web application only. If I share the spreadsheet with a user, everything works, but the user can access into the spreadsheet using Drive (unwanted). My question are: 1) It is this behaviour a bug, considering the purpose to deploy app script as script owner ? 2) Are there other options to workaround this, other than to write a custom function, access the spreadsheet, return a JSON response and build a google visualization table or chart?
-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/e4915f61-0648-4a90-8f11-e52b2adfb70a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
