Airtable

Overview

The Airtable class allows you to interact with an Airtable base. In order to use this class you must generate an Airtable personal access token which can be found in your Airtable settings.

Note

Finding The Base Key

The easiest place to find the base_key for the base that you wish to interact with is via the Airtable API documentation.

  • Go to the Airtable API Base List and select the base.

  • The url of the resulting page will contain the base_key.

  • Example: https://airtable.com/[BASE_KEY]/api/docs#curl/introduction

QuickStart

To instantiate the Airtable class, you can either store your Airtable personal access token AIRTABLE_PERSONAL_ACCESS_TOKEN as an environmental variable or pass in your personal access token as an argument. You also need to pass in the base key and table name.

from parsons import Airtable

# First approach: Use personal access token via environmental variable and pass
# the base key and the table as arguments.
at = Airtable(base_key, 'table01')

# Second approach: Pass personal access token, base key and table name as arguments.
at = Airtable(base_key, 'table01', personal_access_token='MYFAKETOKEN')

You can then call various endpoints:

# Get records from a base
at.get_records(fields=['id', 'fn', 'ln'])

# Get a single record from a base
at.get_record(1233)

# Insert records
tbl.from_csv('my_new_records')
at.insert_records(tbl)

API