← Back to team overview

dhis2-users team mailing list archive

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