I have had this issue from time to time. Be sure that all the sheets were actually published, and I usually double check to see who has permissions just to make sure that everyone can read without sign-in required.
On Mar 21, 10:26 am, Tobi Harnegg <[email protected]> wrote: > Ok, I have ONE spreadsheet where this is working, but as soon as i > enter another one > "Access Denied" > > working spreadsheet: > 'http://spreadsheets.google.com/tq? > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > nonworking spreadsheet (amongst others) > 'http://spreadsheets.google.com/tq? > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > Logical conclusion would be, it has something to do with the docs > themselves, but > all spreadsheets are completely shared, for reading and editing. > > Or is there some secret essential setting i have to change? > > Very grateful for Advice, > > Tobias > > PS: Even though i am a total noob, i like playing around with this API > > and here is the complete code: > > ------------------------------------------------ > <!-- > copyright (c) 2009 Google inc. > > You are free to copy and use this sample. > License can be found > here:http://code.google.com/apis/ajaxsearch/faq/#license > --> > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="content-type" content="text/html; charset=utf-8"/ > > <title> > Google Visualization API Sample > </title> > <script type="text/javascript" src="http://www.google.com/jsapi";></ > script> > <script type="text/javascript"> > google.load('visualization', '1', {packages: ['table']}); > </script> > <script type="text/javascript"> > > var isFirstTime = true; > var options = {'showRowNumber': false}; > var data; > var queryInput; > > // To see the data that this visualization uses, browse to > var query = new google.visualization.Query( > // 'http://spreadsheets.google.com/tq? > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > 'http://spreadsheets.google.com/tq? > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > function sendAndDraw() { > // Send the query with a callback function. > query.send(handleQueryResponse); > } > > function handleQueryResponse(response) { > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + > response.getDetailedMessage()); > return; > } > data = response.getDataTable(); > var table = new > google.visualization.Table(document.getElementById('querytable')); > table.draw(data, {'showRowNumber': false}); > if (isFirstTime) { > init(); > } > } > > function setQuery(queryString) { > // Query language examples configured with the UI > query.setQuery(queryString); > sendAndDraw(); > queryInput.value = queryString; > } > > google.setOnLoadCallback(sendAndDraw); > > function init() { > isFirstTime = false; > (new > google.visualization.Table(document.getElementById('table'))).draw(data, > options); > queryInput = document.getElementById('display-query'); > } > > function setQueryFromUser() { > setQuery(queryInput.value); > } > > // Apply query language. > query.setQuery('SELECT A,B,D ORDER BY A DESC'); > > </script> > </head> > <body style="font-family: Arial; border: 0 none;"> > <div style="margin-bottom: 10px; padding: 5px; border: 1px solid gray; > background-color: buttonface;"> > <span> Test-Table </span> > > </div> > <table style='width: 100%;'> > <tr> > <td style="width: 50%; padding: 10px; vertical-align: left;"> > <div id="querytable"></div> > </td> > </tr> > </table> > </body> > </html> -- 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.
