This function uses REDCap's API to select and return data. This function is still in development.
redcap_read_oneshot_eav(
redcap_uri,
token,
records = NULL,
records_collapsed = "",
fields = NULL,
fields_collapsed = "",
forms = NULL,
forms_collapsed = "",
events = NULL,
events_collapsed = "",
raw_or_label = "raw",
raw_or_label_headers = "raw",
export_data_access_groups = FALSE,
filter_logic = "",
datetime_range_begin = as.POSIXct(NA),
datetime_range_end = as.POSIXct(NA),
verbose = TRUE,
config_options = NULL
)Currently, a list is returned with the following elements:
data: An R base::data.frame() of the desired records and columns.
success: A boolean value indicating if the operation was apparently
successful.
status_code: The
http status code
of the operation.
outcome_message: A human readable string indicating the operation's
outcome.
records_collapsed: The desired records IDs, collapsed into a single
string, separated by commas.
fields_collapsed: The desired field names, collapsed into a single
string, separated by commas.
filter_logic: The filter statement passed as an argument.
elapsed_seconds: The duration of the function.
raw_text: If an operation is NOT successful, the text returned by
REDCap. If an operation is successful, the raw_text is returned as an
empty string to save RAM.
The URI (uniform resource identifier) of the REDCap project. Required.
The user-specific string that serves as the password for a project. Required.
An array, where each element corresponds to the ID of a desired record. Optional.
A single string, where the desired ID values are separated by commas. Optional.
An array, where each element corresponds to a desired project field. Optional.
A single string, where the desired field names are separated by commas. Optional.
An array, where each element corresponds to a desired project field. Optional.
A single string, where the desired form names are separated by commas. Optional.
An array, where each element corresponds to a desired project event. Optional.
A single string, where the desired event names are separated by commas. Optional.
A string (either 'raw' or 'label' that specifies
whether to export the raw coded values or the labels for the options of
multiple choice fields. Default is 'raw'.
A string (either 'raw' or 'label' that
specifies for the CSV headers whether to export the variable/field names
(raw) or the field labels (label). Default is 'raw'.
A boolean value that specifies whether or
not to export the redcap_data_access_group field when data access groups
are utilized in the project. Default is FALSE. See the details below.
String of logic text (e.g., [gender] = 'male') for
filtering the data to be returned by this API method, in which the API
will only return the records (or record-events, if a longitudinal project)
where the logic evaluates as TRUE. An blank/empty string returns all
records.
To return only records that have been created or modified after a given datetime, provide a POSIXct (https://stat.ethz.ch/R-manual/R-devel/library/base/html/as.POSIXlt.html) value. If not specified, REDCap will assume no begin time.
To return only records that have been created or modified before a given datetime, provide a POSIXct (https://stat.ethz.ch/R-manual/R-devel/library/base/html/as.POSIXlt.html) value. If not specified, REDCap will assume no end time.
A boolean value indicating if messages should be printed
to the R console during the operation. The verbose output might contain
sensitive information (e.g. PHI), so turn this off if the output might
be visible somewhere public. Optional.
A list of options to pass to POST method in the
httr package. See the details below. Optional.
Will Beasley
The full list of configuration options accepted by the httr package is
viewable by executing httr::httr_options(). The httr
package and documentation is available at
https://cran.r-project.org/package=httr.
If you do not pass in this export_data_access_groups value, it will
default to FALSE. The following is from the API help page for version
5.2.3:
This flag is only viable if the user whose token is being used to make
the API request is not in a data access group. If the user is in a
group, then this flag will revert to its default value.
As of REDCap 6.14.3, this field is not exported in the EAV API call.
The official documentation can be found on the 'API Help Page' and 'API Examples' pages on the REDCap wiki (i.e., https://community.projectredcap.org/articles/456/api-documentation.html and https://community.projectredcap.org/articles/462/api-examples.html). If you do not have an account for the wiki, please ask your campus REDCap administrator to send you the static material.
if (FALSE) {
uri <- "https://bbmc.ouhsc.edu/redcap/api/"
token <- "9A81268476645C4E5F03428B8AC3AA7B"
#Return all records and all variables.
ds <- REDCapR:::redcap_read_oneshot_eav(redcap_uri=uri, token=token)$data
#Return only records with IDs of 1 and 3
desired_records_v1 <- c(1, 3)
ds_some_rows_v1 <- REDCapR::redcap_read_oneshot_eav(
redcap_uri = uri,
token = token,
records = desired_records_v1
)$data
#Return only the fields record_id, name_first, and age
desired_fields_v1 <- c("record_id", "name_first", "age")
ds_some_fields_v1 <- redcap_read_oneshot_eav(
redcap_uri = uri,
token = token,
fields = desired_fields_v1
)$data
}
Run the code above in your browser using DataLab