Attempting to retrieve data in ADX format

Hi,

I’m playing around with retrieving data in ADX format. I’ve been looking at the documentation here:

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s16.html#d0e3574

I’ve been unable to retrieve any actual data - I can only receive an empty adx tag.

Here are some examples from play.dhis2.com:

Doing a straight GET using UIDs with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit= jNb63DIHuwU&dataSet=ULowA8V3ucd&startDate=2015-01-01&endDate=2015-12-31

will return data values. EG:

{

“dataValues”: [

{

“dataElement”: “JIazHXNSnFJ”,

“period”: “201501”,

However, doing a GET using Codes and adding the “Accept: application/xml+adx” in the header with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit=OU_573&dataSet=DS_1153709&startDate=2015-01-01&endDate=2015-12-31

only returns this empty tag:

<adx

xmlns=“urn:ihe:qrph:adx:2015”/>

Is there something I’m doing wrong here? How can I get the data in this example returned in ADX format?

Thanks,

Lorill

Hi Lorill,

thanks for bringing this up. I had a look and the problem was that the demo database misses codes for most categories. Seems ADX requires codes to be present also for categories and category options which are associated with data elements in the data set.

The other problem was that the ADX code swallowed the exception instead of returning it through the API. I have done a fix now in trunk and 2.23 for this where 409 and a message is returned. I am now getting this:

{“httpStatus”:“Conflict”,“httpStatusCode”:409,“status”:“ERROR”,“message”:“Category code for Commodities is missing or invalid: null”}

So to fix this, I suggest you upgrade to latest 2.23 and make sure that codes are present also for categories and category options in you local system.

Thanks for reporting and for reproducing on the demo.

best regards,

Lars

···

On Wed, Apr 27, 2016 at 11:49 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

I’m playing around with retrieving data in ADX format. I’ve been looking at the documentation here:

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s16.html#d0e3574

I’ve been unable to retrieve any actual data - I can only receive an empty adx tag.

Here are some examples from play.dhis2.com:

Doing a straight GET using UIDs with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit= jNb63DIHuwU&dataSet=ULowA8V3ucd&startDate=2015-01-01&endDate=2015-12-31

will return data values. EG:

{

“dataValues”: [

{

“dataElement”: “JIazHXNSnFJ”,

“period”: “201501”,

However, doing a GET using Codes and adding the “Accept: application/xml+adx” in the header with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit=OU_573&dataSet=DS_1153709&startDate=2015-01-01&endDate=2015-12-31

only returns this empty tag:

<adx

xmlns=“urn:ihe:qrph:adx:2015”/>

Is there something I’m doing wrong here? How can I get the data in this example returned in ADX format?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks for this Lars. I will try it out again.

···

On Thu, Apr 28, 2016 at 1:32 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

thanks for bringing this up. I had a look and the problem was that the demo database misses codes for most categories. Seems ADX requires codes to be present also for categories and category options which are associated with data elements in the data set.

The other problem was that the ADX code swallowed the exception instead of returning it through the API. I have done a fix now in trunk and 2.23 for this where 409 and a message is returned. I am now getting this:

{“httpStatus”:“Conflict”,“httpStatusCode”:409,“status”:“ERROR”,“message”:“Category code for Commodities is missing or invalid: null”}

So to fix this, I suggest you upgrade to latest 2.23 and make sure that codes are present also for categories and category options in you local system.

Thanks for reporting and for reproducing on the demo.

best regards,

Lars

On Wed, Apr 27, 2016 at 11:49 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

I’m playing around with retrieving data in ADX format. I’ve been looking at the documentation here:

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s16.html#d0e3574

I’ve been unable to retrieve any actual data - I can only receive an empty adx tag.

Here are some examples from play.dhis2.com:

Doing a straight GET using UIDs with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit= jNb63DIHuwU&dataSet=ULowA8V3ucd&startDate=2015-01-01&endDate=2015-12-31

will return data values. EG:

{

“dataValues”: [

{

“dataElement”: “JIazHXNSnFJ”,

“period”: “201501”,

However, doing a GET using Codes and adding the “Accept: application/xml+adx” in the header with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit=OU_573&dataSet=DS_1153709&startDate=2015-01-01&endDate=2015-12-31

only returns this empty tag:

<adx

xmlns=“urn:ihe:qrph:adx:2015”/>

Is there something I’m doing wrong here? How can I get the data in this example returned in ADX format?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Would it be possible to get codes added to the demo system?

Cheers,

-carl

···

On Wed, Apr 27, 2016 at 11:49 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

I’m playing around with retrieving data in ADX format. I’ve been looking at the documentation here:

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s16.html#d0e3574

I’ve been unable to retrieve any actual data - I can only receive an empty adx tag.

Here are some examples from play.dhis2.com:

Doing a straight GET using UIDs with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit= jNb63DIHuwU&dataSet=ULowA8V3ucd&startDate=2015-01-01&endDate=2015-12-31

will return data values. EG:

{

“dataValues”: [

{

“dataElement”: “JIazHXNSnFJ”,

“period”: “201501”,

However, doing a GET using Codes and adding the “Accept: application/xml+adx” in the header with this URL:

https://play.dhis2.org/demo/api/dataValueSets?orgUnit=OU_573&dataSet=DS_1153709&startDate=2015-01-01&endDate=2015-12-31

only returns this empty tag:

<adx

xmlns=“urn:ihe:qrph:adx:2015”/>

Is there something I’m doing wrong here? How can I get the data in this example returned in ADX format?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org