question Re: How to convert plain text to JSON in Nifi in Archives of Support Questions (Read Only)

How to convert plain text to JSON in Nifi

fangzhouye94 — Tue, 09 Jan 2018 04:01:59 GMT

Hello there,

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

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!

Re: How to convert plain text to JSON in Nifi

mburgess — Tue, 09 Jan 2018 06:05:14 GMT

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

Re: How to convert plain text to JSON in Nifi

fangzhouye94 — Thu, 11 Jan 2018 05:28:28 GMT

Thanks Matt! Good to know that!