4 ms·

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.

• jhgg 12y ago
  You should be able to achieve that with this tool paired with postgres foreign data wrappers!
  • curiously 12y ago
    do you have more information on this? or do open source solutions already exist that convert spreadsheet into API?
    • jhgg 12y ago
      I'd start here: http://www.postgresql.org/docs/9.2/static/file-fdw.htm http://www.postgresql.org/docs/9.2/static/file-fdw.htm
• bthomas 12y ago
  Something like this that that could operate efficiently on 100M+ rows would be hugely valuable in biology
• BjoernKW 12y ago
  Not quite there yet (no hierarchical structure etc.) but I think sheetlabs seems like what you're looking for: https://sheetlabs.com https://sheetlabs.com
• kennywinker 12y ago
  Two suggestions for csv -> api: 1. Parse: http://blog.parse.com/2012/05/22/import-your-csv-data-to-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 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.