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.