Skip to content

Latest commit

 

History

History
38 lines (28 loc) · 1.57 KB

README.md

File metadata and controls

38 lines (28 loc) · 1.57 KB
Raw

Airtable Base Exporter

This Python script exports data from all tables in one or more Airtable bases. It retrieves data using the Airtable API and saves each table's data as a JSON file. This tool is useful for backing up Airtable data or migrating it to another system.

Features

  • Exports all tables from one or more specified Airtable bases.
  • Saves each table's data in JSON format, organized by base name.
  • Configurable to export all accessible bases or only selected bases.
  • Stores exported data in a configurable directory.

Configuration

The script requires a config.yaml file for configuration. This file should contain your Airtable API key, the backup directory, and an optional list of base IDs to export.

  • api_key: Your Airtable API key. You can obtain this from your Airtable account settings.
  • backup_directory: The directory where the exported data will be saved.
  • bases: A list of base IDs to export. If this list is empty, the script will export data from all bases accessible with the provided API key.

Sample config.yaml

airtable:
  api_key: 'your_api_key'
  backup_directory: 'your_backup_folder'  # Path to the folder where backups will be saved
  bases:  # Optional: specify base IDs to export; leave empty to export all accessible bases
    - 'appMcxefsViu55eF5'
    - 'appi1K0YweJOS255s'
    - 'appUCFNiJjXgD1hXb'

Prerequisites

  1. Python 3.x: Ensure Python is installed.

  2. Install dependencies: Use the provided requirements.txt file to install the necessary libraries:

    pip install -r requirements.txt