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

States By Country - https://stratava.io/api/b073da4e

100 Organizations - https://stratava.io/api/ba303cc1 (fake data)

1000 Leads - 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%20State...

Return all states where country contains the word United https://stratava.io/api/b073da4e?country_name_like=United

Return all organizations founded after 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!