Update Airtable Records

Updated 1 month ago by Karan

Byteline provides an easy-to-use Airtable - Update Records node to manage Airtable data. A simple and user-friendly interface allows you to configure Airtable updates in minutes.

Configure Airtable API Key

Before you start using the Airtable - Update Records, you need to configure the API key to access your Airtable account from Byteline.

On the Byteline console, go to the Connection menu on the top navigation menu, and then select Airtable from the left panel as shown in the image below:

How to retrieve API Key from Airtable

You can get the API key from Airtable and then save it on the above screen.

Steps:

  1. Login to Airtable
  2. Navigate to your account page by clicking the user icon at the top-right, and then select Account
  3. Click the "Generate API Key" button as shown below. Now copy the API key and paste it on the Byteline console.

Create Airtable Update Records Node

Step -1: To get started, you will need to create a flow design. To add an Airtable -update records node, click on Airtable node to add it to the existing flow.

For creating a flow design, you can refer to the guide: How to create your first flow design.

How it works

This task intelligently figures out whether to update or insert a record to the Airtable base. This node first gets Airtable data using an API call, then it compares the unique columns of the Airtable data with the updated data. If the record already exists, Airtable automatically adds the data to the record. But if the data does not exist, Airtable adds new data to the record.

Configure the node

To open the Airtable configuration dialog, tap on the edit button of the Airtable node.

In the consecutive sections, you will learn how to enter a base ID, table name, and grid view in the Airtable configuration window.

Airtable Base Id

Step -1: By clicking on the Here button as shown below, you will be redirected to your Airtable Account where you can get your Airtable Base ID.

Step -2: Log in to your Airtable account with your email and password.

Step -3: Select your base from the Airtable API to view your API documentation. This will allow you to fetch your Airtable Base ID.

Step -4: Copy the base id as shown in the snippet below. In this case, the base id is "asappfHBMTMuJi4HDQ3". 

Step -5: Paste the copied string in the base Id field of the Airtable configuration window.

Airtable Table Name

Step -1: Go to the base in your Airtable and check the required table name mentioned.

Step -2: Enter the table name in the table name field of the configuration window.

Airtable View

Only the data matching the view shall be returned if the Airtable view is specified. If it's not specified, then all the data from the table is returned.

Step -1: You can find the View name in the top-left corner of the console of your Airtable base table.

Step -2: Enter the view name in the view field of the Airtable configuration window.

Loop Over

Loop over is used to call a task multiple times based on each entry of a JSON array. In the steps ahead, we will configure the array we want to iterate.

For a detailed understanding, refer to our guide: loop-over documentation.

Step -1: Tick the loop over checkbox for its configuration

Step -2: Select the array from the dropdown menu to iterate over.

For example, here we are selecting the web_scraper array for loop over. In the next section, we will configure each of the records that web_scraper retrieves as output.

Mapping Airtable Columns Data

In this section, we will learn to configure each of the Airtable columns data with their respective output values. Byteline populates the Field Names for which data needs to be configured. If any field is missing, you can add it using the + button.

For deleting any unwanted columns, click on the delete button next to each field.

Configure

You can configure the data type of the selected field in your Airtable by selecting the respective data value.

Step -1: Click on the Selector button to fetch the array path in the Value field of the Coin column.

Repeat step-1 for all the other Fields as shown in the image below:

Detailed field mapper configuration

You can get detailed documentation on using field mapper from https://docs.byteline.io/article/upw7xnv6nv-field-mapper-configuration

Once you save the configuration, the indicator over the top-right corner of the code node will turn green.

Your Airtable node has been configured successfully. Feel free to connect us for any doubts. Develop fast!


How did we do?