convert json to colume based text in NIFI

[#1]

Hi I am looking to convert a json file in Nifi and have been playing around with a few processors like convert record.

The below is json I am receiving -

{
  "report" : "file1.CSV",
  "Report Date" : "2022-02-09 13.24.58",
  "reject" : "0",
  "total" : "7",
  "processed" : "7"
}

And needs to be converted to a text file in columnar/dictionary format though and should look like this -

"report" | "file1.CSV"|
"Report Date" | "2022-02-09 13.24.58"|
"reject" | "0"|
"total" | "7"|
"processed" | "7"

Its quite straight forward to just replace the "," with "|" and remove the "{}" but I was wondering is there a way to write to a column based text file?

[#2]

Use a ConvertRecord processor with a JsonTreeReader as the record reader and a CSVRecordSetWriter as the record writer.

Configure the CSVRecordSetWriter with the following:

HTH,

André