Hi all, I'm pretty new to the integration of Chart and have been struggling
to get my chart use an existing, publicly available Google sheet, as
datasource. I've followed the instruction
on https://developers.google.com/chart/interactive/docs/spreadsheets and my
code looks like this
// Load the Visualization API and the corechart package.
google.charts.load('current', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.charts.setOnLoadCallback(drawGID);
function drawGID() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/gviz/tq?sheet=Sheet1&headers=1&tq=SELECT%20A');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
...
running this, embedded in an html, in the browser gives me a 'timeout'
message after 30 seconds, without further details. When I copy the URL
directy in the browser address bar I get the desired JSON response. Any
help or clarification would be highly appreciated. Regards.
Yves
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/ba0ea42b-708e-4c70-8f2d-20b58f950fcdn%40googlegroups.com.
