Splitting JSON and Handling null flowfile content | BestBuy Dataflow | Apache Nifi | Part 3

[@marinamaayah6899]

Thank you for videos, could we have a video to getsolar ,getsft processor. and if we need to get all logs in EDR using NIFI how to do that?

[@sunilzwengineer]

Hi. Can you let me know how we can take backup of dataflow .when the nifi is restarted all data flow are lost. Is there a way to backup nd restore dataflow when the nifi server goes for restart

[@StevenKoon]

Try this out. th-cam.com/video/czGxFkxB7JA/w-d-xo.html

[@kabyasingh2721]

Hello sir.. I am trying to add value from json to SQL db .. which processor to use.. there is small transformation that is required too

[@StevenKoon]

Use either putDatabasrRecord or PutSql. The first one will allow you to insert one flowfile with multiple rows in it at once and the other will only insert one flowfile record at a time. Depending on the transformation that you need to do you could use queryRecord before.

[@kabyasingh2721]

@@StevenKoon thank you.

[@StevenKoon]

You can also find a example of me using and setting up these processor in this video. th-cam.com/video/9X8DJGXMra4/w-d-xo.html

[@tieuhoangduy]

Hi sir. Can help me.
I user ConvertAvroToJSON to format data after query in my DB.
and my data is with setting View as original
"{"workflow_id": 25, "entity_id": 61}
{"workflow_id": 25, "entity_id": 63}
{"workflow_id": 25, "entity_id": 65}
{"workflow_id": 25, "entity_id": 68}"
so i use SplitJson to split it.
my expect are 4 Json
"{"workflow_id": 25, "entity_id": 61}",
"{"workflow_id": 25, "entity_id": 63}",
"{"workflow_id": 25, "entity_id": 65}" and
"{"workflow_id": 25, "entity_id": 68}"
But does't work. My JsonPath Expression is "$.*" . I tried to replace it with other characters but it didn't work.
is there any way you can help me?
Thank u and sorry for my english!