Hi
This is the input file
[
{
"IPV4": [
{
"utc": "1483589451",
"pbid": "2",
"ptid": "0",
"pp": "0",
"bp": "0",
"tp": "598",
"tb": "2950",
"dt": [
{
"pcol": "01",
"pp": "0",
"bp": "0",
"tp": "16",
"tb": "500",
"sip": [
{
"ip": "1.1.1.1",
"pp": "0",
"bp": "0",
"tp": "16",
"tb": "500",
"dip": [
{
"ip": "5.5.5.5",
"pp": "0",
"bp": "0",
"tp": "9",
"tb": "200",
"spo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "9",
"tb": "200",
"dpo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "9",
"tb": "200"
}
]
}
]
},
{
"ip": "6.6.6.6",
"pp": "0",
"bp": "0",
"tp": "7",
"tb": "300",
"spo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "7",
"tb": "300",
"dpo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "7",
"tb": "300"
}
]
}
]
}
]
}
]
},
{
"pcol": "02",
"pp": "0",
"bp": "0",
"tp": "5",
"tb": "2450",
"sip": [
{
"ip": "2.2.2.2",
"pp": "0",
"bp": "0",
"tp": "1",
"tb": "1250",
"dip": [
{
"ip": "7.7.7.7",
"pp": "0",
"bp": "0",
"tp": "1",
"tb": "500",
"spo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "1",
"tb": "500",
"dpo": [
{
"pt": "00",
"pp": "0",
"bp": "0",
"tp": "1",
"tb": "500"
}
]
}
]
}
]
}
]
}
]
}
]
}
]
This is my desired output json
{
"protocol": "IPV4",
"pbid": "2",
"utc": "1483589451",
"ptid": "0",
"pp": "0",
"bp": "0",
"tp": "22",
"tb": "1000",
"sip.ip": "1.1.1.1",
"sip.pp": "0",
"sip.bp": "0",
"sip.tp": "17",
"sip.tb": "500",
"sip.dip.ip": "5.5.5.5",
"sip.dip.pp": "0",
"sip.dip.bp": "0",
"sip.dip.tp": "9",
"sip.dip.tb": "200",
"sip.dip.spo.pt": "00",
"sip.dip.spo.pp": "0",
"sip.dip.spo.bp": "0",
"sip.dip.spo.tp": "9",
"sip.dip.spo.tb": "200",
"sip.dip.spo.dpo.pt": "00",
"sip.dip.spo.dpo.pp": "0",
"sip.dip.spo.dpo.bp": "0",
"sip.dip.spo.dpo.tp": "9",
"sip.dip.spo.dpo.tb": "200"
},
{
"protocol": "IPV4",
"pbid": "2",
"utc": "1483589451",
"ptid": "0",
"pp": "0",
"bp": "0",
"tp": "22",
"tb": "1000",
"sip.ip": "1.1.1.1",
"sip.pp": "0",
"sip.bp": "0",
"sip.tp": "17",
"sip.tb": "500",
"sip.dip.ip": "6.6.6.6",
"sip.dip.pp": "0",
"sip.dip.bp": "0",
"sip.dip.tp": "8",
"sip.dip.tb": "300",
"sip.dip.spo.pt": "00",
"sip.dip.spo.pp": "0",
"sip.dip.spo.bp": "0",
"sip.dip.spo.tp": "8",
"sip.dip.spo.tb": "300",
"sip.dip.spo.dpo.pt": "00",
"sip.dip.spo.dpo.pp": "0",
"sip.dip.spo.dpo.bp": "0",
"sip.dip.spo.dpo.tp": "8",
"sip.dip.spo.dpo.tb": "300"
},
{
"protocol": "IPV4",
"pbid": "2",
"utc": "1483589451",
"ptid": "0",
"pp": "0",
"bp": "0",
"tp": "22",
"tb": "1000",
"sip.ip": "2.2.2.2",
"sip.pp": "0",
"sip.bp": "0",
"sip.tp": "5",
"sip.tb": "500",
"sip.dip.ip": "7.7.7.7",
"sip.dip.pp": "0",
"sip.dip.bp": "0",
"sip.dip.tp": "5",
"sip.dip.tb": "500",
"sip.dip.spo.pt": "00",
"sip.dip.spo.pp": "0",
"sip.dip.spo.bp": "0",
"sip.dip.spo.tp": "5",
"sip.dip.spo.tb": "500",
"sip.dip.spo.dpo.pt": "00",
"sip.dip.spo.dpo.pp": "0",
"sip.dip.spo.dpo.bp": "0",
"sip.dip.spo.dpo.tp": "5",
"sip.dip.spo.dpo.tb": "500"
}