Skip to main content

API call for CSV file

  • November 7, 2018
  • 4 replies
  • 38 views

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

Forum|alt.badge.img+3
  • Participating Frequently
  • November 8, 2018

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.


Forum|alt.badge.img+15
  • Inspiring
  • March 26, 2020

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
Forum|alt.badge.img+15
  • Inspiring
  • October 22, 2021

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
Forum|alt.badge.img+15
  • Inspiring
  • November 16, 2021

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