Fetch hierarchical data records from Airtable with multi-level relationships

Airtable Hierarchical Record Fetcher

Description

This n8n workflow retrieves an Airtable record along with its related child records in a hierarchical structure. It can fetch up to 3 levels of linked records and assembles them into a comprehensive JSON object, making it ideal for complex data relationships and nested record structures.

Features

- Multi-level Record Fetching: Retrieves parent record, linked child records (level 2), and optionally grandchild records (level 3) - API Call Optimization: Uses Airtable's filterByFormula to minimize API calls by fetching multiple related records in single requests - Selective Level 3 Fetching: Only fetches level 3 records for specified linked fields to optimize performance - Rich Text Processing: Converts Airtable's pseudo-markdown rich text fields to HTML format - Hierarchical JSON Output: Organizes all data in a structured, nested JSON format - Flexible Configuration: Customizable depth and field selection per execution

Input Parameters

The workflow accepts a JSON array with the following structure:

json [ { "baseid": "appN8nPMGoLNuzUbY", "tableid": "tblLVOwpYIe0fGQ52", "recordid": "reczMh1Pp5l94HdYf", "level3": [ "fldRaFra1rLta66cD", "fld3FxCaYk8AVaEHt" ], "tohtml": true } ]