topic What is the best method to work with API extracted data? in Dynatrace API

What is the best method to work with API extracted data?

YuvalKonstanti — Sun, 28 Nov 2021 09:45:03 GMT

Hello all,

I hope I will make my question clear;

I want to extract data using Dynatrace API, to look for hosts that are listed as "Monitoring Candidate" and so on...

I find it hard to work with the extracted data from the API, for example, if I'm extracting the list of hosts, I see many parameters I don't need. I want for example to filter only the "Monitoring Candidates" but I don't know how.

You guys have any tips? a software I can use to work with?

Thank you.

Re: What is the best method to work with API extracted data?

Yosi_Neuman — Sun, 28 Nov 2021 10:29:01 GMT

Hi @YuvalKonstanti

In order to make the output more useful you can:

Convert the json to csv with some online converters and work on the CSV.
Use Host Report (by Erik Landsness) just save it to your google drive, add your tenant id and token in config tab and run it from the dynatrace menu entry.
Connect your rest API with your company BI tools and play with data as you like.

HTH

Yos

Re: What is the best method to work with API extracted data?

adam_gardner — Mon, 29 May 2023 12:32:23 GMT

The new /api/v2 "monitored entities" set of endpoints make this easier.

First, have a look at the possible properties for a particular entity (eg. HOST)

GET https://abc12345.live.dynatrace.com/api/v2/entityTypes/ENTITY-TYPE
eg.
GET https://abc12345.live.dynatrace.com/api/v2/entityTypes/HOST

Gives:

{
  "type": "HOST",
  "displayName": "Host",
  "dimensionKey": "dt.entity.host",
  "entityLimitExceeded": false,
  "properties": [
    ...

{
      "id": "isMonitoringCandidate",
      "type": "Boolean",
      "displayName": "isMonitoringCandidate"
    }
    ...
  ]

Now get the hosts and ask for that additional property:

GET https://abc12345.live.dynatrace.com/api/v2/entities?entitySelector=type(HOST)&fields=properties.isMonitoringCandidate

Gives

{
  "totalCount": 1,
  "pageSize": 50,
  "entities": [{
      "entityId": "HOST-1234706CD0451ABC",
      "displayName": "myHostname",
      "properties": {
        "isMonitoringCandidate": false
      }
    }]
}

Re: What is the best method to work with API extracted data?

adam_gardner — Mon, 29 Nov 2021 02:04:19 GMT

GET https://abc12345.live.dynatrace.com/api/v2/entities?entitySelector=type(HOST)&fields=properties.isMonitoringCandidate

To see all valid properties for an entity:

https://abc12345.live.dynatrace.com/api/v2/entityTypes/HOST