Hi,
The section "Setting the Query in the Data Source
URL<http://code.google.com/apis/visualization/documentation/querylanguage.html#Setting_the_Query_in_the_Data_Source_URL>"
describes how a query URL should look like.
However, you will encounter a problem when you'll try to parse the response.
The response that you will get from the data source is aimed for JSONP,
meaning that it is a javascript code, in which a specific method is called,
with a JSON object holding the response. For example:
google.visualization.Query.setResponse({version:'0.6',status:'ok',sig:'430263445',table:{cols:[{id:'A',label:'',type:'string',pattern:''}],rows:[{c:[{v:'Jan'}]},{c:[{v:'Feb'}]},{c:[{v:'Mar'}]},{c:[{v:'Apr'}]},{c:[{v:'May'}]},{c:[{v:'May'}]},{c:[{v:'Jun'}]},{c:[{v:'Jul'}]},{c:[{v:'Aug'}]},{c:[{v:'May'}]},{c:[{v:'Sep'}]},{c:[{v:'Oct'}]},{c:[{v:'Nov'}]},{c:[{v:'Dec'}]}]}});
Our Javascript library can handle this response and give you a DataTable,
but that is... Javascript
For your purpose, you may want to consider Google Spreadsheet API,
specifically, this
part<http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#TableFeeds>.
On Thu, Feb 10, 2011 at 8:43 PM, Mats Svensson <[email protected]>wrote:
> Thanks, but im looking for documentation on the querylanguage thst is
> used in URLs etc.
> Im using php, and that page seems to be for javascript, or is is for
> java?
> Strangely it doesn't even say anywhere what programming language it is
> for...
>
> On Feb 10, 4:27 pm, ChartALot <[email protected]> wrote:
> > Here<
> http://code.google.com/apis/visualization/documentation/reference.htm...>
> > is
> > our documentation on how to issue a query.
> >
> > On Thu, Feb 10, 2011 at 4:39 PM, Mats Svensson <[email protected]
> >wrote:
> >
> > > Is there a better page than this :
> > >http://code.google.com/apis/visualization/documentation/querylanguage.
> ..
> >
> > > ... to look up how to use the query-language.
> >
> > > I always seem to spend an eternity trying to find out how to do the
> > > simplest things, and then end up loading the whole huge sheet into php
> > > or whatever and doing it there instead.
> >
> > > --
> > > 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.
> >
> >
>
> --
> 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.
>
>
--
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.
