Add JSONPath Support to JSON Field Match Evaluator

[mmabrouk]

Problem

Currently, the JSON Field Match evaluator only supports simple field matching. Users working with nested JSON structures need to extract values from deeply nested or multiple parent fields, which isn't possible with the current implementation.

Use Case

A user has a schema that outputs:

{
  "parent1": {
    "analysis": "...",
    "result": "value1"
  },
  "parent2": {
    "analysis": "...", 
    "result": "value2"
  }
}

They want to match different columns with:

• $.parent1.result
• $.parent2.result
• And other nested paths

Proposed Solution

Add JSONPath syntax support to the JSON Field Match evaluator, allowing users to specify paths like:

• $.parent1.result
• $.parent2.analysis
• $.data.items[0].value

Original request from Pierre:

Hi! This may have already been requested, but it would be nice to be able to use JSONPath with the JSON Field Match evaluator. I am using a schema that outputs an "analysis" and "result" field as children of different parent fields. JSONPath would allow me to match one column with $.parent1.result, another with $.parent2.result and so on. (edited)