Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Nifi Nested JSON flowfile into multiple flowfiles with parent JSON

avatar
New Contributor

Hello,

 

I wanted to parse the following JSON file flow file

 

{
"vehicle_speed": 657,

"vehicle_temp": 99,

"sensor_level": 45,
"temp": [
{
"sensor_number": 0,
"sensor_description": "Exists",
"sensor_name": 43
},
{
"sensor_number": 1,
"sensor_description": "Exists",
"sensor_name": 31,
}
],
"timestamp": 161903601000


}

 

into two flow files ("temp" element value is dynamic and can contain different number of json not necessarily two as in this example)

 

{
"vehicle_speed": 657,

"vehicle_temp": 99,

"sensor_level": 45,
"sensor_number": 0,
"sensor_description": "Exists",
"sensor_name": 43,
"timestamp": 161903601000

}

 

and 

 

 

{
"vehicle_speed": 657,

"vehicle_temp": 99,

"sensor_level": 45,
"sensor_number": 1,
"sensor_description": "Exists",
"sensor_name": 31,
"timestamp": 161903601000}

1 REPLY 1

avatar
Contributor

I think you can solve it with JOLT Transform.