Support Questions

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

How to convert plain text to JSON in Nifi

avatar

Hello there,

I have problem casting a plain text which is already in valid JSON format to JSON data type.

textdata.png

I want to it to convert the content type from text/plain to application/json.

I failed to do so by both ConvertRecord and AttributesToJSON.

For ConvertRecord, since it is not in any data format, none of the reader applies on such Flowfile.

For AttributesToJSON, I tried to use EvaluateJsonPath to put entire text into an attribute then used AttributesToJSON but the JSON object will become totally messed up especially with arrays and strings. (The actual data I am working with is more complicated than this example)

Anyone has good idea to do this?

Thanks in advance!

1 ACCEPTED SOLUTION

avatar
Master Guru

Here the MIME type for your flow file is set to text/plain, it is an attribute on the flow file called "mime.type". You can use an UpdateAttribute processor to set "mime.type" to "application/json".

View solution in original post

2 REPLIES 2

avatar
Master Guru

Here the MIME type for your flow file is set to text/plain, it is an attribute on the flow file called "mime.type". You can use an UpdateAttribute processor to set "mime.type" to "application/json".

avatar

Thanks Matt! Good to know that!