That is where we got started to create the server side method of
creating a JSON based response. I would like to know if my approach is
correct or not. Since when I make a call to create query from my code
shown above.
dataQuery = new google.visualization.Query('http://
spreadsheets.google.com/tq?
key=0Atdrr8g9_zEudEFZQnpDLUVjNzlCa0FqbWlUdGNhYkE');
And when I access the URL directly
http://spreadsheets.google.com/tq?key=0Atdrr8g9_zEudEFZQnpDLUVjNzlCa0FqbWlUdGNhYkE
the response that I get is
google.visualization.Query.setResponse({"version":"0.6","status":"ok","sig":"1894160066","table":
{"cols":[{"id":"A","label":"Key","type":"string","pattern":""},
{"id":"B","label":"LCOE(Real)","type":"number","pattern":"#0.###############"},
{"id":"C","label":"LCOE(Nominal)","type":"number","pattern":"#0.###############"},
{"id":"D","label":"Enet","type":"number","pattern":"#0.###############"},
{"id":"E","label":"RequestDateTime","type":"datetime","pattern":"M/d/
yyyy H:mm:ss"},
{"id":"F","label":"RunDateTime","type":"datetime","pattern":"M/d/yyyy
H:mm:ss"}],"rows":[{"c":[{"v":"SunEdison|1Q2011"},{"v":
13.4657269942,"f":"13.4657269942"},{"v":
16.2351677257,"f":"16.2351677257"},{"v":
2.30067734004E7,"f":"23006773.4004"},{"v":new
Date(2011,11,22,10,1,24),"f":"12/22/2011 10:01:24"},{"v":new
Date(2011,11,22,10,1,24),"f":"12/22/2011 10:01:24"}]},{"c":
[{"v":"SunEdison|2Q2011"},{"v":13.4657269942,"f":"13.4657269942"},{"v":
16.2351677257,"f":"16.2351677257"},{"v":
2.30067734004E7,"f":"23006773.4004"},{"v":new
Date(2011,11,22,10,1,25),"f":"12/22/2011 10:01:25"},{"v":new
Date(2011,11,22,10,1,24),"f":"12/22/2011 10:01:24"}]}]}});
Hence we thought of sending the string to generate the query.
But when sending the string directly to the Query constructor, the
request is timing out.
Any thoughts?
On Dec 27, 12:55 pm, asgallant <[email protected]> wrote:
> Sorry, that's a bit out of my realm (I use jQuery for all of my AJAX, so I
> never had to deal with implementing the query API server-side).
>
> I read a bit on the subject and it looks like I don't know what the hell I
> was talking about. Your initial response was probably closer to what is
> required, at least according to what I skimmed
> here:http://code.google.com/apis/chart/interactive/docs/dev/implementing_d...
>
> They have a python library for handling queries linked there.
--
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.
