I work in HealthCare and am developing a report. The events are recorded in a survey site we use [redcap], exported to excel and then uploaded to qlikview. This whole process is manual and laborious. So, is there any way we can directly connect to RedCap tool using QlikView and export data directly into qlikview. I have tried using QlikREST connector, but no luck. Any help would be appreciated.
Connecting to REDCap APIs with Qlik Sense REST Connector:
The connection was simple but it did require one little feature that wasn’t super-obvious...
Basically, you have to add theQuery Headercircled in red below – not sure if it has to be the value below or not but I do know that ‘application/x-www-form-urlencoded’ works.
As for the other data, the actual API parameters are in theRequest Bodyin the format you see below (no quotes or spaces, equal symbol between api parameter and its value, ampersands between the key-value pairs). The token does need to be added the string below for it to work.
REDCap is a secure web application for building and managing online surveys and databases. While REDCap can be used to collect virtually any type of data (including 21 CFR Part 11, FISMA, and HIPAA-compliant environments), it is specifically geared to support online or offline data capture for research studies and operations. The REDCap Consortium, a vast support network of collaborators, is composed of thousands of active institutional partners in over one hundred countries who utilize and support REDCap in various ways.