On exploration, it looks like the URL structure I'm using works. But
something is preventing it from loading at Wordpress. Do you know which
(common) plugins might be blocking the retrieval of data from the Google
Sheets server?
On Wednesday, April 10, 2024 at 7:10:39 PM UTC-4 Laurie Bennett wrote:
I'm using Google Charts to create pie charts on my Wordpress site. These
charts display if I hard-code the data, but I'm trying to use a query of a
public Google Sheet. It's not working, and the problem appears to be in
this section.
// Callback to draw the chart
function drawChart() {
var query = new google.visualization.Query("[Google Sheet
URL]/gviz/tq?tq=[ENCODED QUERY]");
query.send(handleQueryResponse);
}
Bracketed info is replaced by the real values (minus the brackets). The
query has been encoded using the tool on this page:
https://developers.google.com/chart/interactive/docs/querylanguage.
I use double quotes around the URL because the query contains a where
clause with single quotes.
Any thoughts why this isn't working?
--
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/2b957285-aef9-453f-a197-3a9b63fd696en%40googlegroups.com.
