Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

how can i use Evaluate Json Path for nested json

avatar
New Contributor

Hi

i have below json file and i need to use Evaluate Json Path 

 

{
"busId":1,
"speed":80,
location":{"lat":21.336742,"lon":39.6303}
}

 

is working fine but when i add location Evaluate Json Path return error transferring  failure

1 ACCEPTED SOLUTION

avatar
Super Guru

Here is working processor:

Screen Shot 2019-11-04 at 12.50.19 PM.png

Your value would be $.busId, $.speed, $.location

 

Nested values are:

 

$.location.lat

$.location.long

 

 

Also make sure the sample json is "location"  (" missing in your sample above).

 

 

View solution in original post

1 REPLY 1

avatar
Super Guru

Here is working processor:

Screen Shot 2019-11-04 at 12.50.19 PM.png

Your value would be $.busId, $.speed, $.location

 

Nested values are:

 

$.location.lat

$.location.long

 

 

Also make sure the sample json is "location"  (" missing in your sample above).