Help

API call for CSV file

Topic Labels: ImportingExporting
3513 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Prashant_Panth
4 - Data Explorer
4 - Data Explorer

I’m new to Airtable. I’m trying to fetch data from the CSV file and populate a content box.

Trying to fetch data doing AJAX call. In google spreadsheet it’s pretty simple.
var URL = spreadsheetsgooglecomfeedslist"+Yourkey+"defaultpublicvalues?alt=json
url:URL
method:“GET”,
crossdomain:true,
success:function(data){
var eventsData = data.feed.entry;

My question is how can you get the URL for the CSV file you created in airtable.

4 Replies 4
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

You can not programmatically get the URL for the CSV file directly.

But you can access the data in your base via the Airtable API.
The Airtable API is REST based so you should be able to use it in almost any programming language out there.

Moe
10 - Mercury
10 - Mercury

Since this feature is not supported yet, we created a tool that generates a static URL for CSV file. It can also be scheduled to re-fetch the data automatically.

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

We have made a simple api for exporting your base as csv. The docs can be found here

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

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

Version 2 is just as easy and more secure :slightly_smiling_face: - check it out!