How to extract Text from JSON

[#1]

Hi I have a JSON:

{ "eventType": "E21",

"hGuid": "125345360514082014",

"aGuid": "227345360514082014",

"timestamp": 1486273085000,

"eventFields": { "save": { "greeting": "How can we help?", "actions": [{ "action": "Track", "displayText": "Recently Ordered." }], "actions": ["Hello", "Returns", "Ask?"] } }

}

I want to extract the whole data under eventFields as a text. How can I do that in Nifi?

[#2 · Accepted solution]

Use https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.EvaluateJsonPa... $.eventFields should give you the content of the eventFields as a single text

[#3]

That does not work as it says cannot convert to scalar form

[#4]

Try explicitly setting the Return Type as 'json' rather than 'auto-detect' or 'scalar'.

[#5]

json-test.xml I tried this for your input json