NiFi | Json Parsing using Nifi Expression

shashi_vish123 — Mon, 23 Jan 2017 18:44:39 GMT

I am trying to parse my json using Nifi Expression language - jsonpath

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

Its uses '.' for node traversal. If json which has one node name with '.' in it.

Below is sample json

{"feedName":"trigger_category.childfeed123",
"feedId":"eff68e0b-a9e6-4c11-b74f-53f161a47faf",
"dependentFeedNames":["trigger_category.test_shashi"],
"feedJobExecutionContexts":{"trigger_category.test_shashi":[{"jobExecutionId":23946,
"startTime":1485145059971,
"endTime":1485145111733,
"executionContext":{"feedts":"1485145061170"}}]},
"latestFeedJobExecutionContext":{"**trigger_category.test_shashi**":{"jobExecutionId":23946,
"startTime":1485145059971,
"endTime":1485145111733,
"executionContext":{"**feedts**":"1485145061170"}}}}

I am trying to read feedts but its parent node 'trigger_category.test_shashi' has dot ('.') in it. How do i escape "."character?

Re: NiFi | Json Parsing using Nifi Expression

pvillard — Mon, 23 Jan 2017 18:59:52 GMT

Hi @Shashi Vish,

The following should be working :

$.feedJobExecutionContexts.['trigger_category.test_shashi']

Keep in mind to set 'return type' to 'json' in your EvaluateJson processor.

Hope this helps.

Re: NiFi | Json Parsing using Nifi Expression

shashi_vish123 — Tue, 24 Jan 2017 08:24:31 GMT

Thanks... It worked...

question NiFi | Json Parsing using Nifi Expression in Archives of Support Questions (Read Only)

NiFi | Json Parsing using Nifi Expression

Re: NiFi | Json Parsing using Nifi Expression

Re: NiFi | Json Parsing using Nifi Expression