I would like to to retrieve every element in below JSON to be a separate field so as to visualize in kibana by applying metrics in dashboard.
I'm using http poller plugin to do this task and i used below filter to split the json and its working fine but unable to split -issues.fields.customfield_13609.completedCycles.elapsedTime.friendly
issues.fields.customfield_13611.completedCycles.elapsedTime.friendly
wanted to show this value per event.
Can you please help me to write filer logic to split the completedCycles array.
filter {
split { field => "issues" }
}
JSON Data :
{
"expand": "schema,names",
"startAt": 0,
"maxResults": 1000,
"total": 254,
"issues": [
{
"expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
"id": "1764180",
"self": "https://ABC.com",
"key": "S-228536",
"fields": {
"summary": "slow performance",
"created": "2020-11-18T12:31:45.000+0200",
"description": " Dear colleagues",
"reporter": {
"self": "https://ABC.com",
"name": "automation",
"key": "automation",
"emailAddress": "noreply@gmail.net",
"avatarUrls": {
"48x48": "https://ABC.com",
"24x24": "https://ABC.com",
"16x16": "https://ABC.com",
"32x32": "https://ABC.com"
},
"displayName": "Automation",
"active": true,
"timeZone": "Europe/Bucharest"
},
"priority": {
"self": "https://ABC.com",
"iconUrl": "https://ABC.com",
"name": "Major",
"id": "3"
},
"resolution": {
"self": "https://ABC.com",
"id": "1",
"description": "tested",
"name": "Fixed"
},
"customfield_13611": {
"id": "349",
"name": "Time to reaction",
"_links": {
"self": "https://ABC.com"
},
"completedCycles": [
{
"startTime": {
"iso8601": "2020-11-18T12:31:47+0200",
"ABC": "2020-11-18T12:31:47.385+0200",
"friendly": "18/Nov/20 12:31 PM",
"epochMillis": 1605695507385
},
"stopTime": {
"iso8601": "2020-11-18T13:00:19+0200",
"ABC": "2020-11-18T13:00:19.430+0200",
"friendly": "18/Nov/20 1:00 PM",
"epochMillis": 1605697219430
},
"breached": false,
"goalDuration": {
"millis": 172800000,
"friendly": "48h"
},
"elapsedTime": {
"millis": 1712045,
"friendly": "28m"
},
"remainingTime": {
"millis": 171087955,
"friendly": "47h 31m"
}
}
]
},
"labels": ,
"customfield_17903": [
"DS"
],
"customfield_13609": {
"id": "1",
"name": "Time to resolution",
"_links": {
"self": "https://ABC.com"
},
"completedCycles": [
{
"goalDuration": {
"friendly": "4h",
"millis": 14400000
},
"elapsedTime": {
"friendly": "2m",
"millis": 127357
},
"breached": false,
"stopTime": {
"friendly": "06/Nov/20 4:05 PM",
"epochMillis": 1604671549065,
"iso8601": "2020-11-06T16:05:49+0200",
"jira": "2020-11-06T16:05:49.065+0200"
},
"startTime": {
"friendly": "06/Nov/20 4:03 PM",
"epochMillis": 1604671421708,
"iso8601": "2020-11-06T16:03:41+0200",
"jira": "2020-11-06T16:03:41.708+0200"
},
"remainingTime": {
"friendly": "3h 57m",
"millis": 14272643
}
}
],
"ongoingCycle": {
"startTime": {
"iso8601": "2020-11-18T12:31:47+0200",
"ABC": "2020-11-18T12:31:47.385+0200",
"friendly": "18/Nov/20 12:31 PM",
"epochMillis": 1605695507385
},
"breachTime": {
"iso8601": "2020-12-02T09:18:21+0200",
"ABC": "2020-12-02T09:18:21.766+0200",
"friendly": "02/Dec/20 9:18 AM",
"epochMillis": 1606893501766
},
"breached": false,
"paused": true,
"withinCalendarHours": true,
"goalDuration": {
"millis": 864000000,
"friendly": "240h"
},
"elapsedTime": {
"millis": 97002349,
"friendly": "26h 56m"
},
"remainingTime": {
"millis": 766997651,
"friendly": "213h 3m"
}
}
},
"resolutiondate": "2020-11-20T16:11:27.000+0200",
"updated": "2020-11-20T16:11:27.000+0200",
"status": {
"self": "https://ABC.com",
"description": "verification",
"iconUrl": "https://ABC.com",
"name": "Resolved",
"id": "5",
"statusCategory": {
"self": "https://ABC.com",
"id": 3,
"key": "done",
"colorName": "green",
"name": "Done"
}
}
}
},
{
"expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
"id": "1754193",
"self": "https://ABC.com",
"key": "K-225899",
"fields": {
"summary": "kP| Google|Recognizable",
"created": "2020-11-12T10:02:27.000+0200",
"description": " Dear colleagues",
"reporter": {
"self": "https://ABC.com",
"name": "automation",
"key": "automation",
"emailAddress": "noreply@gmail.net",
"avatarUrls": {
"48x48": "https://ABC.com",
"24x24": "https://ABC.com",
"16x16": "https://ABC.com",
"32x32": "https://ABC.com"
},
"displayName": "Automation",
"active": true,
"timeZone": "Europe/Bucharest"
},
"priority": {
"self": "https://ABC.com",
"iconUrl": "https://ABC.com",
"name": "Major",
"id": "3"
},
"resolution": {
"self": "https://ABC.com",
"id": "1",
"description": "tested.",
"name": "Fixed"
},
"customfield_13611": {
"id": "349",
"name": "Time to reaction",
"_links": {
"self": "https://ABC.com"
},
"completedCycles": [
{
"startTime": {
"iso8601": "2020-11-12T10:02:28+0200",
"ABC": "2020-11-12T10:02:28.587+0200",
"friendly": "12/Nov/20 10:02 AM",
"epochMillis": 1605168148587
},
"stopTime": {
"iso8601": "2020-11-12T10:07:32+0200",
"ABC": "2020-11-12T10:07:32.461+0200",
"friendly": "12/Nov/20 10:07 AM",
"epochMillis": 1605168452461
},
"breached": false,
"goalDuration": {
"millis": 172800000,
"friendly": "48h"
},
"elapsedTime": {
"millis": 303874,
"friendly": "5m"
},
"remainingTime": {
"millis": 172496126,
"friendly": "47h 54m"
}
}
]
},
"labels": [
"Google"
],
"customfield_17903": [
"kP"
],
"customfield_13609": {
"id": "1",
"name": "Time to resolution",
"_links": {
"self": "https://ABC.com"
},
"completedCycles": [
{
"goalDuration": {
"friendly": "4h",
"millis": 14400000
},
"elapsedTime": {
"friendly": "2m",
"millis": 127357
},
"breached": false,
"stopTime": {
"friendly": "06/Nov/20 4:05 PM",
"epochMillis": 1604671549065,
"iso8601": "2020-11-06T16:05:49+0200",
"jira": "2020-11-06T16:05:49.065+0200"
},
"startTime": {
"friendly": "06/Nov/20 4:03 PM",
"epochMillis": 1604671421708,
"iso8601": "2020-11-06T16:03:41+0200",
"jira": "2020-11-06T16:03:41.708+0200"
},
"remainingTime": {
"friendly": "3h 57m",
"millis": 14272643
}
}
],
"ongoingCycle": {
"startTime": {
"iso8601": "2020-11-12T10:02:28+0200",
"ABC": "2020-11-12T10:02:28.587+0200",
"friendly": "12/Nov/20 10:02 AM",
"epochMillis": 1605168148587
},
"breachTime": {
"iso8601": "2020-11-29T13:06:52+0200",
"ABC": "2020-11-29T13:06:52.515+0200",
"friendly": "29/Nov/20 1:06 PM",
"epochMillis": 1606648012515
},
"breached": false,
"paused": true,
"withinCalendarHours": true,
"goalDuration": {
"millis": 864000000,
"friendly": "240h"
},
"elapsedTime": {
"millis": 342491622,
"friendly": "95h 8m"
},
"remainingTime": {
"millis": 521508378,
"friendly": "144h 51m"
}
}
},
"resolutiondate": "2020-11-20T07:56:58.000+0200",
"updated": "2020-11-20T10:55:58.000+0200",
"status": {
"self": "https://ABC.com",
"description": "verification",
"iconUrl": "https://ABC.com",
"name": "Resolved",
"id": "5",
"statusCategory": {
"self": "https://ABC.com",
"id": 3,
"key": "done",
"colorName": "green",
"name": "Done"
}
}
}
},
...
]
}