Airtable - Get data

Tags: #airtable #database #productivity #spreadsheet #naas_drivers #operations #snippet #dataframe

Last update: 2023-04-12 (Created: 2022-02-22)

Description: This notebook provides an introduction to Airtable, a cloud-based database platform that allows users to easily access and manage data. It provides step-by-step instructions on how to get data from Airtable into a notebook for further analysis.

Input

Import library

In [ ]:

from naas_drivers import airtable

Variables

In [ ]:

API_KEY = "API_KEY"
BASE_KEY = "BASE_KEY"
TABLE_NAME = "TABLE_NAME"

Model

Connect to airtable and get data

In [ ]:

df = airtable.connect(API_KEY, BASE_KEY, TABLE_NAME).get(
    view="All opportunities", maxRecords=20
)

Output

Display result

In [ ]:

df