Skip to content

This repository contains projects that use APIs like Google Sheets, RedCap, and text services to automate data handling, participant communication, and project updates. It supports automated updates to Google Sheets, data imports/exports in RedCap, and participant reminders for improved project coordination.

Notifications You must be signed in to change notification settings

dzweben/api-data-integration

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 

Repository files navigation

API Data Integration

This repository contains various projects that utilize different research and data science-relevant APIs to improve the efficiency of data science workflows, research coordination, and participant management. By integrating multiple services, it automates and streamlines tasks in ways that significantly enhance project efficiency.

Key Features:

  • Google Sheets API: Automates updates to Google Sheets databases based on RedCap data completion, facilitating seamless data synchronization across platforms.
  • RedCap API: Allows for data analysis directly within RedCap, enabling efficient management of project data and participant information. Includes automated data imports at specific time points to initiate project legs and trigger notifications/alerts within RedCap.
  • Text Service APIs: Automates participant communication, including sending reminders, project updates, and other important messages.

Submodules

This repository includes several submodules. Each submodule is an independent repository that utilizes APIS. A directory to submodules is detailed below:

  • Age Cohort Check APIs: Uses the RedCap API and Google Sheets API, along with Python for CSV editing, to check if participants' assigned record IDs match their ages across the project cohorts. It outputs a CSV file showing any incorrectly assigned participants.

  • (more submodules will be added soon...

About

This repository contains projects that use APIs like Google Sheets, RedCap, and text services to automate data handling, participant communication, and project updates. It supports automated updates to Google Sheets, data imports/exports in RedCap, and participant reminders for improved project coordination.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published