R and CommCare API


(Peter MacPherson) #1

Does anyone have any experience of accessing data collected by CommCare app through the API using R?

Very grateful for any suggestions, instructions, or guidance.

Thanks,

Peter


(Myers) #2

Hi Peter,

I do! Let me know if this is still something you need help with.


(Peter MacPherson) #3

Thanks Ralph, much appreciated.

My currently workflow is to use the CommCare Export tool in Mac Terminal, with export fields specified in an Excel spreadsheet to update a local SQLite database. I then use the R DBI package to import tables into R for analysis… not the most efficient system!

If you have any suggestions for optimising this, I would be very grateful.

Kind regards,
Peter