Reporting REST with parameters, authenticating via tokens with the Report Server 24

This is the first of two blog posts presenting the new features of our combit Report Server in the upcoming version 24. Since the last version, in which the Report Server has become part of our List & Label developer component, the development teams of both products have been working even more closely together. This enables us to better coordinate the needs of both products, and thus also of our customers.

One of the new features we have already shown in the blogpost about parametrized data sources. The use of report parameters, which are normally defined in the Designer, has probably become widely known. Up to now, however, the selection of a specific report parameter only affected the data source directly for SQL databases or ODATA data sources, for example. However, especially with REST web services, there are some scenarios in which the data itself must already be determined via the URL (address) used. This can now be done using the data source parameters. Our own Redmine bug tracking system also supports REST API control. Here is a description of this API.

In this example, the project ID is defined as a data source parameter.

This parameter behaves exactly like a report parameter and thus allows some new application scenarios in connection with REST data sources. This feature is also supported by JSON data sources.

You can see the parameter here in more detail:

http://redmine/redmine/projects/{{id=16|format=number|multiselect=false|choicesfield=projects.id}}.json?include=trackers,issue_categories

For authentication, for example, some REST web services require a way to set values using HTTP headers, which can then be evaluated by the API. Again, we can use Redmine for demonstrations. This optionally uses the HTTP header “X-Redmine API-Key” as a replacement for a login.

This means that some previously unusable web services can now also be controlled.

With the increasing use of the Report Server, the number of demands has also increased over the years. Meanwhile, many of our customers use more than 10 data sources, which increasingly led to the desire to introduce a folder structure for better organization.

We were happy to comply with this request and have thus implemented one of the most frequent customer requests.

Of course, that’s not all Report Server 24 has to offer. You can look forward to the second part! 🙂

Related Posts

Leave a Comment