Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to extract Text from JSON

avatar
New Contributor

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?

1 ACCEPTED SOLUTION

avatar
Super Collaborator
4 REPLIES 4

avatar
Super Collaborator

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

avatar
New Contributor

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

avatar
Master Guru

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

avatar
Super Collaborator

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