Yep, got it. Looking now, thanks. -Vic
On Wed, Dec 8, 2010 at 5:47 PM, Jay2.7 <[email protected]> wrote: > 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 >
