How to use JSON path when masking a json file in TDM

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Need to mask a json fiile for the value ""AB123456" but the FDM tool identifies the xpath as $['documentsList'][0]['changedFieldsList'][0]['fieldValue'].

Can we identify the column using the column name directly, for example "MsgId", in the tool instead of the field value?

"fieldValue":"AB123456",

 "fieldType":"CHAR",

 "fieldId":"MsgId"

Environment

Release : 4.9.1

Component : FDM

Resolution

Use the JSON path as:

documentsList[0].changedFieldsList[?(@.fieldId=='MsgId')].fieldValue

and choose the masking function to run the mask.