Extracting using API

[Marvel22]

Hi all

I am working on Trend analysis trying to find the Patterns and Trends on our problems from DT dashboard, so I want to use API's to extract Problems, is it possible to filter by time and date? can the problems extracted show the start time of the alert and end time? please assist how can I achieve this. 

[AntonPineiro · Accepted solution]

Hi,

You can use "from" and "to" in Problems API v2 - GET problems list.

Best regards

[PacoPorro]

If you're in SaaS you can use dql 

fetch events
| filter event.kind == "DAVIS_PROBLEM"
| summarize by:{event.name}, count = countDistinct(display_id)
| sort count, direction:"descending"