Documentation

    Airtable

    Read records from an Airtable table into a Strata flow. Oplema can't write to Airtable.

    Before you start

    • An Airtable account with access to the base you want to read.
    • Permissions Oplema asks for: data.records:read and schema.bases:read. The Base list shows the bases Airtable returns for this connection.
    • Requests to Airtable come from Oplema's servers, not your browser. If your Airtable account restricts access by network, it must allow them. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.

    Connect

    1. In Strata, select an Input block.
    2. Set Source to Connectors.
    3. In the connector dropdown below it, choose Airtable.
    4. Open the Connection dropdown and choose Create new connection.
    5. Set Name (optional). Without a name, the connection is labeled airtable plus the date and time.
    6. Select Connect to Airtable. Airtable's own sign-in opens in a popup. Approve access there.

    The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to Airtable.

    Read

    SettingWhat it does
    BaseThe base to read.
    TableThe table. All fields are included.
    ViewOptional. Default All records. A view filters and orders records, but its hidden fields are still included.

    Select Refresh data to fetch the latest records. Linked records and attachments aren't downloaded. Nested values stay as JSON; use Parse → JSON to split them out.

    Oplema reads 100 records per request, with a pause between requests to respect Airtable's rate limits, so large tables take time.

    Limits and billing

    • Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
    • If Airtable rate-limits the read, Oplema waits up to 30 seconds and retries once.

    See Billing for who pays and how usage works.

    Troubleshooting

    MessageWhat to do
    Airtable: HTTP 401. Reconnect your Airtable account.Select the connection, then select Reconnect to Airtable.
    Airtable: HTTP 403. Your connection cannot access this base or table.Select Reconnect to Airtable, or check your role on the base in Airtable.
    Airtable: selected table is missing; select it againThe table was deleted or renamed away. Pick it again.
    Airtable: selected view is missing; select it againPick another view, or use All records.
    This transfer exceeds the free 50 MB and the available usage creditsThe read passed 50 MB and your usage ran out. Add usage, or read less data.

    Prepare your data. Build it in Strata.

    Strata opens in your browser, with no account.