update_records {rairtable}

Update Airtable records

Description

Update one or more columns of data in an Airtable table. Supports batch updates and parallel JSON encoding (recommended for large tables).

Usage

update_records(
  data,
  airtable,
  columns = dplyr::everything(),
  airtable_id_col = "airtable_record_id",
  safely = TRUE,
  parallel = FALSE,
  batch_size = 10
)

Arguments

data

A dataframe containing the records and fields to update

airtable

An airtable object

columns

Columns in the data to update on Airtable. Can be a vector of character strings, unquoted column names, or a dplyr tidyselect helper like starts_with(), ends_with() or everything(). Defaults to dplyr::everything()

airtable_id_col

Column containing Airtable record IDs. Not required if record IDs are stored in row names as returned from read_airtable

safely

If TRUE, confirm number and names of columns to update and number of rows before executing update.

parallel

If TRUE use parallel processing for encoding large tables

batch_size

Number of records to update per request. Maximum of 10

Value

A dataframe (invisibly) of the input data, to be stored as an object or piped into further 'dplyr' functions