How to convert plain text to JSON in Nifi

[#1]

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!

[#2 · Accepted solution]

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".

[#3]

Thanks Matt! Good to know that!