Description | Create a DSN on each client | Note | Create Database | Create user credentials to the auxiliary database | Transfer Credentials | Document Info

Language Agnostic | Server Configuration and Authorization | Reading | Writing | Common Gotchas | R | Reading without a Package | Reading with the REDCapR Package | Reading with the redcapAPI Package | General Information | Troubleshooting Strategies | Resources | Document Info

Part 1 - Pre-requisites | Verify REDCapR is installed | Verify REDCap Access | Review Codebook | Part 2 - Retrieve Protected Token | Security Method 1: Token File | Security Method 2: Token Server | Part 3 - Read Data: Unstructured Approach | Part 4 - Read Data: Choosing Columns and Rows | Specify Record IDs | Specify Row Filter | Specify Column Names | Part 5 - Read Data: Structured Approach | Specify Column Names & Types | Specify Everything is a Character | Part 6 - Next Steps | Other REDCapR Resources | Create an Arch for Reuse | Downstream Reproducible Reports | Batching | Writing to the Server | Notes | Session Information

Next Steps | Set project-wide values | Converting from tall/long to wide | Query the Underlying MySQL Database | SSL Options | Convert SPSS Output to REDCap data dictionary | Session Information

Reading REDCap Data | Set project-wide values | Read all records and fields | Read a subset of the records | Read a subset of the fields | Read a subset of records, conditioned on the values in some variables | Additional Returned Information | Session Information

Background | Illustration of How Data Points are Structured | Possible Table Structures | Table 1: patient grain | Table 2: observation grain for intake instrument | Table 3a: patient-time grain for blood_pressure instrument | Table 3b: patient-time grain for laboratory instrument | Table 4: observation grain for intake, blood_pressure, and laboratory instruments | Table 5: mishmashed grain | Terminology | observation | Retrieving from REDCap | One REDCapR Call for Each Table | Retrieve patient-level table (corresponding to Table 1) | Retrieve patient-time-level tables (corresponding to Tables 3a & 3b) | Retrieve block tables (corresponding to Table 5) | One REDCapTidieR Call for All Tables | Choosing between the Approaches | Escalating to REDCapR | Advanced | Longitudinal | Caching Results to Improve Performance | Caching Results for other Languages | Session Information

Part 1 - Intro | Strategy | Pre-requisites | Retrieve Token | Datasets to Write to Server | Part 2 - Write Data: One row per patient | Prep: Stoplight Fields | Prep: REDCapR::validate_for_write() | Prep: Write Small Subset First | Prep: Recode Variables where Necessary | Write Entire Patient-level Table | Part 3 - Write Data: Repeating Instrument | Add Plumbing Variables | Writing Repeating Instrument Variables | Part 4 - Next Steps | More Complexity | Batching | Manual vs API | REDCap's CDIS | Notes | Session Information

Figure 1: Cartesian Rolling - 2005 Version | Figure 2: Cartesian Rolling - 2014 Version | Individual Components | Figure 4: Cartesian Periodic | Figure 5: Polar Periodic | Figure 6: WATS and Cartesian | Figure 7: County Comparison | Figure 8: Error Band Comparison | Session Info

Install codified Package | Local Data Source | Establish Datasets | Apply Map to Observed Dataset | Conform to NIH Cosmetics | REDCap Data Source | Collapsing Levels | Feedback Welcome | Upcoming Features | Group discussion