How to convert SQL row to array of objects in logstash

Elastic Stack Logstash
1

Hi..Need a help to convert sql row to array of objects in logstash.
Sample output from sql -

columnA - 1,3,5,7
columnB - s,c,e,p

Output needed :

{
"details": [
{
"id": 1,
"stat": s
},
{
"id": 3,
"stat": c
},
{
"id": 5,
"stat": e
},
{
"id": 7,
"stat": p
}
]
}

Thanks in Advance

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.