[closed] Can I programmatically export a Report Builder report?

Jackie Albert

(1.6k●1●49●47) closed

Sep 12 '23, 3:56 a.m.

We have users moving from Rational Insight to use the JRS Report Builder, however they are missing a few of the basic functions such as being able to snapshot a report at a point in time, or email report results to a group of people.

I understand these functions are not available, but we can export a report to Excel. It seems like it might be a feasible workaround to programmatically export the report via Excel - are there API's available to do this, or some way we could offer this capability?

1 vote

2 answers

8,524 views

1 vote

The question has been closed for the following reason: "The question is answered, right answer was accepted" by davidhoney Sep 12 '23, 3:56 a.m.

Accepted answer

Permanent link

Steven Shaw

FORUM MODERATOR / JAZZ DEVELOPER (551●1●3) May 19 '16, 3:31 p.m.

Hi Jackie,

Yes there is, and it's just a variation of the URL that you would use to view a report.

If you are viewing a report is has a URL as follows:

<server>:<port>/rs/reports#view=<id> where ID is a unique integer, server is where your application is installed and port is the port where the application is accessible from.

To access the excel API you need to call the following URL:

<server>:<port>/rs/reportdefinition/<id>/export/excel/static where server, port and id are the same as the URL where you viewed the report.

Alternatively you can replace "static" with "live" to get a live version of the report that can refreshed from within the Excel application.

Note: these api's are different then ones exposed in the Excel export page which also includes the query ID. The query ID is internal and would be difficult to derive. These URL's are also valid but achieve the same result. The api's above are much more easily derivable.

Hope that helps,

-Steve

Jackie Albert selected this answer as the correct answer

1 vote

Comments

Steven Shaw

FORUM MODERATOR / JAZZ DEVELOPER May 19 '16, 3:33 p.m.

oh yeah - sorry for the slow response ...

Steven Shaw

FORUM MODERATOR / JAZZ DEVELOPER May 19 '16, 3:41 p.m.

Also if we want to get fancy, you could tag the reports you want to do the automatic export on, then use the following API to get a JSON representation of those reports that is used in the explorer view: <server>:<port>/rs/explore/rows?show=reportdefinition&visibility=all&tag=<ExportTag> where "ExportTag" is the tag you used to tag the particular reports you want to export. This api will return a JSON structure of those reports where one of the fields is "index". This index field would be used as the ID in the excel export API. Good luck!

thimmaiah aa

Sep 12 '23, 2:03 a.m.

Hello, Is this API "<server>:<port>/rs/reportdefinition/<id>/export/excel/static " still valid for 7.0.2? We tried using this and unable to export the report. Please let us know if we have any other API for the same.

Ralph Schoon

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 12 '23, 2:06 a.m.

Please create your own question, potentially referring to this question. Please do not post answers with your own questions to questions. This is especially true, if the question was already correctly answered, the answer was accepted and the question and answer is very old. Thank you.