Extracting data from tabular reports (with pagination)
With the REST API, you can extract data from tabular reports using pagination in JSON and XML 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} and click try it out.
- Enter Report Id and click Execute.
