View Navigation
Integrations   ->

Pull from Airtable

Use the Pull from Airtable step to pull in your data from your Airtable databases.

Connect your Airtable account

To connect to your Airtable account, click the blue Authorize button.


Next, you will need your API Key, which can be found on your account page.


Copy your API key and paste it into the Airtable API Key field in Parabola. Then click Authorize.

Custom settings

Finding your Base ID

You'll need to tell Parabola which of your Airtable Bases and Tables you'd like to import. To start, enter your Base ID. Find your Base ID by:

  1. Visit the Airtable API documentation page
  1. Select the base you would like to access:

  1. Locate your Base ID in Airtable's 'Introduction' tab.

  1. Copy that string and paste it into the step's Base ID field.

Finding your Table Name

Your Table Name is the name of a table within an Airtable Base. You can find the different tables on the same page you found your Base ID. They are located in the left sidebar.

Enter your table's name (without the word 'table') into the step's Table Name field. For example, your Airtable "Product Inventory Table" would be "Product Inventory" in the step.

Helpful tips

Linked Records

If you have linked entries within cells, those values will be pulled as ID's. You can use those ID's as keys for data from multiple tables using the Combine tables step. For example, if you have a table called "Product Inventory", which has a field linking those products to a "Manufacturers" table, the "Product Inventory" table inside Parabola will contain a key to all of the linked entries in the "Manufacturers" table. If you use another Pull from Airtable step (hint: duplicate it by selecting it and pressing the 'd' key) you can access the "Manufacturers" table and add a Combine tables step using the "ID" column in the "Manufacturers" table and the "{ID}" column in the "Product Inventory" table.

Good to know

If a column has no values in it, that column will not be imported. There must be at least one value present in a row for the column itself to come through.

Send to Airtable using the API

Use the Send to an API step to send in your data to your Airtable databases.

Connect your Airtable account

First, select the Type to PATCH.

Finding your Endpoint URL

You'll need to tell Parabola which of your Airtable Bases and Tables you'd like to send your data to. To start, enter your Endpoint URL. You find your Endpoint URL:

https://assets.website-files.com/5d9bdcad630fbe7a7468a9d8/5db23862c792ece0057dee2f_Screen_Shot_2018-03-28_at_1.59.38_PM.png
  • Locate your Table in the left column. For this example, we will use the Update records API, however, you can also use Create records and Delete records in this step, if you so choose.
  • On the right side of the screen, you will see an Example request. Copy that URL from https:// through the first \\ and paste it in Parabola.


Entering your call's Body

Next, you'll need to tell Airtable what values you will be updating. To do that find the data section of your Example request and enter it in the Body field in the Send to an API step in Parabola.


Replace the example id string with the name of your  column in curly braces, like so: {id}. This will tell the step to send each unique id, row by row, and map it to the correct entry in Airtable.


Lastly, enter the fields you plan to update and map them to their corresponding columns.

You can include more fields by adding a comma between each entry.

Correctly close your Body and you're all set.


Custom settings

Authentication is required with this call. Select Bearer Token from the Authentication dropdown.


Next, you will need to find your Bearer Token which is just your Airtable API key. You can find your API key on your account page.


Copy your API Key and paste it in the Bearer Token field.


Be sure that in your Custom Headers section, your Header Key is set to Content-Type, and your Header Value is set to application/json. These should be the default Custom Headers.

Publish and run your flow and you're all set to update Airtable records!

Recipes

Try Parabola for free