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]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
