Data Feeds Link in CommCare

Dear CommCare users,

I would like to use ZoHo for analysis and reporting. ZoHo allows for one to
report on data from external data sources based on data feed links. Is
there something like that in Commcare, either via JSON or something?

Kind regards,
Chaiwa.

I’m not familiar with Zoho, but we do offer data feeds via our APIs
https://confluence.dimagi.com/display/commcarepublic/CommCare+HQ+APIs
which might be a good starting point. Most of these provide JSON endpoints
to the data in CommCare.

··· On Mon, Jan 26, 2015 at 9:37 AM, Chaiwa Berian wrote:

Dear CommCare users,

I would like to use ZoHo for analysis and reporting. ZoHo allows for one
to report on data from external data sources based on data feed links. Is
there something like that in Commcare, either via JSON or something?

Kind regards,
Chaiwa.


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

Hi Chaiwa,

Did you have success with this?

I spent some time trying to link the Commcare content via the API into Zoho
Reports, but I ultimately couldn’t get it to work. Here are my notes:

Successfully got the data pulling into Postman, a fantastic API tester,
using

https://www.commcarehq.org/a/
https://www.commcarehq.org/a/ss-farms/api/v0.5/form/?xmlns=http://openrosa.org/formdesigner/1A97BE66-138B-44D8-B106-2CB82D19ACA9
[domain] https://www.commcarehq.org/a/[domain]/api/[version]/form/
/api/v0.5/form/?xmlns=XXXXXXXXXXX

and Basic Auth with our account credentials

You can get the ?xmlns=XXXX part by looking at all your forms using:

https://www.commcarehq.org/a/[domain]/api/[version]/form/

