R and CommCare API

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.



1 Like

Hi Peter,

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

1 Like

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,

Hi Ralph, how do you connect R to the Commcare database ?

I’m very interested.


1 Like

Hi Sylvain, I imagine using the CommCare Export Tool would be the most flexible method, as you’ll need a local copy of the data if you’re running complex queries. This wiki page has an overview of options for data analysis.