You need the key for your spreadsheet (open the spreadsheet in google docs, the key is in the URL "https://docs.google.com/spreadsheet/ccc?key=<your key here>#gid=0", in the example given, the key is "pCQbetd-CptGXxxQIG7VFIQ"). Take that key and create a query url in the form "http://spreadsheets.google.com/tq?key=<your key here>".
On Monday, March 18, 2013 3:23:46 PM UTC-4, Sergei Ledvanov wrote: > > Hi, > > I am trying to compose a query that will fetch all the data I have in my > spreadsheet. Something really close to this example > https://code.google.com/apis/ajax/playground/?type=visualization#using_the_query_languageHowever > I cannot figure our what should be the right URL of querying the > form data of my spreadsheet. I would like to query the whole data and then > apply some SELECT <what> WHERE <condition> statements to analyze my data. > The way my data will be displayed is not important. This can be even a raw > JSON. > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