I then tried to use this URL in ZohoReport reports (video here
https://www.youtube.com/watch?v=-uV0LuqTdPc) with the basic auth and got
this error message:

HTTP Status code (401) thrown while reading the URL contents. Please verify
whether the URL is accessible.

If you have better luck, I’d love to know how you got around this error!

-Eric

··· On Monday, January 26, 2015 at 10:45:36 AM UTC+3, Cory Zue wrote: > > I'm not familiar with Zoho, but we do offer data feeds via our APIs > > which might be a good starting point. Most of these provide JSON endpoints > to the data in CommCare. > > On Mon, Jan 26, 2015 at 9:37 AM, Chaiwa Berian <chaiwa...@gmail.com > wrote: > >> Dear CommCare users, >> >> I would like to use ZoHo for analysis and reporting. ZoHo allows for one >> to report on data from external data sources based on data feed links. Is >> there something like that in Commcare, either via JSON or something? >> >> Kind regards, >> Chaiwa. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi all,

I had a big breakthrough based on feedback from the guys at Zoho reports.
If you are looking for a reasonably priced, easy-to-use dashboarding add-on
to Commcare, I think this might be it (and I’ve been looking for at least 6
months).

Here are the suggestions for integration from the Zoho guy:

Hi,

Greetings from Zoho Report!

Sorry for the inconvenience caused. Currently Zoho Reports supports only
Basic authentication while importing data from a Web data source protected
by a password. Since the data feed URL you have tried has Digest
authentication, you were receiving Error 401. We have generated an
authentication key using which you can import the data.

In the data Import wizard, please follow the below steps,

· Select the file type as JSON from the File Type drop down box

· Choose the Data location as Web and enter the API URL

· Expand the Add parameter option available

· Type the parameter name as ‘Authorization’

· Enter this key ‘redacted’ in the Value text box

· Select the Send Request option as Header from the drop down box

· Click Next

··· On Mon, Oct 19, 2015 at 9:44 AM, Eric Couper wrote:

Hi Chaiwa,

Did you have success with this?

I spent some time trying to link the Commcare content via the API into
Zoho Reports, but I ultimately couldn’t get it to work. Here are my notes:

Successfully got the data pulling into Postman, a fantastic API tester,
using

https://www.commcarehq.org/a/
https://www.commcarehq.org/a/ss-farms/api/v0.5/form/?xmlns=http://openrosa.org/formdesigner/1A97BE66-138B-44D8-B106-2CB82D19ACA9
[domain]
https://www.commcarehq.org/a/[domain]/api/[version]/form/
/api/v0.5/form/?xmlns=XXXXXXXXXXX

and Basic Auth with our account credentials

You can get the ?xmlns=XXXX part by looking at all your forms using:

https://www.commcarehq.org/a/[domain]/api/[version]/form/

I then tried to use this URL in ZohoReport reports (video here
https://www.youtube.com/watch?v=-uV0LuqTdPc) with the basic auth and
got this error message:

HTTP Status code (401) thrown while reading the URL contents. Please
verify whether the URL is accessible.

If you have better luck, I’d love to know how you got around this error!

-Eric

On Monday, January 26, 2015 at 10:45:36 AM UTC+3, Cory Zue wrote:

I’m not familiar with Zoho, but we do offer data feeds via our APIs
https://confluence.dimagi.com/display/commcarepublic/CommCare+HQ+APIs
which might be a good starting point. Most of these provide JSON endpoints
to the data in CommCare.

On Mon, Jan 26, 2015 at 9:37 AM, Chaiwa Berian chaiwa...@gmail.com wrote:

Dear CommCare users,

I would like to use ZoHo for analysis and reporting. ZoHo allows for one
to report on data from external data sources based on data feed links. Is
there something like that in Commcare, either via JSON or something?

Kind regards,
Chaiwa.


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


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


Eric A. Couper
m. +1 504 478 9954
e. eric.couper@gmail.com
w. www.ericcouper.com
t. @_couper https://twitter.com/_couper

Hi Eric,

Thanks for the suggestion and great information about Zoho!

This is something we will discuss internally, and can update you with any
changes.
In the meantime, I would encourage you to submit this as an idea on our
uservoice forum to gain support from other CommCare users:
http://dimagi.uservoice.com/

Let me know if you have any other questions.

Thanks,
Robin Selwitz

··· On Mon, Oct 19, 2015 at 3:08 PM, Eric Couper wrote:

Hi all,

I had a big breakthrough based on feedback from the guys at Zoho reports.
If you are looking for a reasonably priced, easy-to-use dashboarding add-on
to Commcare, I think this might be it (and I’ve been looking for at least 6
months).

Here are the suggestions for integration from the Zoho guy:

Hi,

Greetings from Zoho Report!

Sorry for the inconvenience caused. Currently Zoho Reports supports only
Basic authentication while importing data from a Web data source protected
by a password. Since the data feed URL you have tried has Digest
authentication, you were receiving Error 401. We have generated an
authentication key using which you can import the data.

In the data Import wizard, please follow the below steps,

· Select the file type as JSON from the File Type drop down box

· Choose the Data location as Web and enter the API URL

· Expand the Add parameter option available

· Type the parameter name as ‘Authorization’

· Enter this key ‘redacted’ in the Value text box

· Select the Send Request option as Header from the drop down box

· Click Next

On Mon, Oct 19, 2015 at 9:44 AM, Eric Couper eric.couper@gmail.com wrote:

Hi Chaiwa,

Did you have success with this?

I spent some time trying to link the Commcare content via the API into
Zoho Reports, but I ultimately couldn’t get it to work. Here are my notes:

Successfully got the data pulling into Postman, a fantastic API tester,
using

https://www.commcarehq.org/a/
https://www.commcarehq.org/a/ss-farms/api/v0.5/form/?xmlns=http://openrosa.org/formdesigner/1A97BE66-138B-44D8-B106-2CB82D19ACA9
[domain]
https://www.commcarehq.org/a/[domain]/api/[version]/form/
/api/v0.5/form/?xmlns=XXXXXXXXXXX

and Basic Auth with our account credentials

You can get the ?xmlns=XXXX part by looking at all your forms using:

https://www.commcarehq.org/a/[domain]/api/[version]/form/

I then tried to use this URL in ZohoReport reports (video here
https://www.youtube.com/watch?v=-uV0LuqTdPc) with the basic auth and
got this error message:

HTTP Status code (401) thrown while reading the URL contents. Please
verify whether the URL is accessible.

If you have better luck, I’d love to know how you got around this error!

-Eric

On Monday, January 26, 2015 at 10:45:36 AM UTC+3, Cory Zue wrote:

I’m not familiar with Zoho, but we do offer data feeds via our APIs
https://confluence.dimagi.com/display/commcarepublic/CommCare+HQ+APIs
which might be a good starting point. Most of these provide JSON endpoints
to the data in CommCare.

On Mon, Jan 26, 2015 at 9:37 AM, Chaiwa Berian chaiwa...@gmail.com wrote:

Dear CommCare users,

I would like to use ZoHo for analysis and reporting. ZoHo allows for
one to report on data from external data sources based on data feed links.
Is there something like that in Commcare, either via JSON or something?

Kind regards,
Chaiwa.


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


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


Eric A. Couper
m. +1 504 478 9954
e. eric.couper@gmail.com
w. www.ericcouper.com
t. @_couper https://twitter.com/_couper


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