how to get data from created report using API?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2017 11:49 AM
Using the Table API (GET), we can obtain the data from the Incidents table.
Table API (GET) from sys_report table get only the data of the displayed graph in the report (for example "type": "line_bar", "chart_border_color" "," y_axis_title_size ":" 12 ").
How to get data (2017-12-08 = 2 incidents, 2017-12-11 = 1 incident...) from created "Test Report_6" report using API?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2020 07:51 AM
We're going to come at this by using Power BI to API import data from the two tables and join and filter them. I'm disappointed that our feature request from 2016 (to add WHERE clause to db views) has gone unworked, forcing us to use 3rd party tools.