Nov 07, 2018 01:52 PM
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.
Nov 07, 2018 09:29 PM
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.
Mar 26, 2020 01:25 PM
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.
Oct 22, 2021 06:02 AM
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>
Nov 16, 2021 12:47 AM
Version 2 is just as easy and more secure :slightly_smiling_face: - check it out!