Power BI API - Where to find Rsolved_At and Closed_At in the json data.

dpitcock

In Power BI I'm using the Get Data and choosing the Web connector.  I'm using using https://api.samanage.com/incidents.json as the URL.  After providing my HTTP request header parameters and Bearer Token, I'm able to connect to the data.  My question is where is the Resolved_At and Closed_At date/time values stored, I've located the Created_At and Updated_At values.  I've expaned every table and record in the json but I'm unable to find these vales.  Does anyone know where they are located.  

tculpepp

It doesn't look like those are yet supported by the PowerBi connector. There was an update to the API in Jan '25 that added the option forlayout=long that includes a statistics section in the return. That section has all the key events such as assigned, closed, etc.

SolarWinds will need to update the connector to support the expanded return option.