Problem with EvaluateJsonPath

[#1]

I'm really struggling not understanding what the heck is going on with EvaluateJsonPath.

Here is the JSON:

[
{
"name": "garyDawgJson"
}
]

Here is the flow:

main.jpg(61.7 kB)

Here is the EvaluateJsonPath:

json.jpg(32.9 kB)

When I look in the Data Provenance, the "thename" attribute never gets set.

event.jpg(35.9 kB)

What the heck is going on?

Thanks, Gary

[#2]

@Gary Mullen-Schultz

You are having array of json and trying to extract name value as attribute to the flowfile.

Configure EvaluateJsonPath processor as below:

thename

$.[0].name

So by using above path we are navigate array and extracting name value.

Correct way of doing this is..

Use SplitJson processor

Configure processor as

$.*

Using splitjson processor we are splitting json array into individual flowfiles..

then use EvaluateJsonPath processor add new property as

thename

$.name

-

If the Answer helped to resolve your issue, Click on Accept button below to accept the answer, That would be great help to Community users to find solution quickly for these kind of issues.

[#3]

Stu:

Thanks, that was it! I couldn't find that in my Google searches.

Appreciate the help!

Gary