R and CommCare API

Users
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

1 Like
2

Hi Peter,

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

1 Like
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

4

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

I'm very interested.

Best,
Sylvain

1 Like
5

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.