question Re: Apache NIFI SplitJson correct Json path expression. in Support Questions

Apache NIFI SplitJson correct Json path expression.

vivek_b3ds — Fri, 06 Apr 2018 18:54:00 GMT

I am trying to split an array of record using SplitJson processor. But it fails to split the record. I am unable to find the correct expression for my json.
Here is my json

[
{"id":"30fb76fa-acbe-463b-830e-66f203bb0911","session_id":"804e8d5b-c266-92b7-4a1d-eed3650d3b4a","tag_name":"call"},
{"id":"23986d19-c91f-4d98-8cfd-08fb26c5ff85","session_id":"804e8d5b-c266-92b7-4a1d-eed3650d3b4a","tag_name":"direct-call"},
{"id":"7c374ae9-b96a-4383-85ce-6d45cbc5f8a4","session_id":"804e8d5b-c266-92b7-4a1d-eed3650d3b4a","tag_name":"homepage"},
{"id":"599bf3e0-2c76-4d38-8349-91cc04e34c33","session_id":"b8f17ef9-d7df-dec0-71e3-3ed28991d396","tag_name":"bounce"},
{"id":"55791f8a-3243-48b3-bb4a-70404a21148d","session_id":"b8f17ef9-d7df-dec0-71e3-3ed28991d396","tag_name":"homepage"}
]

I want split each record as seprate flowfile, means there will be five flow files.
What is the correct Json path expression ?

Re: Apache NIFI SplitJson correct Json path expression.

MattWho — Sun, 18 Aug 2019 05:12:42 GMT

@Vivek Singh

Try the following configuration in your splitJson processor:

Thanks,

Matt

If you found this answer addressed your initial question, please take a moment to login and click "accept".

Re: Apache NIFI SplitJson correct Json path expression.

ottobackwards — Sat, 07 Apr 2018 02:20:25 GMT

try $.[*] or $[*]

http://jsonpath.herokuapp.com/ is a good place to practice

https://github.com/json-path/JsonPath for documentation