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.
