how to get data from created report using API?

maxim_radetsk
Kilo Explorer

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?
60452faaa2c3ab2fe9559084f9d999db

10 REPLIES 10

treycarroll
Giga Guru

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.