Cross posted to Stack Overflow.
I have a tree farm. I have a Google spreadsheet that has my inventory in the form that I took it. I have pivot table that summarizes that sheet. How can I run a query from the Jack Pine description page on my website that pulls the appropriate blob off the pivot table on the spreadsheet? Elsewhere I have successfully exported Here's what I've done so far: 1. Create a new spreadsheet that does an importrange() from the individual sheet with my pivot table. 2. Share to the world "Anyone with link can view" , published to the web. "Entire Document" Using another browser where I am not logged in with my google ID I can see the file, and it is view only. https://docs.google.com/spreadsheets/d/13pXb7Kek010B6s8Ez3h6yX4qF92MgvV4uMk71dJhe3o/edit#gid=0 I'm basing this on this article: https://blog.ouseful.info/2009/05/18/using-google-spreadsheets-as-a-databace-with-the-google-visualisation-api-query-language/ Now, in a query (split line for reading convenience) https://spreadsheets.google.com/d/ 13pXb7Kek010B6s8Ez3h6yX4qF92MgvV4uMk71dJhe3o/tq? tqx=out.html&tq=select+*+where+B+contains+%27Pine,%20Jack%27 And I get the following message: google.visualization.Query.setResponse({ "version":"0.6","status":"error","errors [{"reason":"access_denied","message":"Access denied","detailed_message":"Access denied"}]}); I have attempted embedding the source sheet for the query in a page. That works. Obviously I'm missing something here. How do I troubleshoot this? -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/51f32b7b-29e4-405f-816a-c9544da6df41%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
