Automating the Integration of Longitudinal Clinical Trial Data Using REDCap.

Efficient data exchange is crucial for accelerating clinical research and reducing duplicative efforts. Inconsistencies in field names and coded values (e.g., male = 1, female = 0) across CSV files hinder interoperability and reuse for secondary analyses. We successfully integrated the multicenter, longitudinal Depression DC clinical trial data into REDCap using the API, by metadata driven R workflow for automated data integration.