Package: airtable2 0.1.2.9000

airtable2: Pure R Client for the 'Airtable' REST API

A modern R client for the 'Airtable' REST API. Provides low-level wrappers for all API endpoints, high-level functions for reading, writing, upserting, and syncing records, and a DBI-compliant interface for RStudio/Positron connection pane integration.

Authors:Noam Ross [aut, cre], Darko Bergant [aut], Collin Schwantes [aut]

airtable2_0.1.2.9000.tar.gz
airtable2_0.1.2.9000.zip(r-4.7)airtable2_0.1.2.9000.zip(r-4.6)airtable2_0.1.2.9000.zip(r-4.5)
airtable2_0.1.2.9000.tgz(r-4.6-any)airtable2_0.1.2.9000.tgz(r-4.5-any)
airtable2_0.1.2.9000.tar.gz(r-4.7-any)airtable2_0.1.2.9000.tar.gz(r-4.6-any)
airtable2_0.1.2.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
airtable2/json (API)

# Install 'airtable2' in R:
install.packages('airtable2', repos = c('https://noamross.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/noamross/airtable2/issues

Pkgdown/docs site:https://noamross.github.io

On CRAN:

Conda:

4.70 score 1 stars 10 scripts 84 exports 20 dependencies

Last updated from:f1a9ef2e94. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK201
source / vignettesOK220
linux-release-x86_64OK168
macos-release-arm64OK144
macos-oldrel-arm64OK184
windows-develOK130
windows-releaseOK121
windows-oldrelOK115
wasm-releaseOK112

Exports:air_api_usageair_attachment_preview_urlair_browseair_connectair_deleteair_demoair_demo_setupair_dumpair_expand_collaboratorair_expand_multiselectair_field_templateair_flattenair_flatten_attachmentsair_flatten_collaboratorair_flatten_linksair_flatten_multiselectair_full_joinair_infer_fieldsair_infer_tableair_inner_joinair_left_joinair_left_join_uploadair_metaair_meta_initair_meta_pushair_meta_syncair_paneair_readair_read_attachmentsair_reqair_resolve_idair_restoreair_schemaair_set_baseair_set_tokenair_simplifyair_syncair_sync_attachmentsair_table_templateair_tokenair_upsertair_writeair_write_attachmentsairtableairtable2atat_create_baseat_create_fieldat_create_recordsat_create_tableat_delete_recordsat_get_baseat_get_collaboratorsat_get_recordat_get_schemaat_get_viewat_list_basesat_list_recordsat_list_viewsat_sitrepat_update_fieldat_update_recordsat_update_tableat_upload_attachmentat_whoamidbClearResultdbConnectdbDataTypedbDisconnectdbExistsTabledbFetchdbGetInfodbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbReadTabledbRemoveTabledbSendQuerydbUnloadDriverdbWriteTable

Dependencies:askpassclicurlDBIdigestgluehttr2jsonlitelifecyclemagrittropensslpillarpkgconfigR6rlangsystibbleutf8vctrswithr

Getting Started with airtable2
Overview | Installation | Credentials and Authentication | Create a Personal Access Token | Supplying your token | Setting a default base | Checking access | Finding your workspace ID | API Limitations | Monthly call quota | No API deletion of bases, tables, or fields on free tier | Checkbox fields | Computed and read-only fields | Walkthrough | Step 1 — Setup | Step 2 — Create a demo base | Step 3 — Read records | Step 4 — Write records | Step 5 — Upsert and sync | Step 6 — Join local data with an Airtable table | Step 7 — Attachments | Step 8 — Special types | Step 9 — Schema and metadata | Step 10 — Backup and restore | Step 11 — Monitor API usage | Step 12 — Teardown | Further resources
Rendered fromairtable2.Rmdusingknitr::rmarkdown

Last update: 2026-06-16
Started: 2026-06-04

Metadata, Schema, and Backup in airtable2
Overview | Schema inspection with air_schema() | Building table specifications with air_infer_fields() and air_infer_table() | Self-documenting bases with air_meta() | Pushing changes with air_meta_push() | Making a base self-documenting with air_meta_sync() | Full backup with air_dump() | Parameters | Output structure (JSON format) | What is included | What is NOT included | Restoring with air_restore() | What works | Restore limitations | Backup/restore workflow example | Re-linking after restore (advanced)
Rendered frommetadata-backup.Rmdusingknitr::rmarkdown

Last update: 2026-06-11
Started: 2026-06-04

Special Field Types in airtable2
Overview | 1. Multi-select fields (air_multiselect) | Flattening to a character vector | Expanding back to a list-column | Round-tripping through write | 2. Linked records (air_links) | Flattening links | Joining to resolve linked records | Re-linking records after a restore | 3. Attachments (air_attachments) | Flattening attachment metadata | Downloading attachments with air_read_attachments() | Parallel downloads | Uploading attachments with air_write_attachments() | Diff-based sync with air_sync_attachments() | Stable preview URLs and the temporary-URL caveat | 4. Collaborator fields (air_collaborator / air_collaborators) | Flattening collaborators | Expanding strings back to collaborator list-columns | 5. Barcode fields (air_barcode) | 6. air_simplify() — the kitchen-sink flattener | When to use air_simplify() vs. the type-specific flatteners | See also
Rendered fromspecial-types.Rmdusingknitr::rmarkdown

Last update: 2026-06-05
Started: 2026-06-04

Using airtable2 with DBI
Introduction | Connecting | Exploring the connection | Reading data | Writing data | Multi-base mode | Limitations
Rendered fromdbi.Rmdusingknitr::rmarkdown

Last update: 2026-06-05
Started: 2026-06-05

Readme and manuals

Help Manual

Help pageTopics
Report Airtable API usage for a workspaceair_api_usage
Get a stable preview URL for an Airtable attachmentair_attachment_preview_url
Open an Airtable workspace, base, table, or view in the browserair_browse
Connect to Airtable via DBIair_connect
Delete records from a table (high-level)air_delete
Run an interactive airtable2 demo walkthroughair_demo
Set up a demo Airtable base for explorationair_demo_setup
Dump an entire base (schema + data) for backupair_dump
Expand collaborator strings to list-columnair_expand_collaborator
Expand delimited strings to a multi-select list-columnair_expand_multiselect
Build a field template specificationair_field_template
Flatten a complex Airtable column to a simple atomic vectorair_flatten
Flatten an attachments list-column to a summary stringair_flatten_attachments
Flatten a collaborator list-column to stringsair_flatten_collaborator
Flatten a record-links list-column to delimited stringsair_flatten_links
Flatten a multi-select list-column to delimited stringsair_flatten_multiselect
Infer Airtable field specifications from a data frameair_infer_fields
Infer an Airtable table specification from a data frameair_infer_table
Join local data with an Airtable tableair_full_join air_inner_join air_left_join
Upload local data to matched Airtable recordsair_left_join_upload
Get base metadata as a flat tibbleair_meta
Seed the _metadata table from the live schemaair_meta_init
Push metadata changes back to the baseair_meta_push
Sync a metadata source to patch the base schemaair_meta_sync
Open the Airtable Connection Paneair_pane
Read records from an Airtable tableair_read
Read attachments from recordsair_read_attachments
Build an httr2 request to the Airtable APIair_req
Resolve an Airtable ID or URL to its component partsair_resolve_id
Restore a base from a dumpair_restore
Get schema for a base as a tidy tibbleair_schema
Set the default Airtable base for this sessionair_set_base
Set the default Airtable token for this sessionair_set_token
Simplify all complex columns in a tibble for display/exportair_simplify
Smart sync: diff-based upsert + deleteair_sync
Smart sync attachmentsair_sync_attachments
Build a table template specificationair_table_template
Resolve an Airtable personal access tokenair_token
Upsert records into an Airtable tableair_upsert
Write (create) records in an Airtable tableair_write
Upload attachments to recordsair_write_attachments
Airtable DBI driverairtable airtable2 at dbConnect,AirtableDriver-method dbDataType,AirtableDriver-method dbUnloadDriver,AirtableDriver-method
Airtable DBI connectionAirtableConnection-class dbDisconnect,AirtableConnection-method dbExistsTable,AirtableConnection,character-method dbGetInfo,AirtableConnection-method dbIsValid,AirtableConnection-method dbListFields,AirtableConnection,character-method dbListTables,AirtableConnection-method dbReadTable,AirtableConnection,character-method dbRemoveTable,AirtableConnection,character-method dbWriteTable,AirtableConnection,character-method
Airtable DBI driver classAirtableDriver AirtableDriver-class
Airtable DBI resultAirtableResult-class dbClearResult,AirtableResult-method dbFetch,AirtableResult,missing-method dbFetch,AirtableResult,numeric-method dbGetRowCount,AirtableResult-method dbGetRowsAffected,AirtableResult-method dbGetStatement,AirtableResult-method dbHasCompleted,AirtableResult-method dbIsValid,AirtableResult-method dbSendQuery,AirtableConnection,character-method
Create a new baseat_create_base
Create a field in a tableat_create_field
Create records in a tableat_create_records
Create a table in a baseat_create_table
Delete recordsat_delete_records
Get information about a single baseat_get_base
Get collaborators for a baseat_get_collaborators
Get a single recordat_get_record
Get the schema (tables + fields) for a baseat_get_schema
Get a specific view's metadataat_get_view
List all accessible basesat_list_bases
List records from a tableat_list_records
List views in a tableat_list_views
Summarize Airtable situation reportat_sitrep
Update field metadataat_update_field
Update multiple recordsat_update_records
Update table metadataat_update_table
Upload an attachment to a record fieldat_upload_attachment
Get current user infoat_whoami