Help

Automated CSV export via API?

Topic Labels: API
24631 54
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Zhang
6 - Interface Innovator
6 - Interface Innovator
  1. There’s no API call for exporting a table as CSV right? (couldn’t find it in API documentation)

  2. Has anyone written a script that mimic that functionality by iterating through all the records, replacing linked record IDs with names, and then, generating said CSV? If not, I’ll work on writing one…

54 Replies 54

Do you still have something written for this? Hoping to pull the CSVs from a python script.

basavarajeshwar
4 - Data Explorer
4 - Data Explorer

Would like automate download CSV using automation tool. I need API call for this. Can anyone help me to get API to download CSV in Airtable? is this feature available in Airtable?

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

@basavarajeshwari.lax and others - Here is a simple api for csv export. Details can be found here

It will only work with the parameters so any issues check the documentation for assistance or reach out :slightly_smiling_face:

https://csv-getter-for-airtable.ew.r.appspot.com/all-csv?bid=<your_base_id>&apik=<your_api_key>&tname=<your_table_name>

Feedback welcome!!

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

I’ve created a more secure version that utilises a post request found in this discussion

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

Ok, now I have a more secure, no-code version which is much more easy to use by visiting here