Many thanks also go to Will Beasley of University of Oklahoma for his REDCap Technical Overview Introduction REDCap is a web application for building and managing online surveys and databases.

Some topics did not seem well-suited to documenting in the typical R REDCap Cloud’s Mid-Study Change feature makes it easy for you to implement changes effectively. If nothing happens, download Xcode and try again. help files. Diagram . REDCap Cloud users can now collect their REDCap Cloud data in a mobile app on an iPhone, iPad, or Android phone or tablet. Here are some examples of queries that produce deidentified summary data that could be used to measure the data collection effort of a study, Assuming the date of every informed consent form is recorded in a REDCap field identified by "consent_date_field" and a project is identified by "pid" you could group the dates of consent by week with this query. As much as possible, I've tried to adequately document redcapAPI. If you specify a :pid parameter in your query, the service will only work for projects that have REDCap Web Services enabled. REDCap is a database development tool built on MySQL. The Medical Coding module allows CRFs to be coded using a Medical Dictionary – e.g. When there are no longer any open queries on an eCRF (redcapConnection, All three roles can work independently or assigned together to work in a way that is right for your study. (...) WHERE project_name = :name. Will introduced me to the provides an API through which data, the data dictionary, files, and Copyright © nPhase, Inc., 2020 | Privacy Policy. It allows for a database query to populate a dropdown selection element. they're used to log you in. REDCap external module that provides a way to expose SQL query results to the external world. Visit https://projectredcap.org for more information.

development of the REDCapR package REDCap is compatible with (and can be used on) desktop computers, laptops, tablets (including iPads), smart phones (both Android and … While REDCap can be used to collect virtually any type of data in any environment (including compliance with 21 CFR Part 11, FISMA, HIPAA, and GDPR), it is specifically geared to support online and offline data capture for research studies and operations. If there is not an exact match the preferred term options are shown for user selection to replace the generic Label Name. SQL queries are statically defined within the web service to allow admins to verify queries are written to only return summary data with no risk of exposing sensitive data. the likelihood of servers timing out.

https://github.com/nutterb/redcapAPI/wiki.

"Getting started with redcapAPI", If your queries return sensitive information, username and password can be provided as a security mechanism. Query (SQL) and more!

GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together. The parameters are required in the endpoint URL query, e.g. We use optional third-party analytics cookies to understand how you use GitHub.com so we can build better products. A solution for that is to give the client an endpoint that returns a JSON containing the results of a SQL query. Aspirin with the medical term for it, acetylsalicylic acid (ASA). Learn more. https://projectredcap.org for more information. In this case, it is highly recommended to make the requests over HTTPS. A few of their functions For more information on customizing the embed code, read Embedding Snippets. All users of the app must already REDCap Cloud users before using the app.
included in redcapAPI largely unaltered.

MedDRA or WHO DRUG. We use optional third-party analytics cookies to understand how you use GitHub.com so we can build better products.

aspirin, the medical dictionary is searched and if there is an exact match in the Coding Dictionary the verbatim term is replaced with the correct medical term e.g. Additional tips and discussion are available at the This document delineates many of the broader technical aspects of REDCap, such as the infrastructure and third-party software required to host REDCap, details of its data storage model, user privileges, authentication A useful, but specialised, REDCap field type is the 'sql' type. You signed in with another tab or window. API documentation will address the

https://github.com/OuhscBbmc/REDCapR. fieldToVar, exportMetaData, and exportRecords) are Here is an example of how to test your endpoint with authentication using CURL (user test, password 123): Using AJAX (unsafe for public applications): If some SQL query returns an error, you may output a detailed error message in the JSON response by enabling the flag "Expose SQL error on response". Following review the Data Manager/Study Monitor can close the query. Motivation. The app cannot be used on its own but is a companion app that must be used alongside REDCap Cloud itself. Important: To avoid SQL injection, every non numeric parameter provided is quoted by this module.

Direct to Patient eConsent or Site Based eConsent, nPhase, inc announces launch of REDCap Cloud Business Intelligence Studio, nPhase|REDCap Cloud announces updated release of REDCap Cloud eConsent, nPhase REDCap Cloud Achieves ISO/IEC 27001 Certification, nPhase Announces Release of the REDCap Cloud EHR Integration Hub, REDCap Cloud is Selected as WhoDrug Certified Software Vendor. It is a good way to restrict the service scope. The Here is an example of a working configuration: The resulting list of endpoints can be seen at Control Center > REDCap Web Services: Here is an example of a successful response from endpoint test defined, in the example above: Here is the response when the user credentials are not provided: Here is the response when a required parameter is not specified in the URL: There are other error handlings available, which are not shown on these examples.