Spreadsheets query gets 409 response (Conflict)

[Colin M]

Any idea why a Google Spreadsheet query would occasionally return a
409 response code ("Conflict")? The API is read-only so this makes no
sense to me.. My query is using aggregation and returning a CSV format
and it happens maybe once a day. The spreadsheet is for the most part
append-only but there are possibly a few users viewing or editing the
spreadsheet simultaneous to the query.

Thanks,
Colin

[Badtnik]

Hey Colin,

Can you send an example query URL please?

thanks

  badtnik

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[Colin M]

Query:
select E, count(A) where N != 'cancelled' and (E = 845) and D = 1656
group by E

URL:
https://spreadsheets.google.com:443/tq?key=XXX&gid=0&tqx=out:csv&tq=select%20E%2C%20count%28A%29%20where%20N%20%21%3D%20%27cancelled%27%20and%20%28E%20%3D%20845%29%20and%20D%20%3D%201656%20group%20by%20E

Also a user reported doing frequent re-sorting of the sheet, not sure
if it is related. I occasionally get timeouts too (10 seconds). Would
increasing the timeout wait decrease the chances of timeouts? The
queries complete in under a second when there are no errors.

Thanks,
Colin

On Jul 28, 12:40 pm, Badtnik <badt...@google.com> wrote:
> Hey Colin,
> Can you send an example query URL please?
>
> thanks
>   badtnik
>
>
>
> On Wed, Jul 28, 2010 at 5:55 PM, Colin M <cm5...@gmail.com> wrote:
> > Any idea why a Google Spreadsheet query would occasionally return a
> > 409 response code ("Conflict")? The API is read-only so this makes no
> > sense to me.. My query is using aggregation and returning a CSV format
> > and it happens maybe once a day. The spreadsheet is for the most part
> > append-only but there are possibly a few users viewing or editing the
> > spreadsheet simultaneous to the query.
>
> > Thanks,
> > Colin
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google Visualization API" group.
> > To post to this group, send email to
> > google-visua...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > google-visualizati...@googlegroups.com<google-visualization- api%2Bunsu...@googlegroups.com>
> > .

[ChartMan]

The :443 port (which is added in IE) is supposed to be removed internally before the query is sent. Are you getting the query url from firebug?

To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.