The response from your server should be: google.visualization.Query.setResponse(/* json */);
not handleQueryResponse(/* json */); On Tuesday, April 22, 2014 6:18:30 PM UTC-4, Mark S wrote: > > > 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.
