Import records into REDCap using API and Alteryx

[lamiah13]

Hi everyone,

I have a large group of records ~20,000 that I need to import into my REDCap project. I would like to utilize the API playground and function in REDCap and make the connection via Alteryx since all my data has been cleaned and prepared in there. Has anyone done this in REDCap before and had success? Any tips/pointers would be really helpful!

Some questions I am running into include the import template I have set up in my REDCap project - does the data need to look like this format before it can be imported into REDCap? Can I feed the download tool in Alteryx with something besides the input text tool?

Thank you! 

[Thableaus]

Hey @lamiah13 I'm not familiar with REDCap but have you taken a look at the documentation for this API?

If you're able to build a POST/PUT request I imagine this can be done with the download tool.

Cheers,