This article looks at how you can bring in outside data into your BI Publisher Reports. This option leverages the BI Publisher administration features, where you can define your own set of data sources upon which you report. At this time the support is for SOAP-based services and includes an declarative method for making response values available for reporting. It includes a parameter-based feature for passing inputs to the web services, and has basic support for extracting data from more complex responses via XPath.
In summary the steps required are as follows:
The following screenshots pick out the key parts of this features, and the whole process is demonstrated in the video below.
The screen below shows the new Data Model definition, leveraging the 'weather' web service already setup as a Data Source in the BI Publisher administration pages. As you notice there is support for multiple methods. Note that the ResponseData XPath field allows you to specify which values you want to use inside a complex response payload.
Once you have setup your Data Model above, you define report Parameters for each input to that service. Note: You may have to reopen the Data Set to ensure the web service parameters as associated with your report parameters (in the drop-down). Care should be taken to match parameter Data Types and consider using Default Values to aid working with required or internal fixed-value fields.
The following video from our YouTube channel shows the same setup above and running this as a report.
For more on using BI in your customizations see our articles here. Alternative look into the existing material such as the BI Publisher blog, forum and community and the BI Publisher Documentation, specifically: