teodord

This article shows how to retrieve JSON report data from a remote REST service using the built-in data adapter support from JasperReports Library and Jaspersoft Studio. Note that the same technique can be used to load XML, CSV or Excel data from remote URLs and is not specific to JSON data only. Here we recreate the report shown in this demo, but do so without using the custom web service extension demonstrated there. As opposed to the indicated demo, we are going to create a data adapter of type JSON File, which is a built-in type in JRL and JSS, instead of the custom data adapter type made available by that optional extension used in that demo. The JSON data adapter allows specifying a remote URL instead of a local JSON file, as the source for the data. When using an URL, the button next to the File/URL field changes from File to Options and thus allows setting request parameters and request headers for the HTTP call that will be made to the specified URL to retrieve the JSON data. Once saved, the data adapter file would be available in the list of data adapters from which we can pick during the report creation wizard. The report creation wizard will try connect to the remote URL and retrieve some data. It will show this data in the left panel and allows to select the node in the JSON object which represents the data source records for the report. Once the data source record node selected, it will propose the selection of available fields that can be picked from the record node to use as report fields. At the end of the report wizard, we obtain a JRXML file in which the main dataset has a JSONQL query and dataset fields that have special configuration properties which map them to specific nodes or attributes in the current record JSON node. Adding some fields in the detail band helps complete the creation of a simple tabular report displaying records coming from JSON data loaded from a remote REST location. Attached to this page are the data adapter file and the report template file used in this article. noaadataadapter.xml noaareport.jrxml

This example shows how to use a data adapter to retrieve JSON data from a remote URL and use it to fill a report. The TIBCO JasperReports® Library offers built-in support for loading report data from remote URLs through data adapters. Data in JSON, XML, CSV or Excel format, can be loaded from local files or from remote URLs using data adapters and it can then be parsed into records using data format specific report queries (JSON QL, XPath) and/or report field mapping metadata. For more details about how this sample report uses the JSONQL query language to process the incoming JSON data into data source records, please see this documentation. The following example shows how to retrieve data about the current status of London Tube Network stations in JSON format, from a remote public URL, and use it to generate a report. We first need to create a JSON data adapter file to point to this remote source of data and we are using a TIBCO Jaspersoft® Studio wizard to do so: The tubestatus.jrxml report attached to this page can be open in Jaspersoft® Studio and previewed using the above created data adapter by selecting it in the data adapter combobox at the top left corner of the report designer preview tab as see below: For deploying this report and the data adapter to an instance of JasperReports Server, we would need to first make sure the report references the data adapter, as the preview operation did not actually link the two together. We are going to use a relative path to point from within the JRXML to the data adapter resource we are going to create in TIBCO JasperReports® Server. This is because the JRXML will be uploaded to a JasperReports® Server report unit, which acts itself like a subfolder containing its own resources and thus the JRXML would not be considered as being in the same folder as the data adapter resource. Use two dots to point to the data adapter resource as being in a parent repository folder as seen below: Now let's upload the two files to JasperReports Server. We can do this using either the Web UI of the JasperReports Server instance, or, in this case, the Jaspersoft® Studio plugin. After having configured the connection to our JasperReports Server instance from within JasperReports Server, we create a folder called tubestatus in the Public folder of the JasperReports Server repository. Right click the newly created /Public/tubstatus folder and pick the New option to create a new data adapter file resource. Make sure you use the name of the XML file as the name of your data adapter resource, because this is how we referenced it from the report in a step above. Pick the tubestatusDataAdapter.xml file from the Jaspersoft® Studio project to have it uploaded to JasperReports Server and hit Finish button. Let's create a report unit and upload the JRXML report template file as well. We can give any name we want to the report unit and then pick the local JRXML file from the Jaspersoft Studio project in the workspace. We don't need to specify any data source for this report unit as the data adapter property we set previously in the JRXML report template itself is enough to connect our report to the remote URL from where the JSON data will be read and then processed. After the report unit has been created, we can use the JasperReports Server Web UI to navigate to the repository folder where we uploaded it and run it. tubestatus_0.jrxml tubestatusdataadapter.xml