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&au thkey=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:D 11 (see the playground <http://code.google.com/apis/ajax/playground/?type=visualization#data_so urce_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] <mailto: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. -- 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.
