Package: airtable2 0.0.0.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.0.0.9000.tar.gz
airtable2_0.0.0.9000.zip(r-4.7)airtable2_0.0.0.9000.zip(r-4.6)airtable2_0.0.0.9000.zip(r-4.5)
airtable2_0.0.0.9000.tgz(r-4.6-any)airtable2_0.0.0.9000.tgz(r-4.5-any)
airtable2_0.0.0.9000.tar.gz(r-4.7-any)airtable2_0.0.0.9000.tar.gz(r-4.6-any)
airtable2_0.0.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
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:

3.90 score 82 exports 21 dependencies

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

TargetResultTimeFilesSyslog
linux-devel-x86_64OK171
source / vignettesOK179
linux-release-x86_64OK160
macos-release-arm64OK109
macos-oldrel-arm64OK106
windows-develOK115
windows-releaseOK120
windows-oldrelOK107
wasm-releaseOK116

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_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:askpassclicurlDBIdigestgluehttr2jsonlitelifecyclemagrittropensslpillarpkgconfigR6rappdirsrlangsystibbleutf8vctrswithr

Getting Started with airtable2

Rendered fromairtable2.Rmdusingknitr::rmarkdownon Jun 05 2026.

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

Metadata, Schema, and Backup in airtable2

Rendered frommetadata-backup.Rmdusingknitr::rmarkdownon Jun 05 2026.

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

Special Field Types in airtable2

Rendered fromspecial-types.Rmdusingknitr::rmarkdownon Jun 05 2026.

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

Using airtable2 with DBI

Rendered fromdbi.Rmdusingknitr::rmarkdownon Jun 05 2026.

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
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