Help

Re: Automated CSV export via API?

2618 0
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
Robert_Granhol1
5 - Automation Enthusiast
5 - Automation Enthusiast

I’d also like the script!

PageMonk
6 - Interface Innovator
6 - Interface Innovator

I built a desktop app that lets you export your Airtable data to CSV files. It also converts Linked records to corresponding Primary field values.

Its at https://www.pagemonk.com/export . Hope it helps somebody !!

Steven_Zhang
6 - Interface Innovator
6 - Interface Innovator

Following up on my original post 3 years later… A friend mine made a webapp to do automatic regular cab backups. They’re having some login issues with the community account, so posting on their behalf:

Created https://backuptable.com after trying and failing to find a means of regularly backing up my bases on airtable. BackupTable doesn’t try to do anything more or less than what the name implies - it backs up everything you have on airtable (plus attachments) and can do so either manually or automatically. Dropbox sync coming soon.

Hope people find it useful and would love to hear feedback :slightly_smiling_face:

Hi Tuur–

I’m looking for the same thing.

Thanks for sharing!

Melvin_Bagasol
4 - Data Explorer
4 - Data Explorer

@Tuur I’m very interested in this. Would you mind sharing with me too please?

Abdulrahman_Alz
6 - Interface Innovator
6 - Interface Innovator

We made a tool exactly for this!

Aditya_Putra
4 - Data Explorer
4 - Data Explorer

Hello, I was facing similar problem lately, and decided to create a python package just for this.


You could programmatically download csv from any shared view. While you can download csv without API key, sadly you have to create a shared view link for this to work
image

Hi @Tuur @Steven_Zhang, can you share the script via PM please?

Kimberly_Hirsch
4 - Data Explorer
4 - Data Explorer

@Tuur could you share the script with me as well via PM?

I’m getting an HTTP 404 on the link; site loads fine.

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