That's clear, thanks. But I was asking how to compose a query url for a form in a spreadsheet. I have a form (tools > edit form) that has columns defind and contains lots of answers of my users. I guess this should be handled in a different way comparing to a regular spreadsheet query. Am I right?
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= <http://spreadsheets.google.com/tq?key=%3cyour%20key%20here%3e> <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_q uery_language However 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 a topic in the Google Groups "Google Visualization API" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/p1JzdO3tC38/unsub scribe?hl=en. To unsubscribe from this group and all its topics, 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. -- 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.
