I am using the google.visualization.Query class to send a query to our own
Microsoft MVC web site and am getting back an http response which appears
to be correctly formatted when I inspect it with Fiddler or Firebug. The
response handler is being invoked but instead of being passed a
QueryResponse object, it is being passed the JSON object that our MVC web
site is returning. For this reason, attempts to invoke methods such as
response.isError() or response.getDataTable() are producing error messages
like this one: *Object doesn't support property or method 'isError'*
In my client-side code, I am able to get things working by:
replacing:
if (response.isError())
with:
if (resp.status != "ok")
and, similarly, replacing:
var data = resp.getDataTable();
with:
var data = new google.visualization.DataTable(resp.table);
For completeness, here is the relevant client-side code in its entirety:
<script type="text/javascript" src="https://www.google.com/jsapi";></script>
<script type="text/javascript">
google.load("visualization", "1", { packages: ["corechart"] });
google.setOnLoadCallback(initialize);
function initialize() {
var opts = { sendMethod: 'xhr' };
var tqxValue =
encodeURIComponent("reqID:0;out:json;responseHandler:handleQueryResponse");
var tmpUrl = 'http://cisdb.mybayloremr.com/Home/GetData?tqx=' +
tqxValue;
//alert("tmpUrl: " + tmpUrl);
// Replace the data source URL on next line with your data source URL.
var query = new google.visualization.Query(tmpUrl, opts);
// Optional request to return only column C and the sum of column B,
grouped by C members.
//query.setQuery('select C, sum(B) group by C');
// Send the query with a callback function.
query.send(handleQueryResponse);
}
function handleQueryResponse(resp) {
// Called when the query response is returned.
if (resp.status != "ok") {
alert('Error in query: ' + resp.getMessage() + ' ' +
resp.getDetailedMessage());
return;
}
//var data = resp.getDataTable();
var data = new google.visualization.DataTable(resp.table);
var chart = new
google.visualization.BarChart(document.getElementById('chart_div'));
var options = {
title: 'Company Performance'
//hAxis: {title: 'Year', titleTextStyle: {color: 'red'}}
};
chart.draw(data, options);
}
</script>
A Fiddler capture shows that the request looks like this:
GET http://cisdb.mybayloremr.com/Home/GetData?tqx=reqId%3A0 HTTP/1.1
Accept: */*
X-DataSource-Auth: a
Referer: http://cisdb.mybayloremr.com/Home/About
Accept-Language: en-us
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64;
Trident/5.0)
Host: cisdb.mybayloremr.com
Connection: Keep-Alive
A Fiddler capture shows that the response looks like this:
HTTP/1.1 200 OK
Cache-Control: private
Content-Type: application/json; charset=utf-8
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 4.0
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
Date: Tue, 22 Apr 2014 19:23:50 GMT
Content-Length: 405
handleQueryResponse({"version":"0.6","reqId":"0","status":"ok","table":{"cols":[{"id":"Year","label":"Year","type":"string"},{"id":"Sales","label":"Sales","type":"number"},{"id":"Expenses","label":"Expenses","type":"number"}],"rows":[{"c":[{"v":"2004"},{"v":1000},{"v":400}]},{"c":[{"v":"2005"},{"v":1170},{"v":460}]},{"c":[{"v":"2006"},{"v":660},{"v":1120}]},{"c":[{"v":"2007"},{"v":1030},{"v":540}]}]}})
Any help would be greatly appreciated.
Mark S.
--
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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
