Turn csv into api enpoint
These days i was thinking of a product that converts a csv/xls into an api.
It would not be a file conversion api, but transforming a local csv database into a web-accessible api that returns a structured json
The process could be:
csv -> upload to platform -> field mapping -> api (exposed by the platform)
When the data is imported, an accessible endpoint with the ability to filter is created.
In recent years, the integration through api between products / companies has become a need and often a team does not have the technical skills to expose an api from a csv / xls.
This product would allow in a few steps to create an api starting from the loaded data.
What do you think?
Is there something similar that already exists?
What are the critical points in your opinion?
This comment was deleted 5 years ago
the data will be saved in the platform database after import
I would provide to non-technical people with an easy way to have the data saved in a file consume and be accessible via api.
Google Sheets:
it has stringent limits both on sheets (size, number of cells etc ...) and on api
AirTable:
airtable is an excellent solution, but I see some limits on the csv for example you cannot choose the separator format.
The airtable api allows for unrestricted reading and modification of the record. It does not give the possibility to grant access only for read the record.
There is no possibility to choose the primary key of the table and to be able to access the information faster.