Build an API from a CSV file in 4 minutes

I've been working on a side project to make it easy to build a data API with just a few keywords. You can add path based security (both on individual path variables and the method (verb) and path itself), and you can publish the whole thing pretty much instantly.

Of course one of the things I thought about was who might need this, which made me think of all that Excel data sitting on people's laptops or OneDrives… the OneDrive thing in particular… we share a lot of data by just sharing a spreadsheet, but sometimes it might be better if we published a proper app with some extra security rules about who can change what.

So… I built a utility that takes a spreadsheet (in the form of a CSV file) and uploads it. It parses the headers and turns them into JSON fields, and it adds basic rules. I store the data in the browser to give you a minute to pick a deployment location, and then turn it all into JSON and post it to the API.

Check out the demo: