dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #07993
Re: How to pull data from a remote xml data source (dhis2 web API) into JasperReports
Hi Randy
Do you get any error messages?
I don't know much about Jasper, but some software can work with urls like
https://username:password@URL
--
Morten
On Mon, Aug 31, 2015 at 9:08 PM, Wilson, Randy <rwilson@xxxxxxx> wrote:
> I've been struggling to get data from the web API into JasperStudio to
> create standard iReports.
>
> I've created a new datasource of type: XML document (remote)
>
> I can pull data from sites that don't need authentication into the
> iReport, such as this rss feed from bbc:
> http://feeds.bbci.co.uk/news/rss.xml?edition=int#
>
> then I can create a report that runs fine using xpath2 as the query
> language.
> (See info here:http://community.jaspersoft.com/wiki/remote-xml-datasource)
>
> I can also use curl to get the data I need as an xml file - such as this,
>
> curl -u admin:district "
> https://apps.dhis2.org/demo/api/dataValueSets.json?dataSet=pBOMPrpg1QX&period=201401&orgUnit=DiszpKrYNg8
> "
>
> But I can't manage to format the url correctly to pass username and
> password for DHIS-2 within iReport. I'm sure it is something with the
> parameters.
>
> Has anyone else sorted this out already? Would be very useful for a
> variety of reporting tasks.
>
> --
> *Randy Wilson*
> *Team Leader: **Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Direct: +250 788308835
> E-mail: rwilson@xxxxxxx
> Skype: wilsonrandy_us
> <http://www.msh.org/>
> Stronger health systems. Greater health impact.
> <https://www.facebook.com/ManagementSciencesForHealth>
> <https://twitter.com/MSHHealthImpact>
> <https://www.youtube.com/user/MSHHealthImpact>
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>
>
References