I was able to get things working again using this, unmodified: https://code.google.com/p/google-apps-script-issues/issues/detail?id=5102#c16
Note that requires a local browser to perform the OAuth2 dance. There's some information in the thread on how to do it remotely, but it still requires a human to do the initial auth. On Friday, May 29, 2015 at 4:51:47 PM UTC-4, Jason Antman wrote: > > 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.
