Hi Ime,
CSV is simply not supported. Please see the docs:
https://ci.dhis2.org/docs/master/en/developer/html/webapi_analytics.html#webapi_analytics_data_value_set_format
You can retrieve data in the raw data value set format from the
dataValueSet resource:
/api/26/analytics/dataValueSet
The following resource representations are supported:
*
json (application/json)
*
xml (application/xml)
best regards,
Lars
On Fri, Jan 6, 2017 at 5:26 PM, Knut Staring <knutst@xxxxxxxxx
<mailto:knutst@xxxxxxxxx>> wrote:
Not sure...I think you could report it as a Jira issue.
On Jan 6, 2017 2:43 PM, "Ime Asangansi" <imeasangansi@xxxxxxxxx
<mailto:imeasangansi@xxxxxxxxx>> wrote:
Thanks so much, Knut! Really appreciate your very quick reply!
Your examples work, but for some reason, I still face the
problem I was having.
I can replicate the problem on the demo server. Please see the
following:
This json below works:
https://play.dhis2.org/demo/api/25/analytics/dataValueSet.json?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dimension=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;azRICFoILuh;Umh4HKqqFp6;RzgSFJ9E46G;egv5Es0QlQP;pMEnu7BjqMz;EuoA3Crpqts;KfUCAQoOIae;bG0PlyD0iP3;AnXoUM1tfNT;nX05QLraDhO;LEVEL-4&displayProperty=NAME
<https://play.dhis2.org/demo/api/25/analytics/dataValueSet.json?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dimension=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;azRICFoILuh;Umh4HKqqFp6;RzgSFJ9E46G;egv5Es0QlQP;pMEnu7BjqMz;EuoA3Crpqts;KfUCAQoOIae;bG0PlyD0iP3;AnXoUM1tfNT;nX05QLraDhO;LEVEL-4&displayProperty=NAME>
But when you switch to CSV, it gives the 404, as I had
discussed in my initial mail.
https://play.dhis2.org/demo/api/25/analytics/dataValueSet.csv?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dimension=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;azRICFoILuh;Umh4HKqqFp6;RzgSFJ9E46G;egv5Es0QlQP;pMEnu7BjqMz;EuoA3Crpqts;KfUCAQoOIae;bG0PlyD0iP3;AnXoUM1tfNT;nX05QLraDhO;LEVEL-4&displayProperty=NAME
<https://play.dhis2.org/demo/api/25/analytics/dataValueSet.csv?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dimension=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;azRICFoILuh;Umh4HKqqFp6;RzgSFJ9E46G;egv5Es0QlQP;pMEnu7BjqMz;EuoA3Crpqts;KfUCAQoOIae;bG0PlyD0iP3;AnXoUM1tfNT;nX05QLraDhO;LEVEL-4&displayProperty=NAME>
As discussed earlier, XML response type works, but JSONP and
CSV do not.
Really appreciate any help or clarification.
Takk!
Ime
Abuja
On 1/6/2017 12:03 PM, Knut Staring wrote:
If you want to use DataValueSet, you should use that endpoint:
https://play.dhis2.org/demo/api/dataValueSets.csv?dataSet=pBOMPrpg1QX&orgUnit=DiszpKrYNg8&period=201602
<https://play.dhis2.org/demo/api/dataValueSets.csv?dataSet=pBOMPrpg1QX&orgUnit=DiszpKrYNg8&period=201602>
On Fri, Jan 6, 2017 at 11:50 AM, Knut Staring
<knutst@xxxxxxxxx <mailto:knutst@xxxxxxxxx>> wrote:
Hi Ime,
This seems to work fine:
https://play.dhis2.org/demo/api/analytics.csv?dimension=dx:fbfJHSPpUQD&dimension=pe:2016&dimension=ou:O6uvpzGd5pu;lc3eMKXaEfw
<https://play.dhis2.org/demo/api/analytics.csv?dimension=dx:fbfJHSPpUQD&dimension=pe:2016&dimension=ou:O6uvpzGd5pu;lc3eMKXaEfw>
Knut
On Fri, Jan 6, 2017 at 7:11 AM, Ime Asangansi
<imeasangansi@xxxxxxxxx <mailto:imeasangansi@xxxxxxxxx>>
wrote:
Good day friends,
I'm a web-api newbie here, in need a kind and quick
clarification concerning response formats.
I'm trying to programmatically retrieve some data
using CSV
Am I right to assume this?
for any data I can get in JSON format through
api/analytics/dataValueSet.json?dimension=...
I can get the equivalent through
api/analytics/dataValueSet.csv?dimension=...
I'm trying to switch our programmatic access to
analytics to CSV, and want to know if this is the
expected result as the manual says in
https://ci.dhis2.org/docs/2.23/en/developer/html/ch01s32.html
<https://ci.dhis2.org/docs/2.23/en/developer/html/ch01s32.html>
But I tried it and I get a returned "statusCode: 404
Not Found" for CSV, and JSONP
whereas when I switch json to xml, it just works... Like
api/analytics/dataValueSet.xml?dimension=...
Or does this have to do with some configuration or
the nature of the data?
Thanks so much, in anticipation.
Ime
Abuja
--
photo
<http://twitter.com/imeasangansi>
<http://ng.linkedin.com/company/ehealth4everyone>
<http://twitter.com/ehealth4every1>
Ime Asangansi MD, PhD (Informatics)
Chief Excellence Officer, ehealth4everyone
Abuja, Nigeria
+2348180790150 <tel:+2348180790150>
ime@xxxxxxxxxxxxxxxxxxxx
<mailto:ime@xxxxxxxxxxxxxxxxxxxx>
Skype: asangansiime
<#m_1025277346021222905_m_3358300012291163682_m_6862927987993447394_m_-2331909708527845880_>
www.ehealth4everyone.com
<http://www.ehealth4everyone.com>
<https://twitter.com/ehealth4every1><https://ng.linkedin.com/in/asangansi>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
More help : https://help.launchpad.net/ListHelp
<https://help.launchpad.net/ListHelp>
--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522 <tel:+47%20918%2080%20522>
Skype: knutstar
http://dhis2.org
--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522 <tel:+47%20918%2080%20522>
Skype: knutstar
http://dhis2.org
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
More help : https://help.launchpad.net/ListHelp
<https://help.launchpad.net/ListHelp>
--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx <mailto:lars@xxxxxxxxx>
http://www.dhis2.org <https://www.dhis2.org/>
