Hacker News new | ask | show | jobs
by mooreds 4098 days ago
I beat my head on APIs from Google spreadsheets, so good on ya!

How does blockspring deal with Google Spreadsheet availability issues? I remember the spreadsheet not always being available.

3 comments

Thanks! Yea I was trying to use Google Spreadsheet, getting annoyed with the JSONP and the goofy way they returned their JSON, so figured I'd just wrap it in something easier to use...

What "availability issues" did you run into? I haven't noticed any with my sheets yet

I run a cache in front of mine. It is usually available, but can be slow.
Just the spreadsheet data being intermittently down, and of course, impossible to troubleshoot. We ran processes against it fairly often, and even had it proxied to some mobile devices.
Same here!

We went from using Spreadsheets to using our own flat files on Drive, but the API service would throw random rejection errors for both.

Long story short, we learned that you should not try to use Drive or Google docs as a program database. It's designed first and foremost for users.

I was looking for the google spreadsheets api earlier today and I noticed it has not been migrated away from GData yet. I wonder why this is not getting any love

https://code.google.com/p/gdata-java-client/ <--- Spreadsheets api is one of the three apis still alive out of all gdata apis