Correct Json Path to extract the data

Question

i have a json structure like that, where i would like to take from the json path the "id", but when i run the JSON input method in pentaho, putting "$..id" as the path, it returns me two lines about the same person, one containing the first id and the second one containing the second id (from the "photo"). What type of path should i use to take just the first id? ("id":"63b81795-83f0-4ffc-8ec3-6acc0236fcb5") "profile": {"email":"[email protected]", "id":"63b81795-83f0-4ffc-8ec3-6acc0236fcb5", "mobile":"85985119032", "name":"João Luiz Sampaio da Silva" "photo":{"filename":"20210610_152453.jpg", "id":"cdee6e2a-5bf7-4957-b5ee-3a82e1fc9f55", "mimetype":"image/jpeg", "path":"individual/ebf08be7-dfc5-4e24-97c6-abe3e5b56342/document/0dc3f588-ef55-41d8-bc33-1c88d1542df8/cdee6e2a-5bf7-4957-b5ee-3a82e1fc9f55.jpg"}} JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

json path always returns data as an array,even if it is just one item, so you have to take the first element var id = jsonPath(profile , "$.profile.id")[0]; //63b81795-83f0-4ffc-8ec3-6acc0236fcb5 to get a nested id var id = jsonPath(profile , "$['profile']['photo'].id")[0]; //cdee6e2a-5bf7-4957-b5ee-3a82e1fc9f55 //or var id = jsonPath(profile , "$..id")[1];