Exporting reports
With the REST API, you can export reports as HTML, PDF and CSV formats.
As a prerequisite, ensure you have the API key required for user authentication on Swagger. See Authentication for REST APIs. for steps to generate the API key.
To extract data from tabular reports
- In the IT Analytics portal, generate a tabular report and save it.
See Save Reports.
- Run the saved report.
- Press Ctrl + Alt + T to view the Report Statistics and find the Report ID.
- Access swagger (<portal_url>/api/swagger-ui.html).
- Select option v1 from Select a spec.
- Click Authorize and enter the API key generated from the IT Analytics portal.
The API key is passed in the authorization header of the REST API.
- Expand Report section.
- Expand /v1/reports/{reportId}/export and click try it out.
- Enter Report Id and click Execute.
Note:
To obtain the report in JSON format, use the URL <portal_url>/api/v1/reports/{reportId} to download the JSON file, for example using the curl command.
Note:
If the exported report or dashboard contains a generic placeholder chart image, the chart export feature on your system has been disabled. See the Remove "PhantomJS" from IT Analytics Portal tech note for further details.