Not able to access google spreadsheet from app engine: “Moved Temporarily”?

15 views
Skip to first unread message

Jose Vidal

unread,
Oct 29, 2009, 7:24:49 PM10/29/09
to Google App Engine


As of a couple of days ago I was able to access my google spreadsheets
from an app (in app engine), but today it is broken.

Namely, I could

name= "name of my spreadsheet"
self.client = gdata.spreadsheet.text_db.DatabaseClient()
self.client.GetDatabases(name=name)

and it worked. In fact, that still works when I run with the
dev_appserver

But, if crashes when on the app engine. It says it can't parse the
XML.

I added some prints to the gdata code and found out that it could not
parse it because what it thought was XML was actually just the HTML of
the login page.

What is now happening is that the python gdata library does a
('eleanor' is the spreadsheet name)

GET /feeds/documents/private/full?title=eleanor

and gets back

<HTML>
<HEAD>
<TITLE>Moved Temporarily</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<H1>Moved Temporarily</H1>
The document has moved <A HREF="https://www.google.com/accounts/
ServiceLogin?
service=writely&amp;passive=true&amp;nui=1&amp;continue=http%3A%2F
%2Fdocs.google.com%2Ffeeds%2Fdocuments%2Fprivate%2Ffull%3Ftitle
%3Deleanor&amp;followup=http%3A%2F%2Fdocs.google.com%2Ffeeds
%2Fdocuments%2Fprivate%2Ffull%3Ftitle%3Deleanor">here</A>.
</BODY>
</HTML>

but, the same GET on the when running locally on the dev_appserver.py
returns the proper XML:

<?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/
2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'
xmlns:docs='http://schemas.google.com/docs/2007' xmlns:batch='http://
schemas.google.com/gdata/batch' xmlns:gd='http://schemas.google.com/g/
2005'><id>http://docs.google.com/feeds/documents/private/full</
id><updated>2009-10-29T19:14:07.401Z</updated><category scheme=......

I double checked and, yes, my app is authorized to access google docs.

So, what's up with the "Moved Temporarily". Is that a transient
problem at the googleplex, or is it some authentication problem?

Again, I am doing all the authentication stuff. This was working two
days ago and then Google changed something that broke it, as I have
not changed my code.

Two months ago I use this tutorial

http://code.google.com/appengine/articles/gdata.html#configure

to set up the authentication.

Jose Vidal

unread,
Oct 30, 2009, 8:08:52 AM10/30/09
to Google App Engine
Ok, it is now working. The Google has healed itself.
Reply all
Reply to author
Forward
0 new messages