'Missing resource version ID' on UpdateCell (gdata.spreadsheet.service) with new spreadsheets

[GoogleCodeExporter]

What steps will reproduce the problem?
>>> import gdata
>>> import gdata.spreadsheet.service
>>> c = gdata.spreadsheet.service.SpreadsheetsService()
>>> c.email = '*****@gmail.com'
>>> c.password = '*****'
>>> c.source = 'Test gdata'
>>> c.ProgrammaticLogin()

What is the expected output? 
working with old-style spreadsheet:
>>> c.UpdateCell(row=1, col=1, inputValue='77', 
key='********************************************', wksht_id='od6')
<gdata.spreadsheet.SpreadsheetsCell object at 0xb6e245ec>
>>>

What do you see instead?
>>> c.UpdateCell(row=1, col=1, inputValue='77', 
key='************_*********************-*********', wksht_id='od6')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/gdata/spreadsheet/service.py", line 278, in UpdateCell
    converter=gdata.spreadsheet.SpreadsheetsCellFromString)
  File "/usr/local/lib/python2.7/dist-packages/gdata/service.py", line 1395, in Put
    media_source=media_source, converter=converter)
  File "/usr/local/lib/python2.7/dist-packages/gdata/service.py", line 1358, in PostOrPut
    'reason': server_response.reason, 'body': result_body}
gdata.service.RequestError: {'status': 400, 'body': 'Missing resource version 
ID', 'reason': 'Bad Request'}

What version of the product are you using?
gdata 2.0.18, python 2.7.4

Please provide any additional information below.

Original issue reported on code.google.com by bramma...@gmail.com on 16 Mar 2014 at 1:37

[GoogleCodeExporter]

I'm seeing this affect all update calls to the new spreadsheets. I've tried 
updating a row, an individual cell and a bulk update of cells.

Has anyone had success performing any update operations on data in the new 
spreadsheets?

Original comment by zumb...@gmail.com on 17 Apr 2014 at 4:01

[GoogleCodeExporter]

Nope, I have the same issu, and because that I use old good sheets :D..

Original comment by russia...@gmail.com on 17 Apr 2014 at 4:04

[GoogleCodeExporter]

ok - yeah, I have an add on that is only supported on the new Google Sheets. On 
the server side I need to log in and update the sheet :(.

Original comment by zumb...@gmail.com on 17 Apr 2014 at 4:07

[GoogleCodeExporter]

Hi all,

 We had the same issue. I recently cloned the repo and added an optional 'force' parameter to Update and Batch requests so the client will work with the new Google Sheets. We are using this version of the client in our staging environment without issue.

Please consider it beta quality.  Pull requests and comments are welcome.

https://code.google.com/r/ed-new-google-sheets-support/

Cheers,

Ed

Original comment by e...@hiplead.com on 17 Apr 2014 at 5:19

[GoogleCodeExporter]

in otherwords, add extra_headers={'If-Match': '*'} to every fucking one of your 
http reqeusts.

Original comment by electron...@gmail.com on 8 May 2014 at 8:12

[GoogleCodeExporter]

Here's some code I used to monkey-patch the library - I don't like updating 
upstream libraries, I'd rather wait for an official version through my distro.  
Simplifies code management.  Maybe this helps the next person.

Original comment by jul...@parentmap.com on 13 May 2014 at 4:45

Attachments:

• hotpatch.py