airtable_python_sdk_quickstart_list_records.py

1import os
2from airtable import Api
3
4# Initialize the API client with your Personal Access Token
5# It is recommended to use environment variables for security
6api = Api(os.environ.get('AIRTABLE_ACCESS_TOKEN'))
7
8# Define your Base ID and Table Name (or Table ID)
9base_id = 'app876543210'
10table_name = 'Table Name'
11
12# Access the table
13table = api.table(base_id, table_name)
14
15# Fetch all records from the table
16records = table.all()
17
18# Iterate through and print record data
19for record in records:
20    print(f"Record ID: {record['id']}")
21    print(f"Fields: {record['fields']}")
22
23# Example: Create a new record
24# new_record = table.create({"Name": "New Entry", "Status": "Todo"})