topic Re: API v2 unexpected output converting curl to Powershell Invoke-RestMethod in Dynatrace API

API v2 unexpected output converting curl to Powershell Invoke-RestMethod

runatyr — Mon, 02 Sep 2024 06:26:33 GMT

Hello:

We are attempting to convert the curl command to a powershell Invoke-RestMethod command in the PIA v2 for GET /metrics/query

I am unclear as to why I do not get the data returned with Invoke-RestMethod but CURL works.

Information is returned, but not the data from the API.

What is happening and does anyone see what needs changed to retrieve the data?

Thank you,

Runatyr

$body = @{
"metricSelector" = "ext:cloud.azure.microsoft_sql.managedinstances.io_requests"
"resolution" = "1m"
"entitySelector" = "type(custom_device),entityName.equals(`"bwc-sqlmi-peachpoc`")"
}
$headers = @{
"accept" = "application/json; charset=utf-8"
"Authorization" = "Api-Token dt0c01.xxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
}
$response = Invoke-RestMethod -Uri "https://xnm19dypd01/e/52575bc0-1849-4837-8e18-8bc962f4407f/api/v2/metrics/query" -Body $body -Headers $headers
Invoke-RestMethod -Uri "https://xnm19dypd01/e/52575bc0-1849-4837-8e18-8bc962f4407f/api/v2/metrics/query" -Body $body -Headers $headers

Re: API v2 unexpected output converting curl to Powershell Invoke-RestMethod

runatyr — Wed, 11 Sep 2024 11:16:02 GMT

Update:

I have a PowerShell Script that is using the Invoke-RestMethod.

However, the data returned looks like this in PowerShell.

I don't see the values expected values.

This is what I see.

How do I go about accessing the data in this format?

When I query the API directly with cURL(PowerShell) in the Dynatrace API .. this is the format.

Any ideas how to access the data when returned in that first format using Invoke-RestMethod? and not cURL?

Re: API v2 unexpected output converting curl to Powershell Invoke-RestMethod

mrandant — Wed, 18 Sep 2024 13:59:04 GMT

(Invoke-RestMethod -Uri "https://xnm19dypd01/e/52575bc0-1849-4837-8e18-8bc962f4407f/api/v2/metrics/query" -Body $body -Headers $headers).result | ConvertTo-Json

$Response.result | ConvertTo-Json

Converting the result to JSON will get you mostly the same result as your curl output.