Hi Vic, I have shared the sheet with you. Thanks
On Dec 8, 2:06 pm, Vic Fryzel <[email protected]> wrote: > Hey Jay, > > I just tried this with my own sheet, and could not reproduce. I am indeed > using the edit link from the entry. > > Can you share your sheet with me (if it doesn't contain any sensitive data,) > and I'll try the query against your sheet? > > Thanks, > -Vic > > > > > > > > On Wed, Dec 8, 2010 at 4:29 PM, Jay2.7 <[email protected]> wrote: > > I am using the protocol directly from python to update spreadsheet > > rows, however I cannot edit any rows because the API will not return a > > proper edit url. > > > The bug can be reproduced with the following, which is the equivalent > > of what the python code is calling. > > > $ curl -H "Authorization: GoogleLogin auth=..." \ > > -H "GData-Version: 3.0" \ > > >https://spreadsheets.google.com/feeds/list/0AlW0JurWvXP2dDhSZ3RIMUs1O... > > > Note that the URL above is for a spreadsheet row, which returns the > > following > > > <?xml version="1.0" encoding="UTF-8"?> > > <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gsx="http:// > > schemas.google.com/spreadsheets/2006/extended" xmlns:gd="http:// > > schemas.google.com/g/2005" gd:etag=""PRlLE0gSVSt7ImA.""> > > <id>https://spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/cokwr</id> > > <updated>2010-12-06T22:36:58.704Z</updated> > > <app:edited xmlns:app="http://www.w3.org/2007/ > > app">2010-12-06T22:36:58.704Z</app:edited> > > <category scheme="http://schemas.google.com/spreadsheets/2006"; > > term="http://schemas.google.com/spreadsheets/2006#list"/> > > <title>Some Title</title> > > <content/> > > <link rel="self" type="application/atom+xml" href="https:// > > spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/private/full/cokwr"/> > > <link rel="edit" type="application/atom+xml" href="https:// > > spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/private/full/cokwr"/> > > <gsx:videoname>Some Title</gsx:videoname> > > <gsx:bookingkey/> > > <gsx:title/> > > <gsx:date/> > > <gsx:speaker/> > > </entry> > > > Notice the edit uri in the <link rel="edit"...> tag does not include a > > version number. As such whenever I attempt to update this row I > > receive the error > > > 400 Bad Request > > Invalid request URI > > > Doing the same request for > >https://spreadsheets.google.com/feeds/list/0...E/od6/private/full/cokwr > > from an authenticated browser (Chrome) however returns > > > <?xml version="1.0" encoding="UTF-8"?> > > <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gsx="http:// > > schemas.google.com/spreadsheets/2006/extended"> > > <id>https://spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/private/full/cokwr</ > > id> > > <updated>2010-12-06T22:36:58.704Z</updated> > > <category scheme="http://schemas.google.com/spreadsheets/2006"; > > term="http://schemas.google.com/spreadsheets/2006#list"/> > > <title type="text">Some Title</title> > > <content type="text"/> > > <link rel="self" type="application/atom+xml" href="https:// > > spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/private/full/cokwr"/> > > <link rel="edit" type="application/atom+xml" href="https:// > > spreadsheets.google.com/feeds/list/ > > 0AlW0JurWvXP2dDhSZ3RIMUs1OGtxOU4zZ2I3ZG9BS0E/od6/private/full/cokwr/ > > 1pmphoo"/> > > <gsx:videoname>Some Title</gsx:videoname> > > <gsx:bookingkey/> > > <gsx:title/> > > <gsx:date/> > > <gsx:speaker/> > > </entry> > > > Notice now the <link rel="edit"...> tag *does* include a version > > number, allowing me to successfully update. > > > I guess the first question should be, is this expected behaviour? The > > auth token is generated by authenticating to > >https://www.google.com/accounts/ClientLogin > > under the service "wise". > > > If this is expected, can someone tell me the proper method. If it is > > not expected I am looking for work arounds. > > > Thanks
