Retrieve a table from Airtable to Pandas DataFrame

at_to_df.py

import requests
import pandas as pd

BASE_URL = 'https://api.airtable.com/v0/'


def airtable_to_dataframe(base_name, table_name, api_key):
    header = {'Authorization': 'Bearer ' + api_key}
    data = []
    r = requests.get(BASE_URL + base_name + '/' + table_name, headers=header)
    for x in r.json().get('records'):
        x.update(x.get('fields'))
        x.pop('fields')
        data.append(x)
    df = pd.DataFrame(data)

    return df