← Back to team overview

dhis2-devs team mailing list archive

Re: CSV-JSON

 

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 <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_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
Skype: knutstar
http://dhis2.org


Follow ups

References