← Back to team overview

dhis2-devs team mailing list archive

Re: CSV-JSON

 

Not sure...I think you could  report it as a Jira issue.

On Jan 6, 2017 2:43 PM, "Ime Asangansi" <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
>
> 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
>
> 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
>
>
> On Fri, Jan 6, 2017 at 11:50 AM, Knut Staring <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
>>
>> Knut
>>
>> On Fri, Jan 6, 2017 at 7:11 AM, Ime Asangansi <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
>>>
>>> But I tried it and I get a returned "status Code: 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
>>>
>>> --
>>> [image: 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
>>> ime@xxxxxxxxxxxxxxxxxxxx
>>> Skype: asangansiime
>>> <#m_3358300012291163682_m_6862927987993447394_m_-2331909708527845880_>
>>> www.ehealth4everyone.com
>>> <https://twitter.com/ehealth4every1>
>>> <https://ng.linkedin.com/in/asangansi>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522 <+47%20918%2080%20522>
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>
>
>

Follow ups

References