Use a Google Spreadsheet as your JSON backend

Re:Use a Google Spreadsheet as your JSON backend by dragonwriter on Monday November 04, 2013 @06:40PM (#6671996)

Its using it behind an abstraction layer that decouples the substantive work of the rest of the app from the Google Spreadsheet API and storage backend, for the express purpose of limiting the impact of any later need to move to a different backend service. Given that Checkout and Reader -- the Google examples you cite as reasons to be wary of it for a live system -- were terminated with extensive notice, that doesn't seem like it would pose any problem with this approach.

[ Parent | on HN ]

Re:Use a Google Spreadsheet as your JSON backend by surreal on Monday November 04, 2013 @06:51PM (#6672043)

Maybe the comparison wasn't the wisest, valid point.

But I stand by the fact that this seems like hacking an undocumented feature: "Copy the key=... part [...] and put it into this URL: [...]", which means it could easily be modified/removed with no notice period, and is therefore risky in a production system, no?

[ Parent | on HN ]

Re:Use a Google Spreadsheet as your JSON backend by dragonwriter on Monday November 04, 2013 @07:03PM (#6672102)

> But I stand by the fact that this seems like hacking an undocumented feature: "Copy the key=... part [...] and put it into this URL: [...]",

No, the key value for use in the API being the same that is displayed in the browser URL when working with the sheet is a documented feature:

https://developers.google.com/google-apps/spreadsheets/#retr...

[ Parent | on HN ]

Re:Use a Google Spreadsheet as your JSON backend by surreal on Monday November 04, 2013 @07:10PM (#6672130)

I didn't dispute that. The key itself is fine. I'm just worried about using it for JSON retrieval! That part is undocumented as far as I can see, and therefore subject to change without notice

[ Parent | on HN ]

Re:Use a Google Spreadsheet as your JSON backend by dragonwriter on Monday November 04, 2013 @07:34PM (#6672251)

Huh. I thought that the Spreadsheet API was documented as an XML/JSON API, but it looks like only the XML is directly documented so ... poking around a bit more

The alt=json thing is a documented common feature of Google Data APIs, and the current Google Spreadsheets API is the target of the link in the list of Google Data APIs titled "Google Spreadsheets Data API". OTOH, the current v3 Spreadsheets API no longer has "Data" in the name, and there is a note on the Data APIs documentation that some Google Data APIs have been replaced with newer APIs that aren't Google Data APIs.

So, its at best an ambiguously-documented feature.

[ Parent | on HN ]