Example of using REDCap API for exporting record data and importing into Stata via Python

REDCap_API_to_Stata_via_Pyhton_Example.do

python:
#!/usr/bin/env python
import requests
data = {
    'token': '<PLEASE INSERT API TOKEN HERE>',
    'content': 'record',
    'format': 'csv',
    'type': 'flat',
    'csvDelimiter': '',
    'records[0]': '1',
    'forms[0]': 'contact_information',
    'rawOrLabel': 'raw',
    'rawOrLabelHeaders': 'raw',
    'exportCheckboxLabel': 'false',
    'exportSurveyFields': 'false',
    'exportDataAccessGroups': 'false',
    'returnFormat': 'json'
}

# Send Post Request to Redcap API
r = requests.post('https://redcap-dev.swisstph.ch/redcap/api/',data=data)

# Write request contents into temporary file
f = open("import.csv", "w")
f.write(r.text)
f.close()

end

import delimited import.csv, clear