How does the form appear in the spreadsheet? If it occupies some span of rows and columns, you can restrict the query to only those rows and columns by adding a "range" parameter to the URL: " http://spreadsheets.google.com/tq?key=<your key here>&range=A1:C20", but it's probably easier to handle that in the SQL than in the URL, especially if either the rows or the columns are dynamic.
On Monday, March 18, 2013 4:17:22 PM UTC-4, Sergei Ledvanov wrote: > > 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=<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 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/unsubscribe?hl=en > . > To unsubscribe from this group and all its topics, send an email to > [email protected] <javascript:>. > To post to this group, send email to > [email protected]<javascript:> > . > 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.
