Migrate Airtable
This module allows you to migrate content from Airtable bases into Drupal. It provides a source plugin that can import records, map relationships, and handle file information from Airtable tables into Drupal entities. This makes Airtable a useful tool for staging and cleaning data before bringing it into Drupal.
This module provides a Migration Source for Airtable bases that helps programmers create migrations from Airtable into Drupal.
Airtable is a flexible spreadsheet/database solution that makes an excellent tool for staging a content inventory or cleaning up your data before migrating it into Drupal. With this module, you can map tables, relationships, and file information from Airtable into Drupal entities, relationships, and media.
Features
Import records from any of your Airtable bases into any Drupal entity type:
- Supports Airtable views and filters
- Automatically populates Source fields list, making it quick to create mappings
- Allows you to maintain relationships from Airtable's linked records into Drupal's entity reference fields
- Respects Airtable’s API limits of 5 requests per second
Post-Installation
After creating and setting up an API key with Airtable, you can create migration files that look like this against the Articles table in a base named 'Content Migration Example'
id: articles
label: "Articles from Airtable"
source:
plugin: airtable
base: 'Content Migration Example'
table: 'Articles'
constants:
uid: 1
body_format: basic_html
destination:
plugin: entity:node
default_bundle: article
process:
title: Title
uid: constants/uid
body/value: Body
body/format: constants/body_format
Requirements
This module requires Migrate Plus and some familiarity with setting up a migration.