@versatly/airtable-cli
v1.0.0
Published
Airtable CLI for bases, tables, and records
Maintainers
Readme
@versatly/airtable-cli
CLI for Airtable base, table, and record operations using the official Airtable SDK.
Install
npm install -g @versatly/airtable-cliAuthentication
Create a personal access token in Airtable and export it as AIRTABLE_API_KEY:
export AIRTABLE_API_KEY="patXXXXXXXXXXXXXX"Usage
List bases:
airtable bases listList tables in a base:
airtable tables list --base appXXXXXXXXXXXXXXList records (optionally by view):
airtable records list --base appXXXXXXXXXXXXXX --table "Projects"
airtable records list --base appXXXXXXXXXXXXXX --table "Projects" --view "Main View"Get a record:
airtable records get --base appXXXXXXXXXXXXXX --table "Projects" --id recXXXXXXXXXXXXXXCreate a record:
airtable records create --base appXXXXXXXXXXXXXX --table "Projects" --fields '{"Name":"Launch","Status":"In Progress"}'Update a record:
airtable records update --base appXXXXXXXXXXXXXX --table "Projects" --id recXXXXXXXXXXXXXX --fields '{"Status":"Done"}'Delete a record:
airtable records delete --base appXXXXXXXXXXXXXX --table "Projects" --id recXXXXXXXXXXXXXXSearch with a formula:
airtable search --base appXXXXXXXXXXXXXX --table "Projects" --query "FIND('Launch', {Name})"Output
All commands emit JSON to stdout for easy piping into other tools.
