Alteryx - RedCap API

[SYang1]

Is the flow correct to access REDCAP through API? Works in R, Python, but can't figure it out in alteryx.

I am getting http:1.1 403 Forbidden error.  The API Key is correct.  

I'm not sure for the HTTP Action if it is post, get (FTP) or Put or etc....And also not sure the "values from these fields" should be selected.  

[BrandonB]

Hi @SYang1 

I have successfully connected to REDCAP with a few of our customers with an API call using the Download tool.

I can't recall exactly but I am fairly certain it is either a POST or a GET request. Documentation that I am seeing online says that it is a POST request so I would give that a try.

Rather than adding the columns in the Text Input tool, can you instead just hard code them into the download tool to see if you can get it working that way? For the Headers tab, uncheck all of the "And values from these fields" check boxes. In the API playground in REDCAP you should see the CURL example like you can see in my screenshot below. I am pretty sure that REDCAP only really uses the Payload tab for the majority of the values that need to be passed in. 

I have also found that it is easiest to pull REDCAP data as JSON and then use a JSON Parse tool after the download tool to get it into a tabular format. CSV should work as well I just find that JSON is easy to work with from REDCAP. 

https://biostat.wustl.edu/seminars/SDA_API_SeminarBW.pdf