I have been really into making App Engine sites lately and one of the developer itches I have had for a while was being able to just grab a valid OAuth2 token for Google Data APIs so I can use it in plugins like Rest Client or just on the URL bar in order to preview data. So I wrote a quick site to do it.

https://oauth2helper.appspot.com/

A sample use would be to get an XML feed of all of your Google Docs.

Scopes:

https://docs.google.com/feeds/

https://docs.googleusercontent.com/

https://spreadsheets.google.com/feeds/

URL to hit:

https://docs.google.com/feeds/default/private/full?v=3&access_token=[put your token here]

I used a CSS layout template called YAML to give the site a simple yet more elegant design.

http://www.yaml.de/

Due to a number of requests I have cleaned up and decided to release the code for FT2JSON under the Apache license so others can make use of the software for specific applications.

The code can be found here:

https://github.com/jordoncm/ft2json

The main app engine site will of course always be hosted:

http://ft2json.appspot.com/

I have been messing around with Google Fusion Tables a lot over the past few months and I really like the service. However it really bothered me that the only format that the response data came in was CSV. I also wanted to be able to work with Fusion Tables query data entirely on the browser/client side. So I spent part of the weekend writing an application that proxies Fusion Tables API queries and transforms them from CSV into JSON. I also added a simple Javascript that you can embed on your page and then make Fusion Table queries directly from Javascript.

I posted the application on App Engine and you can find it here: http://ft2json.appspot.com

I wrote it in Python and used Tornado Web Server to help parse requests. Tornado works quite well within App Engine.