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
‎12-21-2017 01:38 PM
Why fetch the data from a report when you could fetch the data from the data source itself?
Reports are about data presentation, not a data source.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2017 05:20 AM
I need to get grouped data by month(count of incents by each month of one year), So if we have 1 million incidents the fetching all this data from API will not good solution...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-13-2018 11:33 AM
The REST API also includes an Aggregate api that would allow you to get the grouped data as described above.
This may be a bit trickier and more complex to use but should give better performance for getting just aggregated data.
https://developer.servicenow.com/app.do#!/rest_api_doc?v=kingston&id=r_AggregateAPI-GET

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2021 09:35 AM
This is a pretty legitimate use case, especially if reporting against Request Item variables.
https://youtube.com/watch?v=zYi8KhP9SUk