Support Questions

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

NiFi CSV to Json with Json object string as value

avatar
Explorer

Hi, I am looking for the way to convert the CSV to JSON

I have a csv file with json object as value,

 

"name","item"

"david","{""currency"":""USD"",""content"":""Beauty Lips""}"

 

 

I used ConvertRecord processor with CSVReader and JsonRecordSetWriter

And the output JSON is

 

{
  "name":"david",
  "item":"{\"currency\":\"USD\",\"content\":\"Beauty Lips\"}"
}

 

But what I expected is

 

{
  "name":"david",
  "item":{"currency":"USD","name":"Beauty Lips"}
}

 

 

How can I archive this?

Thank you

 

David

1 ACCEPTED SOLUTION

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login