# Split double nested json array - http poller logstash **URL:** \ **Category:** Logstash\ **Created:** [November 24, 2020, 5:19am UTC](https://discuss.elastic.co/t/split-double-nested-json-array-http-poller-logstash/256440 "2020-11-24T05:19:22Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![sachin10](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@sachin10](https://discuss.elastic.co/u/sachin10)\ **Post date:** [November 24, 2020, 5:19am UTC](https://discuss.elastic.co/t/split-double-nested-json-array-http-poller-logstash/256440/1 "2020-11-24T05:19:22Z")
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](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](https://ABC.com)", "name": "automation", "key": "automation", "emailAddress": "[noreply@gmail.net](mailto:noreply@gmail.net)", "avatarUrls": { "48x48": "[https://ABC.com](https://ABC.com)", "24x24": "[https://ABC.com](https://ABC.com)", "16x16": "[https://ABC.com](https://ABC.com)", "32x32": "[https://ABC.com](https://ABC.com)" }, "displayName": "Automation", "active": true, "timeZone": "Europe/Bucharest" }, "priority": { "self": "[https://ABC.com](https://ABC.com)", "iconUrl": "[https://ABC.com](https://ABC.com)", "name": "Major", "id": "3" }, "resolution": { "self": "[https://ABC.com](https://ABC.com)", "id": "1", "description": "tested", "name": "Fixed" }, "customfield\_13611": { "id": "349", "name": "Time to reaction", "\_links": { "self": "[https://ABC.com](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](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](https://ABC.com)", "description": "verification", "iconUrl": "[https://ABC.com](https://ABC.com)", "name": "Resolved", "id": "5", "statusCategory": { "self": "[https://ABC.com](https://ABC.com)", "id": 3, "key": "done", "colorName": "green", "name": "Done" } } } }, { "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields", "id": "1754193", "self": "[https://ABC.com](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](https://ABC.com)", "name": "automation", "key": "automation", "emailAddress": "[noreply@gmail.net](mailto:noreply@gmail.net)", "avatarUrls": { "48x48": "[https://ABC.com](https://ABC.com)", "24x24": "[https://ABC.com](https://ABC.com)", "16x16": "[https://ABC.com](https://ABC.com)", "32x32": "[https://ABC.com](https://ABC.com)" }, "displayName": "Automation", "active": true, "timeZone": "Europe/Bucharest" }, "priority": { "self": "[https://ABC.com](https://ABC.com)", "iconUrl": "[https://ABC.com](https://ABC.com)", "name": "Major", "id": "3" }, "resolution": { "self": "[https://ABC.com](https://ABC.com)", "id": "1", "description": "tested.", "name": "Fixed" }, "customfield\_13611": { "id": "349", "name": "Time to reaction", "\_links": { "self": "[https://ABC.com](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](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](https://ABC.com)", "description": "verification", "iconUrl": "[https://ABC.com](https://ABC.com)", "name": "Resolved", "id": "5", "statusCategory": { "self": "[https://ABC.com](https://ABC.com)", "id": 3, "key": "done", "colorName": "green", "name": "Done" } } } }, ... ] } ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 22, 2020, 5:19am UTC](https://discuss.elastic.co/t/split-double-nested-json-array-http-poller-logstash/256440/2 "2020-12-22T05:19:23Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.