Support Questions
Find answers, ask questions, and share your expertise

SplitJson is giving only last record instead of all record

New Contributor

I am having following json output coming from Executeinfluxdbquery

{"results":[{"series":[{"name":"system_load1","columns":["time","host","value"],"values":[[1.5374502E18,"ilcepoc555",12.79],[1.5374502E18,"ilcepoc556",3.56],[1.5374502E18,"ilcepoc557",1.83],[1.5374502E18,"ilcepoc559",4.68]]}]}]}

And i am using splijson to create multiple flow file but it is generating 4 flow file of same output [1.5374502E18,"ilcepoc559",4.68] . I am using $.results[0].series[0].values.* in Jasonpathexpression property.

2 REPLIES 2

Super Guru
@Rohit Gupta

I tried same exact flow and SplitJson Processor resulting 4 flowfiles with different output contents.

flowfile(ff)1:

[1.5374502E18,"ilcepoc555",12.79]

ff2:

[1.5374502E18,"ilcepoc556",3.56]

ff3:

[1.5374502E18,"ilcepoc557",1.83]

ff4:

[1.5374502E18,"ilcepoc559",4.68]

SplitJson Configs:

91518-screen-shot-2018-09-20-at-72804-pm.png

Once make sure your configs are same in SplitJson processor.As we are not able to reproduce the same exact issue that you have faced.

New Contributor

its not working . i had restarted nifi as well .

Nifi version is nifi-1.7.1 .

capture.png

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.