Hello IH,
Is there a reliable CSV to API solution that you use ?
It should be able to:
- upload CSV file (manual/automatic - schedule from URL)
- use REST API to fetch the data from the imported CSV
- use REST API to find terms in the columns of the CSV
Best
Check out https://www.dropbase.io/!
Thanks, I'll give it a try
this is the correct answer lol. came here to say this @alexmano!
I tried to sign up but doesn't accept my email address. Too bad, this seemed really interesting.
Hi, so I don't currently offer automatic uploading on my solution www.apispreadsheets.com, but I do offer manual uploading CSV and converting to a REST API.
Let me know if you have any questions
PostgREST has bulk insert from CSV.
Not exactly, what you're saying, but companies might be interested in simplifying distributed CSV processing.
Like imagine a CSV file with 2,000,000 rows that you want to process across N machines.
Imagine there was an API that did all of the cleaning like dropbase.io with a nice interface, but instead of needing to write code to pull blocks of it down, you send an API POST rest/graphql request (or a kafka or SQS event) with N-rows that the machines can process on their own.
Hi Alex- we're building out that functionality at https://phiona.com, where you can upload CSV files, transform/clean them, and host them as an API.
We're shortly releasing a huge update that should make it easier for you to import these files on a schedule from Dropbox or elsewhere.
We're in free beta right now, feel free to give it a whirl and happy to answer any questions you may have.
Thanks Steve, will give it a try
I work with Oracle Integration Cloud, a no-code visual XSLT based integration tool. It's probably more geared toward enterprise integrations, I wish Oracle had a lower price for indie developers. But it's a great tool to do integrations and build API of all kinds, including loading CSV files and parsing them and doing anything you want with the data. Has a batch scheduler too.
Hi Alex. I am intrigued: in what specific instance would you need a CSV to API feature?
I am currently building a project based on csv data. I just converted to JSON and uploaded to firebase. Works really well.
Maybe https://flatfile.io/ has something like this?
thanks @lukvo. It looks a little complicated but doable for upload csv on schedule, but I don't see on this solution the 'find' functionality, atomically described for a row or record. If we think serverless, this solution is probably half of the process...
Haven't used one that exists but built a simple csv uploader that converts it to JSON and make it accessible via API. Curious to know what similar solution exists, otherwise it can be a nice weekend project for me.
hi @sagunsh, I'm actually looking at a solution that can provide the scenario described in the initial post with fairly fast setup. So far I have tried Airtable, Google Sheets, but to be honest no one is straight forward to use in regards to upload CSV based on a schedule from URL and provide a fast API for a serverless app. Converting to JSON large CSV files is not an option
Isn't the solution you want is to have an interface to uplaod a CSV file and access the data via an API endpoint?
That's partially correct, the idea is to have also the possibility to schedule the upload/update of the CSV from a URL (location of the CSV). Therefore the CSV data / REST API will be up to date (synchronized, master is CSV).
Oh got it more like a google sheet which when updated will update the data in api too