On: Show HN: Turn a Google Spreadsheet into an API

[nbevans]

API doesn't look very REST to me. It is basically just using HTTP as a JSON transport. The JSON contains a "status" code which appears to loosely follow the HTTP status code numbering. But if that was the intent then why not just use HTTP status codes like a true REST endpoint?

Otherwise, a neat idea. Needs a Office 365 connector too.

[michaeloblak → nbevans]

It's an MVP right now. Yep, will introduce those fixes this week! Thanks for kind words.

[arethuza → michaeloblak]

Microsoft (specifically Power BI) is pretty keen on consuming OData so exposing a Google spreadsheet as OData might be interesting.

[cdcarter → arethuza]

Salesforce loves to consume OData too. I'd be very interested in a sheet->OData connector.

[avereveard → nbevans]

true REST != JSON :D

yes json it's convenient. no json isn't stateful, unless you transmit operations and allow API discovery, not just data.