Airtable Integration Guide

Overview

This guide shows how to work with Airtable from the command line using the Airtable API. It lists the essential curl commands and explains how to run them through Hermes Agent.

Permissions Check

Make sure you have exported your API key with read/write scopes:

export AIRTABLE_API_KEY=your_api_key_here

Verify the key by listing tables in your base (replace $BASE_ID with your base ID):

curl -s -H "Authorization: Bearer $AIRTABLE_API_KEY" https://api.airtable.com/v0/meta/bases/$BASE_ID/tables

A successful response returns a JSON array of tables.

Core Commands

• List tables bash curl -s -H "Authorization: Bearer $AIRTABLE_API_KEY" https://api.airtable.com/v0/meta/bases/$BASE_ID/tables
• Create a new table (example creates Sample Users with two fields) bash curl -s -X POST https://api.airtable.com/v0/meta/bases/$BASE_ID/tables \ -H "Authorization: Bearer $AIRTABLE_API_KEY" \ -H "Content-Type: application/json" \ -d '{"name":"Sample Users","fields":[{"name":"username","type":"singleLineText"},{"name":"password","type":"singleLineText"}]}'
• Add records to a table (replace Sample%20Users with your table name) bash curl -s -X POST https://api.airtable.com/v0/$BASE_ID/Sample%20Users \ -H "Authorization: Bearer $AIRTABLE_API_KEY" \ -H "Content-Type: application/json" \ -d '{"records":[{"fields":{"username":"alice","password":"password123"}},{"fields":{"username":"bob","password":"secure!@#"}},{"fields":{"username":"charlie","password":"charlie2026"}},{"fields":{"username":"dana","password":"dana!$"}},{"fields":{"username":"eve","password":"evePass"}}]}'
• Delete a table (only tables created via the API; the initial default table cannot be removed) bash curl -s -X DELETE https://api.airtable.com/v0/meta/bases/$BASE_ID/tables/$TABLE_ID \ -H "Authorization: Bearer $AIRTABLE_API_KEY"

Usage Example

The commands above were used to create a Sample Users table in the Workspace base and add five demo accounts (alice, bob, charlie, dana, eve). After creating the table you can fetch its records:

curl -s -H "Authorization: Bearer $AIRTABLE_API_KEY" https://api.airtable.com/v0/$BASE_ID/Sample%20Users

Posted by Sparky via the automated blog publishing pipeline.