{ "_id": "6a5fdc1014e95619b75d7787", "Package": "airtable2", "Title": "Pure R Client for the 'Airtable' REST API", "Version": "0.1.2.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-07-21 19:03:56 UTC", "RemoteUrl": "https://github.com/noamross/airtable2", "RemoteRef": "HEAD", "RemoteSha": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-21 20:48:26 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 ", "_user": "noamross", "_type": "src", "_file": "airtable2_0.1.2.9000.tar.gz", "_fileid": "https://r2.ropensci.org/626a9deb09bf64589913751eb80a93ec3b32eb9a9be121100fee63091d727d42", "_filesize": 488013, "_sha256": "626a9deb09bf64589913751eb80a93ec3b32eb9a9be121100fee63091d727d42", "_expires": "2026-10-29T20:52:30.000Z", "_created": "2026-07-21T20:48:26.000Z", "_published": "2026-07-21T20:52:32.108Z", "_jobs": [ { "job": 88758809531, "time": 201, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8509816522" }, { "job": 88758809523, "time": 168, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8509802067" }, { "job": 88758809564, "time": 184, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8509794381" }, { "job": 88758809520, "time": 144, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8509782403" }, { "job": 88757940631, "time": 220, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8509723821" }, { "job": 88758809506, "time": 112, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8509776748" }, { "job": 88758809631, "time": 130, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8509785244" }, { "job": 88758809626, "time": 115, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8509778138" }, { "job": 88758809471, "time": 121, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8509780793" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287", "_status": "success", "_upstream": "https://github.com/noamross/airtable2", "_commit": { "id": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "author": "Eric R. Scott ", "committer": "GitHub ", "message": "Merge pull request #21 from noamross/fix-created-times\n\nProperly read date-formatted createdTime/lastModifiedTime fields", "time": 1784660636 }, "_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 }, "_distro": "resolute", "_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 }, { "week": "2026-24", "n": 10 }, { "week": "2026-25", "n": 15 }, { "week": "2026-27", "n": 1 }, { "week": "2026-30", "n": 1 } ], "_tags": [], "_stars": 1, "_contributors": [ { "user": "collinschwantes", "count": 148, "uuid": 6107885 }, { "user": "noamross", "count": 60, "uuid": 571752 }, { "user": "bergant", "count": 12, "uuid": 8250901 }, { "user": "aariq", "count": 1, "uuid": 25404783 }, { "user": "maelle", "count": 1, "uuid": 8360597 }, { "user": "rostal", "count": 1, "uuid": 21048553 } ], "_userbio": { "uuid": 571752, "type": "user", "name": "Noam Ross", "followers": 576, "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": 10, "_rbuild": "4.6.1", "_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", "LICENSE", "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_infer_fields", "air_infer_table", "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_infer_fields", "title": "Infer Airtable field specifications from a data frame", "topics": [ "air_infer_fields" ] }, { "page": "air_infer_table", "title": "Infer an Airtable table specification from a data frame", "topics": [ "air_infer_table" ] }, { "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", "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-16 22:25:29", "commits": 7 }, { "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()", "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)" ], "created": "2026-06-04 13:13:45", "modified": "2026-06-11 20:12:38", "commits": 4 }, { "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": 4.698970004336019, "_indexed": true, "_nocasepkg": "airtable2", "_universes": [ "noamross" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.2.9000", "date": "2026-07-21T20:51:28.000Z", "distro": "resolute", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/abc3e43d34e3bf8a90014ac14b0171f2fe0d649a43d04bad9f823d78abfe582d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.6.1", "os": "linux", "version": "0.1.2.9000", "date": "2026-07-21T20:50:49.000Z", "distro": "resolute", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/5adb973a3a10696c2c3ebf372f48636b559e31237b90bf3ba82b9b2a506fbc20", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.5.3", "os": "mac", "version": "0.1.2.9000", "date": "2026-07-21T20:50:40.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/7a79ba90e250e1ec97170d2a64e38ec3843711b861ec8ba25192d17de40b2fb6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.6.1", "os": "mac", "version": "0.1.2.9000", "date": "2026-07-21T20:50:21.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/5b0d1720237dacf44191908a32f1a07a08d6ae08b394725cc10870c1f135181b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.2.9000", "date": "2026-07-21T20:50:38.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/133a975b75bd283b41b5dab47b64f7554cc28f868c4dd84ed83aa5032294bdd1", "status": "success", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.7.0", "os": "win", "version": "0.1.2.9000", "date": "2026-07-21T20:49:55.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/6be6846595bf80a0bd1b05648caa125c8e04b8f0e34dac0950db219d60137cf4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.5.3", "os": "win", "version": "0.1.2.9000", "date": "2026-07-21T20:49:38.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/848422cae00a29a08a39231a3bb17766183b2d4e496884134d608163112b2738", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" }, { "r": "4.6.1", "os": "win", "version": "0.1.2.9000", "date": "2026-07-21T20:49:44.000Z", "commit": "f1a9ef2e94fe522cfd85f16de0e8ee50761fa33f", "fileid": "https://r2.ropensci.org/1d7d9e2c5f517163d2105d0ca9b9be83bc5f9850920502d2e17dd115602012b7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/noamross/actions/runs/29867070287" } ] }