Querying ODK Aggregate's json data from outside application

Hello,

This is Minoru Nakano from Hatfield Consultants based in Vancouver,
Canada.

We have been working with ODK in one of our projects, and would like to
ask a technical question on one of the problems we are working on.

We are trying to query ODK Aggregate on Google App Engine from external
asp.net project to obtain json data of the survey responses.

So far we could figure out that normally when ODK Aggregate exports a json
file, the application generates a json file containing all the survey
response data by obtaining json data with the following request URL:
https://hatfield-odk-test.appspot.com/aggregateui/submissionservice.

We believe that submissionservice is the function to be used to achieve
this result. We have tried to access the json data by sending http POST
request with the URL above but has not been successful.

Is there any way to resolve this issue and query the json data from ODK
Aggregate?

Thank you and looking forward to hearing from you soon,

Minoru Nakano, B.Sc.| Environmental Information Systems Specialist

Hatfield Consultants | http://www.hatfieldgroup.com
www.hatfieldgroup.com

200-850 Harbourside Drive, North Vancouver, BC, Canada V7P 0A3

Tel: 604.926.3261 | Fax: 604.926.5389 |
mailto:mnakano@hatfieldgroup.com mnakano@hatfieldgroup.com

Hi Minoru,

What version of Aggregate are you using? Any reason why you can't
stream that data to your server using the JSON publisher (See
https://code.google.com/p/opendatakit/wiki/AggregateToJSonXmlREDCapPublishers)?

Yaw

··· -- Need ODK services? Go to http://nafundi.com for form design, data cleaning, custom reporting, and software development for ODK.

On Tue, Jul 16, 2013 at 11:29 AM, Minoru Nakano mnakano@hatfieldgroup.com wrote:

Hello,

This is Minoru Nakano from Hatfield Consultants based in Vancouver, Canada.

We have been working with ODK in one of our projects, and would like to ask
a technical question on one of the problems we are working on.

We are trying to query ODK Aggregate on Google App Engine from external
asp.net project to obtain json data of the survey responses.

So far we could figure out that normally when ODK Aggregate exports a json
file, the application generates a json file containing all the survey
response data by obtaining json data with the following request URL:
https://hatfield-odk-test.appspot.com/aggregateui/submissionservice.

We believe that submissionservice is the function to be used to achieve this
result. We have tried to access the json data by sending http POST request
with the URL above but has not been successful.

Is there any way to resolve this issue and query the json data from ODK
Aggregate?

Thank you and looking forward to hearing from you soon,

Minoru Nakano, B.Sc.| Environmental Information Systems Specialist

Hatfield Consultants | www.hatfieldgroup.com

200-850 Harbourside Drive, North Vancouver, BC, Canada V7P 0A3

Tel: 604.926.3261 | Fax: 604.926.5389 | mnakano@hatfieldgroup.com

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

Hello all, Minoru I have to do the same task in Asp .Net , do you have now some code you want to share?

Hi Yaw,

Thanks for the advise on using json publisher.

By using this, could we also get lets say the list of forms that we have uploaded onto Aggregate?
If it's possible, how exactly could this be done?

Thank you,

Minoru

Our developer site is here: http://code.google.com/p/opendatakit/

All our source code is on that site.

There is no JSON interface for accessing data. The API you are attempting
to use is Google's GWT API to the server, which may change at any time, and
is NOT suitable for use as an integration point with the server.We can
provide no support or guidance on its use, as it is an internal interface
for GWT functionality, and, should we upgrade to a newer GWT release (e.g.,
2.6?), we fully expect it to change.

There is, however, an XML interface.

For accessing form definitions and submitting filled-in forms, we implement
the OpenRosa API https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaAPI

For downloading submissions (as XML), we provide a custom interface. This
interface is used by ODK Briefcase to access and download (reconstructed)
submission files. These interfaces are described here:
http://code.google.com/p/opendatakit/wiki/BriefcaseAggregateAPI

Mitch

··· On Tue, Jul 16, 2013 at 12:09 PM, wrote:

Hi Yaw,

Thanks for the advise on using json publisher.

By using this, could we also get lets say the list of forms that we have
uploaded onto Aggregate?
If it's possible, how exactly could this be done?

Thank you,

Minoru

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

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com