I'm having the same exact issue. I hacked some quick print()s into gdata/spreadsheet/__init__.py and found that GDataService.Get() is getting back a 200 response with a blank body for the URI https://spreadsheets.google.com/feeds/spreadsheets/private/full
Jackson seems to have found the issue exactly... https://developers.google.com/gdata/docs/auth/clientlogin states that clientLogin "will be" (was) turned off on April 20, 2015. It's a little troubling to me that (a) they seem to still be returning HTTP 200 responses with empty body instead of something more obvious, and (b) the gdata library fails with this cryptic traceback on an empty response body, instead of something more helpful. There's an issue about this on Google Code ( ) and I just opened one on GitHub requesting something be done to help people identify this issue ( https://github.com/google/gdata-python-client/issues/24 ). The documentation on OAuth with Data seems to be pretty lacking, but there are some samples in the gdata-python-client project ( https://github.com/google/gdata-python-client/tree/master/samples/oauth ) and it appears as though they'll work with Spreadsheets. I'm about to give it a try... -Jason Antman On Thursday, May 28, 2015 at 12:12:28 PM UTC-4, Tony Laidig wrote: > > I have the following code, which has worked for several years: > > spr_client = gdata.spreadsheet.service.SpreadsheetsService() > spr_client.email = email > spr_client.password = password > spr_client.source = 'The Source' > spr_client.ProgrammaticLogin() > > listfeed = spr_client.GetListFeed(spreadsheet_key, wksht_id) > > > As of yesterday, I am seeing the following exception. > > > listfeed = spr_client.GetListFeed(spreadsheet_key, wksht_id) > File > "/usr/local/lib/python2.7/dist-packages/gdata/spreadsheet/service.py", line > 252, in GetListFeed > converter=gdata.spreadsheet.SpreadsheetsListFeedFromString) > File "/usr/local/lib/python2.7/dist-packages/gdata/service.py", line > 1097, in Get > encoding=encoding, converter=converter) > File "/usr/local/lib/python2.7/dist-packages/gdata/service.py", line > 1097, in Get > encoding=encoding, converter=converter) > File "/usr/local/lib/python2.7/dist-packages/gdata/service.py", line > 1074, in Get > return converter(result_body) > File > "/usr/local/lib/python2.7/dist-packages/gdata/spreadsheet/__init__.py", > line 474, in SpreadsheetsListFeedFromString > xml_string) > File "/usr/local/lib/python2.7/dist-packages/atom/__init__.py", line 93, > in optional_warn_function > return f(*args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/atom/__init__.py", line > 127, in CreateClassFromXMLString > tree = ElementTree.fromstring(xml_string) > File "<string>", line 124, in XML > cElementTree.ParseError: mismatched tag: line 921, column 4 > > > There's a mention of some recent deprecations in prior message, but that > mentions GetListFeed as being the current solution. I can't find a > changelog or updated docs to point at what could be going wrong. Cansomeone > point me in the right direction? > > Thanks! > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
