Split array of strings and put each string on a flow-file-attribute in nifi

Question

I try to extract each element from the frequentlyBoughtTogether array and put it on a flow-attribute:

{
   frequentlyBoughtTogether: ["a","b","c"]
}

Frist step: SplitJson

Second step: EvaluateJsonPath to make each element a flow-file-attribute:

However this gives me following error:

When I log the failure, I can see the element in the flow-file-content, but I need it to be an attribute. Any ideas how to solve this issue?

notNull · Accepted Answer · 2018-11-03 15:47:39Z

2

Use ExtractText processor instead of EvaluateJsonPath processor.

in case of EvaluateJsonPath processor evaluates the flowfile content if the content is not a valid json then processor routes the flowfile to failure)
In case of Extract Text processor just extracts the content of the flowfile by applying the regex. ExtractText configs: Add new property as

val

(.*)

Then processor adds new attribute names val to the flowfile by extracting the flowfile content as value.

Flow:

SplitJson->ExtractText

answered Nov 3, 2018 at 15:47

notNull

31.8k4 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1