Work in Progress: How to Bring Data from Airtable

The best way for us to make use of big chunks of information on the flow is in the form of a JSON Object. Airtable has its own API for that!

Step 1: Get your Airtable URL

Go to "API documentation" on the Help menu of your base
Select your table on the left side Menu
Click on "List Records"
On the "curl" window to the right, you'll see an example request
Copy the URL and the authorization with your API key, you'll need that for later!

To get your API key below the URL, you'll have to check the "Show API key" box on the top right corner of the curl window!

Step 2: Create a Computed Field

Go to the "All" Tab of the Left Sidebar
Scroll down to the Computed Fields section and create a new one
Give it a cool, original name. Something like "airtable_data"
Scroll to the bottom of the Options Tab on the Right Sidebar
Click on "Generate Sample Code", it will generate an empty function:

Step 3: Fetch!

Copy this code inside the function:

function result() {
  let url = "YOUR_URL";
  
  return fetch(url, {
    headers: {'Authorization': 'Bearer YOUR_API_KEY',
    }
  })
    .then((response) => response.json())
    .then(json => {
      // Do something with the data
      return json.records
    }); 
    
}

Paste the URL you copied from Airtable where it says YOUR_URL , and your API key where it says YOUR_API_KEY
Click on "Update" to save the code changes and you should be ready to go!

Your Airtable URL from the example request has its maxRecords set to 3 by default. You can change that to a max of 100. This is what it looks like, you can change the number 3 on the URL: "https://api.airtable.com/v0/apps1073vcOXbLbso/example_base?maxRecords=3&view=Grid%20view"

Security warning

Your Airtable API key is the same for every base on your account, so:

We recommend creating an account that only has access to that base.
Anyone with the account API key could have read/write access to that account bases.
Even if write permission isn't an issue, they still get access to all the data.

In most cases this isn't an issue, but if it is an issue for you, don't worry! We're working on it to make it safer.

PreviousWork in Progress: How to Center Components NextWork in Progress: How to add a custom font from a website:

Last updated 1 year ago

function result() { let url = "YOUR_URL"; return fetch(url, { headers: {'Authorization': 'Bearer YOUR_API_KEY', } }) .then((response) => response.json()) .then(json => { // Do something with the data return json.records }); }