How to pull data from a remote xml data source (dhis2 web API) into JasperReports

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

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

···

On Mon, Aug 31, 2015 at 9:08 PM, Wilson, Randy rwilson@msh.org 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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Morten