Jump to content
  • This documentation is an older version of JasperReports Server REST API Reference. View the latest documentation.

    In addition to running reports, JasperReports Server exposes queries that you can run through the rest_v2/queryExecutor service. The only resource that supports these queries is a Domain.

    Use the GET method to specify the query string in the request as an argument.

    Method

    URL

    GET

    http://<host>:<port>/jasperserver-pro/rest_v2/queryExecutor/path/to/Domain/?q=<query>

    Argument

    Type/Value

    Description

    q

    Required String

    The query string is a special format that references the fields and measures exposed by the Domain. To write this query, you must have knowledge of the Domain schema that is not available through the REST services. See below.

    Options

    accept: application/xml (default)

    accept: application/json

    Accept-Language: <locale>, <relativeQualityFactor>; for example en_US, q=0.8;

    Return Value on Success

    Typical Return Values on Failure

    200 OK – The body contains the data that is the result of the query. See the format of the data below.

    404 Not Found – When the specified Domain does not exist.

    If the query is too large to fit in the argument in the URL, use the POST method to send it as request content:

    Method

    URL

    POST

    http://<host>:<port>/jasperserver-pro/rest_v2/queryExecutor/path/to/Domain/

    Content-Type

    Content

    application/xml

    The query string is a special format that references the fields and measures exposed by the Domain. To write this query, you must have knowledge of the Domain schema that is not available through the REST services. See below.

    Options

    accept: application/xml (default)

    accept: application/json

    Accept-Language: <locale>, <relativeQualityFactor>; for example en_US, q=0.8;

    Return Value on Success

    Typical Return Values on Failure

    200 OK – The body contains the data that is the result of the query. See the format of the data below.

    404 Not Found – When the specified Domain does not exist.

    The following example show the format of a query in XML:

    And the following sample shows the result of query. In order to optimize the size of the response, rows are presented as sets of values without the column names repeated for each row. The column IDs appear at the top of the result, as shown in the following example. As with the query, the result requires knowledge of the Domain schema to identify the human-readable column names.

    note-icon-ns_28x28.png.b4281228fac856ee1be8a36d6fd2cdfa.png

    Both date-only and timestamp fields are given in the ISO date-time format such as 1997-01-01T04:05:06+02:00.

    For database columns that store a time and date that includes a time zone, such as "timestamp with time zone" in PostgreSQL, the result is not guaranteed to be in the same time zone as stored in the database. These dates and times are converted to the server's time zone.

     


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...