3 ms·
Show HN: Stratava – CSV files to APIs in seconds
I’ve worked on a few projects with vendors that had data but no easy way to share that data with external systems. Typically, the story goes, we have this data in an ERP, CRM, Warehousing system, etc. but need an IT project to expose that data. That might include a developer, networking, security, project managers, all the typical project overhead. People on the business will question this and say “I already get this data daily in a report, how hard can it be?” Projects have died due to the overhead, or take months to happen.
As an easier way to share the data that's already available, I built this tool. Drop a CSV file, get an API.
Right now, the public version supports:
* GET Requests for API
* Uploads are limited to 1MB
* For testing, I’m auto-deleting APIs after 30 days of no use
* It’s assumed the first row is a header
For searching, the APIs support basic query filters - greater than (_gt), less than (_lt), and like (_like).
These are some example API’s I’ve created -
Currency Codes - https://stratava.io/api/18e4ab1c https://stratava.io/api/18e4ab1c
States By Country - https://stratava.io/api/b073da4e https://stratava.io/api/b073da4e
100 Organizations - https://stratava.io/api/ba303cc1 https://stratava.io/api/ba303cc1 (fake data)
1000 Leads - https://stratava.io/api/3b32c331 https://stratava.io/api/3b32c331 (fake data)
To use the search ability -
Return all states where country name = United States
https://stratava.io/api/b073da4e?country_name=United%20States https://stratava.io/api/b073da4e?country_name=United%20State...
Return all states where country contains the word United
https://stratava.io/api/b073da4e?country_name_like=United https://stratava.io/api/b073da4e?country_name_like=United
Return all organizations founded after 2000 -
https://stratava.io/api/ba303cc1?founded_gt=2000 https://stratava.io/api/ba303cc1?founded_gt=2000
Features not public but I’m testing -
* POST / PUT / DELETE For APIs
* Append mode when uploading
* Custom API naming
* Additional Filtering Options
* Token Based Access Control
* Large File Uploads
* Ability to Combine Multiple APIs into One Call (you have a customer API and order API, join and return one dataset)
I’d appreciate any feedback!