Copasetic Flow

One of the first things I always find myself doing when writing an application using the Google Visualization API Query Language is writing a simple application framework to test out my data models and queries. Rather than re-inventing the wheel on every project, I decided to just implement a simple tester here where, hopefully, everyone else can benefit from it as well. To use it, simply place the datasource URL you intend to use as well as the query string in the appropriate blanks below. Then click, 'Test Query' to see the results of the query. For example, you can try the datasource URL and a query string from the Hierarchical Chooser post. datasource URL: http://spreadsheets.google.com/pub?key=pvFXGB-79Kl2d6jU-_m44ZQ&gid=0&pub=1 Query String: Select A, B, C Datasource URL Query String

Updated March 26, 2008 12:37 PM CMT I'm coming up to speed on the new Google Visualization APIs this week like a lot of other people. As I'm working through my new application that uses this API and Google Docs spreadsheets, I'm running into some issues that aren't covered in the online documentation for the API . I'll post those issues along with their resolution here, so if you run into problems, this is a good place to look. If you run into problems that aren't covered, please add them to the comments section. Of course, the first place to look if you run into issues is on the Google Visualization API Group . Column labels don't work like you might think they should Throughout the Query Language Reference the examples use the labels from the following table: name string dept string lunchTime timeofday salary number hireDate date age number isSenior boolean seniorityStartTime datetime John Eng 12:00:00 1000 2005-03-19 35 true 2007-12-02 15:56:...