Hi Team,
We have below array of JSON & want to ingest these JSON into Elasticsearch.
We want split this & ingest into 2 rows :
[{
"RequestEventList":[
{
"Instant":"2015-09-28T12:46:50.713Z",
"RequestKey":"11bcf87b-35ca-44dc-b4b3-567db2a159cb",
"RequestEventName":"WebScreenClientExecuted",
"ModuleKey":"1e758d31-e7de-4641-a731-d3976254108d",
"ModuleName":"PerformanceSampleDat",
"ApplicationKey":"d026f21a-cbe8-490e-8fbb-47b7fe0db79e",
"ApplicationName":"Performance Sample Data",
"RequestEventDetails":{
"AK":"7449c66a-9863-4673-91c0-cb0440344497",
"AN":"StartBootstrap",
"EPK":"5a0a2e6c-570f-414f-9b19-ee2cafde273d",
"EPN":"HomePage",
"TK":"6284e8bf-2aa5-50a4-f1bc-9918c2801df6",
"TN":"Users",
"EK":"c5be45ac-ccac-4091-a825-d6a7bb9554a0",
"EN":"Development",
"FN":"qaos1296lt5308",
"VK":"d6aa213f-6b4a-42b6-8e39-6624008a576a",
"ViK":"82359545-98b8-4010-8c72-cca1a2fe7b3b",
"SK":"73562726-2f4f-9bc1-9f44-6219febee940",
"UK":"666d9979-32be-4b2d-5271-d267d996bfca",
"SR":"1680x1050",
"D":314,
"LT":2,
"TTFB":312,
"TTLB":312,
"UA":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36"
}
},
{
"Instant":"2015-09-28T12:46:51.037Z",
"RequestKey":"ad133aee-5cc9-4eb9-8faf-016d2b811d0c",
"RequestEventName":"WebScreenClientExecuted",
"ModuleKey":"1e758d31-e7de-4641-a731-d3976254108d",
"ModuleName":"PerformanceSampleDat",
"ApplicationKey":"d026f21a-cbe8-490e-8fbb-47b7fe0db79e",
"ApplicationName":"Performance Sample Data",
"RequestEventDetails":{
"AK":"f6151d08-6edd-01a7-e402-8f5a6a6fce40",
"AN":"Feedback_Message.Refresh",
"EPK":"5a0a2e6c-570f-414f-9b19-ee2cafde273d",
"EPN":"HomePage",
"TK":"6284e8bf-2aa5-50a4-f1bc-9918c2801df6",
"TN":"Users",
"EK":"c5be45ac-ccac-4091-a825-d6a7bb9554a0",
"EN":"Development",
"FN":"qaos1296lt5308",
"VK":"d6aa213f-6b4a-42b6-8e39-6624008a576a",
"ViK":"82359545-98b8-4010-8c72-cca1a2fe7b3b",
"SK":"73562726-2f4f-9bc1-9f44-6219febee940",
"UK":"666d9979-32be-4b2d-5271-d267d996bfca",
"SR":"1680x1050",
"D":179,
"LT":24,
"TTFB":155,
"TTLB":155,
"UA":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36"
}
}
],
"ResultsTruncated":false
}
]
Please suggest.
Regards,
Jalpesh