The Delphix product logic can't distinct the nodes, the existing Professional Services JSON plugin can't distinct them either, it uses a custom JSON parser that has been written some years ago. The new JSON_PATH plugin is using JSONPath logic that allows to create complex query expressions for JSONPath statements. See on www.jsonpath.com the abilities of JSONPath. Old plugin: JSON, new plugin JSON_PATH. As suggested please contact your CSM.
Original Message:
Sent: 03-04-2025 06:25:13 AM
From: pankaj asegaonkar
Subject: Delphix Masking - How to Mask particular values in JSON array
Hello Tino
Thanks a lot for your replay.
Kindly let me know if we use the existing JSON plugin then it is not possible to mask this? with path "custom_fields.[7].value"?
Usually JSON plugin should have to support this path as this is standard XPATH for that json.
When we tried with above path masking has not been applied, kindly let me know how to achieve this with JSON plugin.
------------------------------
Pankaj Asegaonkar
Masking/Virtualization Specialist
+91 9689996500
Original Message:
Sent: 03-04-2025 04:08:03 AM
From: Tino Pironti
Subject: Delphix Masking - How to Mask particular values in JSON array
Professional Services have developed a new extensible masking plugin that has the capability to use a JsonPath argument alike:
$.custom_fields[?(@.id==\"contact_data_of_customer\")].value
to identify the single node and mask only that one.
Please get in touch with your Customer Success representative if you are interested.
------------------------------
Tino Pironti
Masking SME
Technical Manager
Delphix
Original Message:
Sent: 03-03-2025 08:56:55 AM
From: pankaj asegaonkar
Subject: Delphix Masking - How to Mask particular values in JSON array
Hello Team,
Kindly help me how to mask particular value from JSON array.
Example:
I would like to mask the 8th values from below json array.
[
"custom_fields" : [ {
"id" : "order_id",
"value" : "eeeeeee"
}, {
"id" : "product_order_item_id",
"value" : "eeeee"
}, {
"id" : "product_offer_id",
"value" : "ttttttt"
}, {
"id" : "geographic_address_id",
"value" : "yhhhfhh"
}, {
"id" : "order_action",
"value" : "fry"
}, {
"id" : "remarks",
"value" : "dhdhdhd"
}, {
"id" : "order_type",
"value" : "dhdhdhdh"
}, {
"id" : "contact_data_of_customer",
"value" : "Pankaj Aseeeeeeee" --> How to mask this value.
}, {
"id" : "start_date_of_appointment",
"value" : "gghfd"
}, {
"id" : "end_date_of_appointment",
"value" : "ffff"
}, {
"id" : "utac",
"value" : "gdfgdfgdg"
}, {
"id" : "feeder_connection_reference",
"value" : "dgdgdgdfgdgf"
} ],
I have tried with JSON plugin with below path but it it is masking all values present in JSON
custom_fields.[7].value -- No masking happening
custom_fields/value -- masking all values in json file
I would like to mask the specific JSON below value, how to mask it, kindly help me on this
{
"id" : "contact_data_of_customer",
"value" : "Pankaj Aseeeeeeee" --> How to mask this value.
},
------------------------------
Pankaj Asegaonkar
Masking/Virtualization Specialist
+91 9689996500
------------------------------