The second URL has a range parameter that contains only columns and not cells (A instead of A1). Could it be that this is the problem?
As for your question if the range parameter is necessary, I didn't understand the question. Can you give an example query? On Mon, Oct 11, 2010 at 11:25 PM, Traub, Adam <[email protected]> wrote: > Actually, it seems I lied; I’m still getting the timeout issue…here’s the > new URL I’m using: > > > > > https://spreadsheets.google.com/tq?key=KEYHERE&hl=en&sheet=stats&authkey=AUTHHERE&range=A1:J8 > > > > BUT, this one works: > > > > > https://spreadsheets.google.com/tq?key=KEYHERE&hl=en&sheet=headcounts&authkey=AUTHHERE&range=A:J > > > > So, yes…still getting one sheet working and another not. > > > > Any ideas? > > > > > > Adam Traub | Systems Librarian | St. John Fisher College | > [email protected] | (585)385-8382 > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Jinji > *Sent:* Friday, October 08, 2010 5:42 PM > *To:* [email protected] > *Subject:* Re: [visualization-api] Re: Query Request Timing Out > > > > In general, queries to Google spreadsheets to get a Google Visualization > DataTable should be to a URL that look like this: > > > > http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&range=B1:D11 > > > > (see the > playground<http://code.google.com/apis/ajax/playground/?type=visualization#data_source_request>for > an example) with a possible sheet parameter. > > So the URLs you initially posted don't qualify (they have "ccc" instead of > "tq"). The new URL seems OK at first look. Do you still get good result for > one sheet and timeout for the other sheet of the same spreadsheet, with the > second URL? > > On Tue, Oct 5, 2010 at 9:56 PM, Adam Traub <[email protected]> wrote: > > You may have seen my response that I assumed that the #N/A values were > causing my request to timeout, but apparently this isn't true. > > I've handled those cells with an IFERROR(), setting those to 0. > Unfortunately, the requests still timeout and I can't even get a > gadget to display the data, which had a slightly different URL than > those I posted earlier (https://spreadsheets0.google.com/tq? > range=A1:J8&key=KEYGOESHERE&gid=2). > > Any ideas? > > Thanks! > > > On Oct 5, 2:37 pm, Adam Traub <[email protected]> wrote: > > Hi All, > > > > I've having some issues querying the various sheets in my spreadsheet. > > > > Using a simple query and calling: > > > > var query = new google.visualization.Query( > > 'https://spreadsheets.google.com/ccc? > > key=KEYGOESHERE&hl=en&sheet=headcount&authkey=AUTHGOESHERE'); > > query.setQuery('SELECT C,D,E'); > > > > Works fine, but using the same query for the sheet in the same > > spreadsheet called "Stats:" > > > > var query = new google.visualization.Query( > > 'https://spreadsheets.google.com/ccc? > > key=KEYGOESHERE&hl=en&sheet=stats&authkey=AUTHGOESHERE'); > > query.setQuery('SELECT C,D,E'); > > > > Returns a "Request Timed Out" error. Any ideas? > > > > Thanks, > > Adam > > -- > 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]<google-visualization-api%[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]<google-visualization-api%[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]<google-visualization-api%[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.
