question Re: How to extract Text from JSON in Archives of Support Questions (Read Only)

How to extract Text from JSON

vikram_anand — Sat, 11 Feb 2017 05:15:21 GMT

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?

Re: How to extract Text from JSON

arunak — Sat, 11 Feb 2017 05:18:06 GMT

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

Re: How to extract Text from JSON

vikram_anand — Sat, 11 Feb 2017 05:19:32 GMT

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

Re: How to extract Text from JSON

mburgess — Sat, 11 Feb 2017 05:30:34 GMT

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

Re: How to extract Text from JSON

arunak — Sat, 11 Feb 2017 05:32:07 GMT

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