Fetching data using JSON based web services

[manpreet.singh]

Hi,

There is a scenario in which I need to show data in reporting using external REST based web service which returns JSON data. Has anyone tried that? Or is there any tutorial around that?

Thanks
Manpreet.

[manpreet.singh]

Did find any direct way. Finally landed up in making custom data source for it. And custom data source making web service calls.

[athomas.yvr]

Are you able to provide any more information on this? I am currently looking to retrieve a JSON formatted data set from a web service and would appreciate some additional direction.

Thanks

[gnatali]

This is now possible using Web Service Datasource

http://community.jaspersoft.com/project/web-service-data-source

This Community project implement a Custom Datasource, built using the latest Custom Datasource framework (leveraging Data Adapters internally).

It is also working inside JasperReports Server:

You can use it to fill Query based Input Controls, as well as Ad Hoc Reporting (for Commercial version) using it through Topic.

Thanks