Querying form data of spreadsheets

[Sergei Ledvanov]

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_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.

[asgallant]

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>".

[Sergei Ledvanov]

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 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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
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.
 
 

[asgallant]

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_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/unsubscribe?hl=en.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.