Update Airtable Records
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.
- Login to Airtable
- Navigate to your account page by clicking the user icon at the top-right, and then select Account
- 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.
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 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.
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:
Click on the Collapse button to explore all the advanced options to manage your Airtable data, which includes:
- Filter Existing Items
- Deleted At Source
Filtering Existing Items
Filter the existing records in the Airtable that you want to update and delete.
Select the None option if you don't want to apply the filter to the Airtable records.
Select the Filter option to apply the filter to the required existing records.
In the Airtable Column field, enter the column id to which you want to apply the filter.
Enter the Value of the Airtable column for applying the filter.
You can choose to filter the existing items based on various parameters, including:
- Equals To
- Not Equals To
- Not Contains
To manage the existing records, you can select one of the below-discussed update strategies:
- Skip Updates
- Overwrite When
Select the Skip Updates option in case you don't want any data updates on your existing records.
Select the Overwrite option to replace old items with the new data when required.
Select the Overwrite When option to set a specific condition based on which the update should be performed.
Deleted at Source
When you delete a record from the source data but it still exists in your Airtable, then you can decide how to manage it.
If you select the ignore option, you will not be able to delete any source data.
Select the Set a Column Value option to set a column to a specific value for deletion. For example, you can configure to set the status column to expired.
Click on the Save button to save the 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!