Array: Extract the values and add the values


(Rodrigo Cuevas) #1

Hi Community,

I have this output:

{
"timeseriesId" => "com.dynatrace.builtin:servicemethod.responsetime",
"dimensions" => [
[0] "SERVICE_METHOD"
],
"@timestamp" => 2018-11-27T20:27:01.309Z,
"types" => ,
"displayName" => "Method response time",
"servicio" => "login",
"dataResult" => {
"dataPoints" => {
"SERVICE_METHOD-A0531FB2DBDE389A" => [
[0] [
[0] 1543350120000,
[1] 25832.798521256933
]
],
"SERVICE_METHOD-828A8332FE723468" => [
[0] [
[0] 1543350120000,
[1] 58236.78571428572
]
]
},
"resolutionInMillisUTC" => 300000,
"timeseriesId" => "com.dynatrace.builtin:servicemethod.responsetime",
"aggregationType" => "AVG",
"unit" => "MicroSecond (µs)",
"entities" => {
"SERVICE_METHOD-A0531FB2DBDE389A" => "/oam/server/obrareq.cgi",
"SERVICE_METHOD-828A8332FE723468" => "/oam/server/auth_cred_submit"
}
},
"aggregationTypes" => [
[0] "AVG",
[1] "SUM",
[2] "MIN",
[3] "MAX",
[4] "MEDIAN",
[5] "PERCENTILE"
],
"filter" => "BUILTIN",
"site" => "vp1",
"detailedSource" => "Services",
"@version" => "1",
"unit" => "MicroSecond (µs)"
}

I want to extract the values ​​marked in bold, leave them in new fields and in a new field add the values.

Someone has some idea

Regards.