redcapAPI: Analysis-ready data retrieval from REDCap with advanced processing capabilities in R
Presenting author: Savannah Obregon, Department of Biostatistics, Vanderbilt University Medical Center
- Shawn Garbett, Department of Biostatistics, Vanderbilt University Medical Center
- Benjamin Nutter, Battelle
To help support clinical trials, we have developed a data processing layer within the redcapAPI R package. This layer aims to streamline data management and analysis processes, enhancing the efficiency and effectiveness of clinical trial research. REDCap is a secure web platform for building and managing online databases and surveys. REDCap simplifies the project creation and design process by offering a range of tools that can be adapted to various data collection strategies. R supports reproducible research through its scripting capabilities, integration with R Markdown for dynamic reporting, package management, and features for controlling elements of analysis, enabling users to document and share their code, data, and analysis steps for independent verification and replication. Originally designed to export the raw API data from REDCap into the R environment, redcapAPI has evolved to incorporate a robust data processing layer. With complete control over data typing, intelligent defaults, efficient parsing of forms, and enhanced connection with retry strategies, the package ensures reliable and automated retrieval of REDCap data in a ready-to-analyze format. Additionally, cryptographic storage of API keys and streamlined API calls contribute to a powerful toolset for seamlessly transforming raw REDCap data into analysis-ready format.