API metric/query - how to return just one result (data point)

Platform Dynatrace API
1

I’m trying to use the API to pull back the latest data point value for a given metric.  I’ve tried playing with transforms and resolutions. I can get it down to 2 metrics. But any suggestions on how to just get the latest datapoint for a given metric on a given host?

We’re trying to integrate two monitoring systems by sending metrics out of DT and into the other monitoring tool using its APIs.

https://xxxxxx.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin%3Ahost.cpu.system&resolution=2&entitySelector=type("HOST")%2CentityName("xxxxxxxxx")

<span>{</span>
  <span>"totalCount"</span><span>:</span> <span>1</span><span>,</span>
  <span>"nextPageKey"</span><span>:</span> <span>null</span><span>,</span>
  <span>"resolution"</span><span>:</span> <span>"1h"</span><span>,</span>
  <span>"result"</span><span>:</span> <span>[</span>
    <span>{</span>
      <span>"metricId"</span><span>:</span> <span>"builtin:host.cpu.system"</span><span>,</span>
      <span>"data"</span><span>:</span> <span>[</span>
        <span>{</span>
          <span>"dimensions"</span><span>:</span> <span>[</span>
            <span>"HOST-xxxxx"</span>
          <span>]</span><span>,</span>
          <span>"dimensionMap"</span><span>:</span> <span>{</span>
            <span>"dt.entity.host"</span><span>:</span> <span>"HOST-xxxxx"</span>
          <span>}</span><span>,</span>
          <span>"timestamps"</span><span>:</span> <span>[</span>
            <span>1643385600000</span><span>,</span>
            <span>1643389200000</span><span>,</span>
            <span>1643392800000</span>
          <span>]</span><span>,</span>
          <span>"values"</span><span>:</span> <span>[</span>
            <span>1</span><span>.</span><span>8281565772162542</span><span>,</span>
            <span>1</span><span>.</span><span>7218984444936116</span><span>,</span>
            <span>1</span><span>.</span><span>766819120298886</span>
          <span>]</span>
        <span>}</span>
      <span>]</span>
    <span>}</span>
  <span>]</span>
<span>}</span>
2

Hello,

OK assuming you can’t use whatever is running the API to grab the first element you can do something like this:

curl -X GET "https://XXXXXXXX.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin%3Ahost.cpu.system&from=now-2m%2Fm&to=now-1m%2Fm&entitySelector=type%28HOST%29%2CentityId%28HOST-XXXXXXXXXXXXXXXX%29" -H "accept: application/json; charset=utf-8" -H "Authorization: Api-Token [TOKEN]"

Effectively I am just using the timeframe selector to get the last datapoint:

edwardbuckler_1-1643398056346.png
edwardbuckler_1-1643398056346.png1571×865 29.6 KB

The response would look like this:

{
  "totalCount": 1,
  "nextPageKey": null,
  "resolution": "1m",
  "result": [
    {
      "metricId": "builtin:host.cpu.system",
      "data": [
        {
          "dimensions": [
            "HOST-XXXXXXXXXXXXXXXX"
          ],
          "dimensionMap": {
            "dt.entity.host": "HOST-XXXXXXXXXXXXXXXX"
          },
          "timestamps": [
            1643397300000
          ],
          "values": [
            0.32281724611918133
          ]
        }
      ]
    }
  ]
}
3

Thank you.  That’s a fantastic solution.  Much appreciated.

Dynatrace Developers:  Any thoughts of having a “Last” resolution or Transformation to make this easier?

4

@ct_27 Try to add the “:lastReal” at the end of your metricselector query 🙂.

Even if you remove the resolution, it will always get the last datapoint.