Skip Menu |

This queue is for tickets about the Net-Google-Spreadsheets CPAN distribution.

Report information
The Basics
Id: 48726
Status: resolved
Priority: 0/
Queue: Net-Google-Spreadsheets

People
Owner: Nobody in particular
Requestors: darin.london [...] duke.edu
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 0.04
Fixed in: (no value)



Subject: Can no longer access spreadsheets
I have written some scripts which programmatically access a google spreadsheet using the ClientLogin access mode (e.g. I pass in a google mail, and password) in Net::Google::Spreadsheets. These have worked flawlessly up until this morning (and are really cool, I might add). Today, I find that the Net::Google::AuthSub portion of the system seems to be working, e.g. I get a valid Authorization => 'GoogleLogin auth=.....' response from it. But when the Net::Google::Spreadsheets::UserAgent::feed method tries to get an atom feed using the token, it seems to get redirected a couple of times, and finally receives a response consisting of the google login page instead of the atom feed for my spreadsheet. This causes XML:Atom::Feed to throw an exception, for obvious reasons. I am wondering if Google has changed access due to the recent twitter break in? Anyway, just on a hunch I downloaded the 'official' python library, and ran a test script to just do a listing of my spreadsheets, and it still works, so there is something subtly different in the way the python library is accessing the site, and the way Net::Google::Spreadsheets is accessing the site. I tried running my test python script through the debugger to see if I could spot anything obvious, but I could not spot anything. I am not very proficient in python. I have tried accessing from two different servers, both using Net::Google::Spreadsheets version 0.04, and perl v 5.8.8: Linux 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Linux 2.6.18-128.1.10.el5PAE #1 SMP Thu May 7 11:14:31 EDT 2009 i686 i686 i386 GNU/Linux I am sorry that I could not be more specific of the problem.
as of 22:37 tonight, my scripts are working again. it must have been a transient condition, although it might be good to investigate why the python library was unaffected.
Thank you for the report. I added better error handlings at 0.06_01. It doesn't show ugly xml parse error message any more if authsub error happens and your request is redirected to the login page. And, it supports spreadsheets api v3.0. please try it! --nd