Re:Automatic REST API for Any Postgres Database
by curiously on Saturday January 03, 2015 @05:13PM
(#8832214)
What I really want is actually a way to turn a xlsx or a csv file into a REST API. For example if there's a subcategory column, I want it to be hierarchial.
[ Parent
| on HN ]
Re:Automatic REST API for Any Postgres Database
by kennywinker on Saturday January 03, 2015 @10:47PM
(#8833198)
Two suggestions for csv -> api:
1. Parse: http://blog.parse.com/2012/05/22/import-your-csv-data-to-par...
2. csv to api https://github.com/project-open-data/csv-to-api
Though if your data really is as simple as a single table (a csv files tend to be), you could probably put together a sinatra or express app in a day or two depending on your skill level.
Re:Automatic REST API for Any Postgres Database
by jhgg on Saturday January 03, 2015 @05:25PM
(#8832282)
You should be able to achieve that with this tool paired with postgres foreign data wrappers!
Re:Automatic REST API for Any Postgres Database
by curiously on Saturday January 03, 2015 @05:37PM
(#8832331)
do you have more information on this?
or do open source solutions already exist that convert spreadsheet into API?
Re:Automatic REST API for Any Postgres Database
by jhgg on Saturday January 03, 2015 @06:49PM
(#8832530)
I'd start here:
Re:Automatic REST API for Any Postgres Database
by BjoernKW on Saturday January 03, 2015 @06:36PM
(#8832494)
Not quite there yet (no hierarchical structure etc.) but I think sheetlabs seems like what you're looking for: https://sheetlabs.com