Skip to main content

Airtable

Join the Beta

For early access to the Airtable private beta, enter your email to join the waitlist

In the meantime, the Superblocks REST API integration can be used to connect to the Airtable REST API.

Overview

Connect Superblocks to Airtable to build internal tools that create, fetch, update, and delete records in your Airtable bases.

Setting up Airtable

1. Create an Airtable token

Generate a personal access token following the instructions here.

2. Create REST API integration

Select REST API from the in-app Integrations page and fill out the form with the following configuration:

  • Display Name - Name that will be displayed to users when selecting this integration in Superblocks
  • Base URL - Airtable API URL - https://api.airtable.com/v0
  • Authentication - None (configured in following Headers)
  • Headers - Add your personal access token as an authorization bearer token header
  • Params - Any additional query parameters to send
superblocks airtable rest api integration

3. Set environments

After creating the integration, you can optionally set different settings for your Production and Staging environments.

success

Airtable Connected You can now query Airtable in any Application, Workflow, or Scheduled Job.

Creating Airtable steps

Connect to your Airtable integration from Superblocks by creating steps in Application APIs, Workflows, and Scheduled Jobs.

Follow the Airtable REST API documentation to call specific URL paths. For example, to list records in a table.

superblocks airtable rest api step

Note, to visualize the data in a Superblocks table, a follow up code step is needed to flatten the JSON response so it is a list of objects. There are different ways to accomplish this, but here are a couple examples using Python and JavaScript. Adjust as needed for your data set.
import pandas as pd
import json
flattened_json = pd.json_normalize(getAirtableRecords.output.records)
df = pd.DataFrame.from_dict(flattened_json)
return json.loads(df.to_json(orient='records'))

Use cases

Applications

With the Airtable project tracking data properly formatted, we can now visualize it in a table alongside other information and components like dropdowns, charts, and slideouts.