dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

CSV would be useful though, feel free to open a Jira improvement issue
<https://jira.dhis2.org>.



On Sat, Jan 7, 2017 at 2:36 PM, Ime Asangansi <imeasangansi@xxxxxxxxx>
wrote:

> Thanks so much, Lars and Knut.
> Really appreciate.
>
> Ime
>
>
>
> On 1/6/2017 5:37 PM, Lars Helge Øverland wrote:
>
> 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> wrote:
>
>> 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.js
>>> on?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dim
>>> ension=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;az
>>> RICFoILuh;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.cs
>>> v?dimension=dx:gQNFkFkObU8&dimension=pe:LAST_4_QUARTERS&dime
>>> nsion=ou:jNb63DIHuwU;WAjjFMDJKcx;ZpE2POxvl9P;TSyzvBiovKh;azR
>>> ICFoILuh;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=pB
>>> OMPrpg1QX&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:f
>>>> bfJHSPpUQD&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_193302816757878904_m_1025277346021222905_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
>>>
>>>
>>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>