question Re: Apache Nifi - Adding attributes as newlines FlowFilw content in Support Questions

Apache Nifi - Adding attributes as newlines FlowFilw content

obaid_salikeen — Tue, 02 Aug 2016 21:57:01 GMT

Hi,

I have a scenario where My GetHTTP processor gets a JSON of system health metrics. I extract the attributes from the Json to essentially extract the desired metrics that I want to display on a Graph.

Input: Suppose following attributes I extracted from Json using EvaluateJSONPath processor:

metric1='<myconmapy>.<metric1> <value> <timestamp>'

metric2='<myconmapy>.<metric2> <value> <timestamp>'

metric3='<myconmapy>.<metric3> <value> <timestamp>'

Output: I want to convert all the above mentioned attributes/metrics as lines of FlowFile content, such that one FlowFile content will look like following (each line contains an attribute value):

Is there a way to achieve the above mentioned Output using Nifi processors?

Thanks

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

andrewg — Tue, 02 Aug 2016 22:05:41 GMT

Yes, use a ReplaceText processor and NiFi's Expression Language syntax to reference your attributes and construct the content line. Tip: switch the evaluation mode for ReplaceText to 'Always Replace' as an optimization for your use case.

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.ReplaceText/index.html

https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

obaid_salikeen — Tue, 02 Aug 2016 22:13:46 GMT

Awesome, I solved it by using the append('\n') for attribute:

${m1:append('\n')}${m2:append('\n')}${m3}

Thanks a lot,

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

JoeWitt — Sun, 18 Aug 2019 11:56:38 GMT

When entering text values into NiFi you should be able to hit "Shift-Enter" and it will give you true new lines. See attached screenshot

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

MattWho — Wed, 03 Aug 2016 00:48:29 GMT

@Obaid Salikeen

Try using \\n (double backslash) or using 'Shift + enter" in the expression language editor box to create new lines in your replacement string as shown by Joe Witt above. Thanks,

Matt

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

jthomas_t_king — Fri, 18 Nov 2016 23:27:12 GMT

Joe - What processor is being illustrated?

Re: Apache Nifi - Adding attributes as newlines FlowFilw content

anubhav_r_raika — Fri, 02 Dec 2016 20:06:40 GMT

yeah thanks.. append works.. \\n (double backslash) doesnt.. I was doing this while writing count to file.. it now works.. The count is: ${executesql.row.count:append('\n')}