Hello Scott, the structure of the DataTable has not changed. In order to understand the 'c' and 'v' values, you need to understand the structure of the DataTable, which is described here <https://developers.google.com/chart/interactive/docs/reference#dataparam>. If there is something missing from the documentation, or if you are still confused about something, feel free to respond on this list.
The out:html and out:csv are supposed to work, but currently they do not. This is a bug, and will be fixed in the coming weeks. On Mon Jun 16 2014 at 10:43:33 AM, Scott Sherris <scottsher...@gmail.com> wrote: > I'm getting it to work a bit with a dummy spreadsheet here: > > https://docs.google.com/spreadsheets/d/1EbXvQW2IQ3QCoeXj-1tt0Ed_VwULk-YJZ7373MBG8PQ/edit#gid=0 > With this query: > > https://docs.google.com/spreadsheets/d/1EbXvQW2IQ3QCoeXj-1tt0Ed_VwULk-YJZ7373MBG8PQ/gviz/tq?tqx=out:html&gid=0&tq=Select+B,C+where+F%3D%27C%27 > > And these results: > > google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"99345440","table":{"cols":[{"id":"B","label":"","type":"string"},{"id":"C","label":"","type":"string"}],"rows":[{"c":[{"v":"123@jomama"},{"v":"Jome"}]},{"c":[{"v":"cont...@home.com"},{"v":"321 > Contact"}]},{"c":[{"v":"bxr1...@fredex.com"},{"v":"Betty > Rubble"}]},{"c":[{"v":"wxf1...@bedrock.com"},{"v":"Wilma Flintstone"}]}]}}); >> >> > Obviously there have been some changes to the API since I used to have the > option of CSV or html results and now they're coming only in JSON... > mostly. Is there new documentation? Also I don't understand what the "c": > and "v": represent here. > > -- > 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 google-visualization-api+unsubscr...@googlegroups.com. > To post to this group, send email to > google-visualization-api@googlegroups.com. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
