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
morten
(Morten Hansen)
31 August 2015 15:20
2
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