Exporting Form Data

I’m a complete CommCare nube and wonder if anyone provide me with some
advice on retrieving data.

I would like to use the API and it would be useful to:

  • retrieve a list of forms
  • retrieve data for a specific form
  • retrieve data from a specific time / since last download

Is this possible through the API?

It seems that using /form returns all form data (albeit with paging)…and
I see also that you can pass in a form id. Are there any other options
here?

I notice that there are two methods of export mentioned in the
documentation:

  1. The export API (but this has a 10Mb limit)
  2. The commcare-export utility (we’d rather not have to use an external too)

Are these my only options?

Any additional information would be greatly appreciated.

Many thanks

Alan

Hi Alan

The commcare-export tool basically does exactly what you’re asking and uses
the API’s to do it. You can still use the API’s if you want and there is
some documentation available on the wiki:
https://confluence.dimagi.com/display/commcarepublic/List+Forms

You’ll note that you the ‘received_on_start’ and 'received_on_end’
parameters to filter the data since you last did an export.

··· On 14 September 2015 at 17:38, Alan Hill wrote:

I’m a complete CommCare nube and wonder if anyone provide me with some
advice on retrieving data.

I would like to use the API and it would be useful to:

  • retrieve a list of forms
  • retrieve data for a specific form
  • retrieve data from a specific time / since last download

Is this possible through the API?

It seems that using /form returns all form data (albeit with
paging)…and I see also that you can pass in a form id. Are there any
other options here?

I notice that there are two methods of export mentioned in the
documentation:

  1. The export API (but this has a 10Mb limit)
  2. The commcare-export utility (we’d rather not have to use an external
    too)

Are these my only options?

Any additional information would be greatly appreciated.

Many thanks

Alan


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa

Many thanks Simon…I’ll take another look.

··· On Mon, Sep 14, 2015 at 2:52 PM, Simon Kelly wrote:

Hi Alan

The commcare-export tool basically does exactly what you’re asking and
uses the API’s to do it. You can still use the API’s if you want and there
is some documentation available on the wiki:
https://confluence.dimagi.com/display/commcarepublic/List+Forms

You’ll note that you the ‘received_on_start’ and 'received_on_end’
parameters to filter the data since you last did an export.

On 14 September 2015 at 17:38, Alan Hill ahill@2paths.com wrote:

I’m a complete CommCare nube and wonder if anyone provide me with some
advice on retrieving data.

I would like to use the API and it would be useful to:

  • retrieve a list of forms
  • retrieve data for a specific form
  • retrieve data from a specific time / since last download

Is this possible through the API?

It seems that using /form returns all form data (albeit with
paging)…and I see also that you can pass in a form id. Are there any
other options here?

I notice that there are two methods of export mentioned in the
documentation:

  1. The export API (but this has a 10Mb limit)
  2. The commcare-export utility (we’d rather not have to use an external
    too)

Are these my only options?

Any additional information would be greatly appreciated.

Many thanks

Alan


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-developers/f25_2MtrFWE/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.