air_select: Select
In bergant/airtabler: Interface to the Airtable API

Description Usage Arguments Value View Filter by formula Sorting

Select records from table

1
2
3

air_select(base, table_name, record_id = NULL, fields = NULL,
  filterByFormula = NULL, maxRecord = NULL, sort = NULL, view = NULL,
  pageSize = NULL, offset = NULL, combined_result = TRUE)

`base`	Airtable base
`table_name`	Table name
`record_id`	(optional) Use record ID argument to retrieve an existing record details
`fields`	(optional) Only data for fields whose names are in this vector will be included in the records. If you don't need every field, you can use this parameter to reduce the amount of data transferred.
`filterByFormula`	(optional) A formula used to filter records.
`maxRecord`	(optional) The maximum total number of records that will be returned.
`sort`	A list of sort objects that specifies how the records will be ordered.
`view`	(optional) The name or ID of the view defined in the table
`pageSize`	(optional) The number of records returned in each request. Must be less than or equal to 100. Default is 100.
`offset`	(optional) To fetch the next page of records set this argument with a value of offset element from previous response
`combined_result`	If TRUE (default) all data is returned in the same data frame. If FALSE table fields are returned in separate `fields` element.

A data frame with records or a list with record details if record_id is specified.

You can retrieve records in an order of a view by providing the name or ID of the view in the view query parameter. The results will include only records visible in the order they are displayed.

The formula will be evaluated for each record, and if the result is not 0, false, "", NaN, [], or #Error! the record will be included in the response. If combined with view, only records in that view which satisfy the formula will be returned. For example, to only include records where Country isn't empty, pass in: NOT(Country = ”)

Each sort object must have a field key specifying the name of the field to sort on, and an optional direction key that is either "asc" or "desc". The default direction is "asc". For example, to sort records by Country, pass in: list(field = "Country", direction = "desc")

bergant/airtabler documentation built on May 12, 2019, 3:04 p.m.