I have built out an endpoint for exporting base to CSV. Documentation can be found here
Here is the api.
With the correct parameters it will give the latest version of your base as CSV and will be useful in python scripts etc. Any issues getting it working please check out the docs or reach out.
Additionally, any questions or concerns about how keys or data is handled that are not addressed in the docs - i’ll be happy to answer :slightly_smiling_face:
Thanks for your kind words. Of course. The app is written in Python and utilises Flask and Pandas. The script (when triggered) communicates with the Airtable API. Using the api key, base id, table name and view name passed by the user, it queries the referenced table and handles any pagination. Everything is piped into a pandas dataframe and pandas’
to_csv() method is used to convert the dataframe to csv. The csv is passed back to the caller through the route so nothing is stored.
The api is hosted using google app engine.
Good idea about sharing the code on Github. When I have some time, I’ll clean it up and share it through the docs!
Hi all. This version of CSV Getter is now deprecated. You can easily make a more secure link for exporting CSVs here instead.
Sorry for any inconveniance and I hope you like the new website :slightly_smiling_face: