{ "_id": "6a23292c530b9bc726bce26b", "Package": "airtable2", "Title": "Pure R Client for the 'Airtable' REST API", "Version": "0.0.0.9000", "Authors@R": "c(\nperson(\"Noam\", \"Ross\", , \"noam.ross@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = \"author with heavy LLM assistance\"),\nperson(\"Darko\", \"Bergant\", role = \"aut\",\ncomment = \"Original airtabler package\"),\nperson(\"Collin\", \"Schwantes\", role = \"aut\",\ncomment = \"airtabler fork maintainer\")\n)", "Description": "A modern R client for the 'Airtable' REST API. Provides\nlow-level wrappers for all API endpoints, high-level functions\nfor reading, writing, upserting, and syncing records, and a\nDBI-compliant interface for RStudio/Positron connection pane\nintegration.", "License": "MIT + file LICENSE", "URL": "https://github.com/noamross/airtable2,\nhttps://noamross.github.io/airtable2/", "BugReports": "https://github.com/noamross/airtable2/issues", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "Config/roxygen2/version": "8.0.0", "RoxygenNote": "8.0.0", "Language": "en-US", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "libssl-dev", "Repository": "https://noamross.r-universe.dev", "Date/Publication": "2026-06-05 17:59:38 UTC", "RemoteUrl": "https://github.com/noamross/airtable2", "RemoteRef": "HEAD", "RemoteSha": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-05 19:49:42 UTC", "User": "root" }, "Author": "Noam Ross [aut, cre] (author with heavy LLM assistance),\nDarko Bergant [aut] (Original airtabler package),\nCollin Schwantes [aut] (airtabler fork maintainer)", "Maintainer": "Noam Ross ", "MD5sum": "319853c45c87400fb453459a26c611cd", "_user": "noamross", "_type": "src", "_file": "airtable2_0.0.0.9000.tar.gz", "_fileid": "4e34a111ab6c34b0e2e68893811293a13454b417075413b2f85712cee2ab051c", "_filesize": 456468, "_sha256": "4e34a111ab6c34b0e2e68893811293a13454b417075413b2f85712cee2ab051c", "_created": "2026-06-05T19:49:42.000Z", "_published": "2026-06-05T19:53:16.397Z", "_distro": "noble", "_jobs": [ { "job": 79802254407, "time": 171, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7445531139" }, { "job": 79802254351, "time": 160, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7445528024" }, { "job": 79802254423, "time": 106, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7445512132" }, { "job": 79802254404, "time": 109, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7445513178" }, { "job": 79801794875, "time": 179, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7445479468" }, { "job": 79802254313, "time": 116, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7445515365" }, { "job": 79802254376, "time": 115, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7445514872" }, { "job": 79802254340, "time": 107, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7445513240" }, { "job": 79802254339, "time": 120, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7445516602" } ], "_buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/noamross/airtable2", "_commit": { "id": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "author": "Noam Ross ", "committer": "Noam Ross ", "message": "Wording tweaks for attribution\n", "time": 1780682378 }, "_maintainer": { "name": "Noam Ross", "email": "noam.ross@gmail.com", "login": "noamross", "mastodon": "@noamross@ecoevo.social", "bluesky": "@noamross.net", "description": "Computational Disease Ecologist, Executive Director of @ropensci, consulting in forecasting, One Health, #RStats + open-source science", "uuid": 571752 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "digest", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "httr2", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "rlang", "version": ">= 1.0.0", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "vctrs", "role": "Imports" }, { "package": "httptest2", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "pillar", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "noamross", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-23", "n": 33 } ], "_tags": [], "_stars": 0, "_contributors": [ { "user": "collinschwantes", "count": 148, "uuid": 6107885 }, { "user": "noamross", "count": 33, "uuid": 571752 }, { "user": "bergant", "count": 12, "uuid": 8250901 }, { "user": "maelle", "count": 1, "uuid": 8360597 }, { "user": "rostal", "count": 1, "uuid": 21048553 } ], "_userbio": { "uuid": 571752, "type": "user", "name": "Noam Ross", "description": "Computational Disease Ecologist, Executive Director of @ropensci, consulting in forecasting, One Health, #RStats + open-source science" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/airtable2" }, "_devurl": "https://github.com/noamross/airtable2", "_pkgdown": "https://noamross.github.io/airtable2/", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/airtable2.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "air_api_usage", "air_attachment_preview_url", "air_browse", "air_connect", "air_delete", "air_demo", "air_demo_setup", "air_dump", "air_expand_collaborator", "air_expand_multiselect", "air_field_template", "air_flatten", "air_flatten_attachments", "air_flatten_collaborator", "air_flatten_links", "air_flatten_multiselect", "air_full_join", "air_inner_join", "air_left_join", "air_left_join_upload", "air_meta", "air_meta_init", "air_meta_push", "air_meta_sync", "air_pane", "air_read", "air_read_attachments", "air_req", "air_resolve_id", "air_restore", "air_schema", "air_set_base", "air_set_token", "air_simplify", "air_sync", "air_sync_attachments", "air_table_template", "air_token", "air_upsert", "air_write", "air_write_attachments", "airtable", "airtable2", "at", "at_create_base", "at_create_field", "at_create_records", "at_create_table", "at_delete_records", "at_get_base", "at_get_collaborators", "at_get_record", "at_get_schema", "at_get_view", "at_list_bases", "at_list_records", "at_list_views", "at_sitrep", "at_update_field", "at_update_records", "at_update_table", "at_upload_attachment", "at_whoami", "dbClearResult", "dbConnect", "dbDataType", "dbDisconnect", "dbExistsTable", "dbFetch", "dbGetInfo", "dbGetRowCount", "dbGetRowsAffected", "dbGetStatement", "dbHasCompleted", "dbIsValid", "dbListFields", "dbListTables", "dbReadTable", "dbRemoveTable", "dbSendQuery", "dbUnloadDriver", "dbWriteTable" ], "_help": [ { "page": "air_api_usage", "title": "Report Airtable API usage for a workspace", "topics": [ "air_api_usage" ] }, { "page": "air_attachment_preview_url", "title": "Get a stable preview URL for an Airtable attachment", "topics": [ "air_attachment_preview_url" ] }, { "page": "air_browse", "title": "Open an Airtable workspace, base, table, or view in the browser", "topics": [ "air_browse" ] }, { "page": "air_connect", "title": "Connect to Airtable via DBI", "topics": [ "air_connect" ] }, { "page": "air_delete", "title": "Delete records from a table (high-level)", "topics": [ "air_delete" ] }, { "page": "air_demo", "title": "Run an interactive airtable2 demo walkthrough", "topics": [ "air_demo" ] }, { "page": "air_demo_setup", "title": "Set up a demo Airtable base for exploration", "topics": [ "air_demo_setup" ] }, { "page": "air_dump", "title": "Dump an entire base (schema + data) for backup", "topics": [ "air_dump" ] }, { "page": "air_expand_collaborator", "title": "Expand collaborator strings to list-column", "topics": [ "air_expand_collaborator" ] }, { "page": "air_expand_multiselect", "title": "Expand delimited strings to a multi-select list-column", "topics": [ "air_expand_multiselect" ] }, { "page": "air_field_template", "title": "Build a field template specification", "topics": [ "air_field_template" ] }, { "page": "air_flatten", "title": "Flatten a complex Airtable column to a simple atomic vector", "topics": [ "air_flatten" ] }, { "page": "air_flatten_attachments", "title": "Flatten an attachments list-column to a summary string", "topics": [ "air_flatten_attachments" ] }, { "page": "air_flatten_collaborator", "title": "Flatten a collaborator list-column to strings", "topics": [ "air_flatten_collaborator" ] }, { "page": "air_flatten_links", "title": "Flatten a record-links list-column to delimited strings", "topics": [ "air_flatten_links" ] }, { "page": "air_flatten_multiselect", "title": "Flatten a multi-select list-column to delimited strings", "topics": [ "air_flatten_multiselect" ] }, { "page": "air_left_join", "title": "Join local data with an Airtable table", "topics": [ "air_full_join", "air_inner_join", "air_left_join" ] }, { "page": "air_left_join_upload", "title": "Upload local data to matched Airtable records", "topics": [ "air_left_join_upload" ] }, { "page": "air_meta", "title": "Get base metadata as a flat tibble", "topics": [ "air_meta" ] }, { "page": "air_meta_init", "title": "Seed the _metadata table from the live schema", "topics": [ "air_meta_init" ] }, { "page": "air_meta_push", "title": "Push metadata changes back to the base", "topics": [ "air_meta_push" ] }, { "page": "air_meta_sync", "title": "Sync a metadata source to patch the base schema", "topics": [ "air_meta_sync" ] }, { "page": "air_pane", "title": "Open the Airtable Connection Pane", "topics": [ "air_pane" ] }, { "page": "air_read", "title": "Read records from an Airtable table", "topics": [ "air_read" ] }, { "page": "air_read_attachments", "title": "Read attachments from records", "topics": [ "air_read_attachments" ] }, { "page": "air_req", "title": "Build an httr2 request to the Airtable API", "topics": [ "air_req" ] }, { "page": "air_resolve_id", "title": "Resolve an Airtable ID or URL to its component parts", "topics": [ "air_resolve_id" ] }, { "page": "air_restore", "title": "Restore a base from a dump", "topics": [ "air_restore" ] }, { "page": "air_schema", "title": "Get schema for a base as a tidy tibble", "topics": [ "air_schema" ] }, { "page": "air_set_base", "title": "Set the default Airtable base for this session", "topics": [ "air_set_base" ] }, { "page": "air_set_token", "title": "Set the default Airtable token for this session", "topics": [ "air_set_token" ] }, { "page": "air_simplify", "title": "Simplify all complex columns in a tibble for display/export", "topics": [ "air_simplify" ] }, { "page": "air_sync", "title": "Smart sync: diff-based upsert + delete", "topics": [ "air_sync" ] }, { "page": "air_sync_attachments", "title": "Smart sync attachments", "topics": [ "air_sync_attachments" ] }, { "page": "air_table_template", "title": "Build a table template specification", "topics": [ "air_table_template" ] }, { "page": "air_token", "title": "Resolve an Airtable personal access token", "topics": [ "air_token" ] }, { "page": "air_upsert", "title": "Upsert records into an Airtable table", "topics": [ "air_upsert" ] }, { "page": "air_write", "title": "Write (create) records in an Airtable table", "topics": [ "air_write" ] }, { "page": "air_write_attachments", "title": "Upload attachments to records", "topics": [ "air_write_attachments" ] }, { "page": "airtable2", "title": "Airtable DBI driver", "topics": [ "airtable", "airtable2", "at", "dbConnect,AirtableDriver-method", "dbDataType,AirtableDriver-method", "dbUnloadDriver,AirtableDriver-method" ] }, { "page": "AirtableConnection-class", "title": "Airtable DBI connection", "topics": [ "AirtableConnection-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" ] }, { "page": "AirtableDriver-class", "title": "Airtable DBI driver class", "topics": [ "AirtableDriver", "AirtableDriver-class" ] }, { "page": "AirtableResult-class", "title": "Airtable DBI result", "topics": [ "AirtableResult-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" ] }, { "page": "at_create_base", "title": "Create a new base", "topics": [ "at_create_base" ] }, { "page": "at_create_field", "title": "Create a field in a table", "topics": [ "at_create_field" ] }, { "page": "at_create_records", "title": "Create records in a table", "topics": [ "at_create_records" ] }, { "page": "at_create_table", "title": "Create a table in a base", "topics": [ "at_create_table" ] }, { "page": "at_delete_records", "title": "Delete records", "topics": [ "at_delete_records" ] }, { "page": "at_get_base", "title": "Get information about a single base", "topics": [ "at_get_base" ] }, { "page": "at_get_collaborators", "title": "Get collaborators for a base", "topics": [ "at_get_collaborators" ] }, { "page": "at_get_record", "title": "Get a single record", "topics": [ "at_get_record" ] }, { "page": "at_get_schema", "title": "Get the schema (tables + fields) for a base", "topics": [ "at_get_schema" ] }, { "page": "at_get_view", "title": "Get a specific view's metadata", "topics": [ "at_get_view" ] }, { "page": "at_list_bases", "title": "List all accessible bases", "topics": [ "at_list_bases" ] }, { "page": "at_list_records", "title": "List records from a table", "topics": [ "at_list_records" ] }, { "page": "at_list_views", "title": "List views in a table", "topics": [ "at_list_views" ] }, { "page": "at_sitrep", "title": "Summarize Airtable situation report", "topics": [ "at_sitrep" ] }, { "page": "at_update_field", "title": "Update field metadata", "topics": [ "at_update_field" ] }, { "page": "at_update_records", "title": "Update multiple records", "topics": [ "at_update_records" ] }, { "page": "at_update_table", "title": "Update table metadata", "topics": [ "at_update_table" ] }, { "page": "at_upload_attachment", "title": "Upload an attachment to a record field", "topics": [ "at_upload_attachment" ] }, { "page": "at_whoami", "title": "Get current user info", "topics": [ "at_whoami" ] } ], "_readme": "https://github.com/noamross/airtable2/raw/HEAD/README.md", "_rundeps": [ "askpass", "cli", "curl", "DBI", "digest", "glue", "httr2", "jsonlite", "lifecycle", "magrittr", "openssl", "pillar", "pkgconfig", "R6", "rappdirs", "rlang", "sys", "tibble", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "airtable2.Rmd", "filename": "airtable2.html", "title": "Getting Started with airtable2", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-06-04 09:30:08", "modified": "2026-06-05 17:29:56", "commits": 5 }, { "source": "metadata-backup.Rmd", "filename": "metadata-backup.html", "title": "Metadata, Schema, and Backup in airtable2", "engine": "knitr::rmarkdown", "headings": [ "Overview", "Schema inspection with air_schema()", "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)" ], "created": "2026-06-04 13:13:45", "modified": "2026-06-05 15:32:36", "commits": 3 }, { "source": "special-types.Rmd", "filename": "special-types.html", "title": "Special Field Types in airtable2", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-06-04 13:13:45", "modified": "2026-06-05 15:32:36", "commits": 3 }, { "source": "dbi.Rmd", "filename": "dbi.html", "title": "Using airtable2 with DBI", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Connecting", "Exploring the connection", "Reading data", "Writing data", "Multi-base mode", "Limitations" ], "created": "2026-06-05 02:54:47", "modified": "2026-06-05 15:32:36", "commits": 2 } ], "_score": 3.9030899869919438, "_indexed": true, "_nocasepkg": "airtable2", "_universes": [ "noamross" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.0.9000", "date": "2026-06-05T19:52:17.000Z", "distro": "noble", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "86b863eefaa4c15b89f15e8c6fec4526eaf168e7a815fadfa0a717179ac8dbcf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.6.0", "os": "linux", "version": "0.0.0.9000", "date": "2026-06-05T19:52:06.000Z", "distro": "noble", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "1d40492e30f556dabf9874095ad31670e702752bff3444bdc38b02f5d52626dc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.5.3", "os": "mac", "version": "0.0.0.9000", "date": "2026-06-05T19:51:25.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "8d8fb952fd51b5a806fcfd1559b4b4721e69f878e4080e2afd29a418e9c7f604", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.6.0", "os": "mac", "version": "0.0.0.9000", "date": "2026-06-05T19:51:25.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "a8875a3e2e53c2423e0c003e508b387c04e6cbeefaca8cc63ad5849dfcaf383c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.0.9000", "date": "2026-06-05T19:52:02.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "c5407e3eac2f1ce6680e04dc55285eedfd69fa487d7f02191f6a5b2fc9e9abf0", "status": "success", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.7.0", "os": "win", "version": "0.0.0.9000", "date": "2026-06-05T19:51:07.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "ba019a142f7ba0afba660c8fe452c9af97d69217f4f0becff252b5a913aef8ae", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.5.3", "os": "win", "version": "0.0.0.9000", "date": "2026-06-05T19:51:04.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "f09fa7b807e1692c4857d473dc948800e5823775e5681ac66c6f199c9d1e5ae1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" }, { "r": "4.6.0", "os": "win", "version": "0.0.0.9000", "date": "2026-06-05T19:51:04.000Z", "commit": "b23512c66243ed061e21bdd2293f99b6a1856a3b", "fileid": "c07d233dd55a4dc1bc450d958f9ded6115ffa5c9c370fbfbb86eeb8a68f659c8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/27036504125" } ] }