search cancel

TDM masking in json file

book

Article ID: 240897

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Need to mask a json fiile for the below 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 as "MSGID" in the tool instead of filed value 

"fieldValue":"AB123456",

 "fieldType":"CHAR",

 "fieldId":"MsgId"

Environment

Release : 4.9.1

Component :

Resolution

Use the JSON path as    documentsList[0].changedFieldsList[?(@.fieldId=='MsgId')].fieldValue

and choose the masking function to run the mask. I have attached masking rule file I have used in my local and I am able to run the masking.