36
Views
20
Comments
Solved
[Data Anonymization] Mask is not working for Firstname
Question
data-anonymization
Service icon
Forge asset by OutSystems Lab
Application Type
Service

Hi

Masking is not working for firstname field.can anyone tell me what i am doing wrong?attaching OML file.need your help guys.

SKAN_Common_CS.oml
2022-12-09 16-04-44
Rodolfo Cardoso
Staff
Solution

The attribute paths are wrong with this example you should use:

$.FirstName and $.LastName

2023-06-14 08-52-52
Arkyadeep Bharadwaj

Another OML

SKAN_Member_Management.oml
2023-06-14 08-52-52
Arkyadeep Bharadwaj

If My Json is like below then what should be my Attribute Path for FirstName and LastName

{"Id":138,"MemberID":"MEM-3","StudyID":21,"PartnerID":2,"Firstname":"Srinivasan","Lastname":"Balakrishnan","Gender":"Male","Age":"41","Phonenumber":"82398792837","Study_eligibility_Age":41,"Study_eligibility_Gender":"Male","Study_eligibility_Education":" Primary School","Member_Status":3,"Eligibity_Status":1,"Member_consent":2,"Eligibility_count":1,"Createdby":596,"CreatedOn":"2023-02-26T14:30:25Z","UpdatedBy":596,"UpdatedOn":"2023-02-26T16:25:36Z","Approver":596,"Approveddatetime":"2023-02-26T16:14:44Z","Rejecteduser":596,"Rejectdateandtime":"2023-02-26T16:12:21Z","Reasonforreject":"Reject 2","FirstNameKey":"aRcyKJMT6I14P8Bxpx71E+KSBDyn5e/hawg96bMKQLCixgCNZa+jqSU7NIGqSpZTKaO3RGFu6aF0BLOE9VDtZydXT8hoGryMBrcCgeZtCJkynb4n9cEis3BhK711Pci0","LastNameKey":"xXRcLqcmqAzcWMHCI8RUfRq2aNwsGIC93VASedszbq53Zh/DHLMmQ5344RaUX2yMHskxb4kwQ4UZ0Qi25O2sKnzPK8MnT4MIvDOyISsyjivhvShuOhAfQ5l+hGh/4BGi","GenderKey":"SWUPn9Qi5alLpP9kmNP5KUxTRxD3ZAQMG5cJpOczqzyOA147Adh1az9H5W26vaIkJgFzRSiVtoyTpr9hpL/rAc1gElRchPPdSz9/oKpQ08Zln04pa/nICfgAt7thiT1p","AgeKey":"G0hbEB8lFORSjyrpkRv8VZ3GcB0nKAWAMNAmG/goTlKcxNnb+RAgOrAfTHhZwJMEh0ViUXKg8dPp23msVzgzNxvBHT81DvpTrOUrR8cPvqrqvlVb2mpQiGnZkMDLbzaX","PhonenumberKey":"9VjLzfZO0RiDW+WgzP8eNGtSEWkXPdp056djcYXwcNcduT7bIGMC/VBRDwloLuHjJrLEUlwmhduhMshPfGs79zasueRC8KS9cEtQxk3JYdK4I2oCDE3awcVXcsLhUORO","AadharKey":"vkF8R/MCoEqjtXiMiwfDCBHRGb1X7K+ShQuqdpUskAV6zxBSb5nq7NCxV004CZruSU2BmDFH+aUchYf4R3cuIvr3k9RynpWvbz3Utc9JUvu4xuj6xkzu54mT8IQFKmSu","PANCardKey":"l4DlW12iqQkD2BAzNUfzebZ+GUzFRuVjSfYGHgY20Whr6tVVXOF3aJq4SQc2ob7twFL8yemu5NRxzotSbjgBzZsGqHX4zWWQpYh+6O9VC0qQIxVfI2bRww7YYoIdBADr","PassportKey":"HYCsKf74r83yHe1e/AwzWbHv4v+Yx0DHAspN+QpV3MWndzgPBCapFu2d70lpBAB9vLopgCMkL4SGoyElayDSiVAj7E4I6OCKrw43BGBeuW+FgTcOkJ5NCVSxICYaGWuh","Permanent_HouseNumberKey":"Z9rNbE1n00xKptzYR/7ctG9lvHYQRdgDLkfLIuyDBv88yvA/PsdypzdiWCG4Pf3Ds7TIpnNSUCe8b/Q9PRWvsWgJc1xEpDl7JofzE9Vwgf7jo9VDcEbVAED3aB45tqUx","Permanent_ApartmentNameKey":"td1VwnyBvJZF3GKJeH1NAVYq1+TrDaCRizlKDXaB+nuB9IKOEBJ/JUbdGNPH9zLhaFj87t7EgQ2B5PzdZdVn9XCsBPQ5qri8nTBNeGlPtURxfWPsfgZPzsShjgaMz2j7","Permanent_StreetnameKey":"qcSds3ubWeePa72bWml/LnlNu199pLsxqKlQohnfkjieDtzFeonJP3+IM6T8Gd+n2PkTLHQI2wWJDdkZEQKFyesWVSNoi5ulumr2TT1P0mgrB7zLhYhYWcoV2s/F7xpM","Permanent_AreaNameKey":"ysjWaK20G1uJTIQ+bZ1Qv2w2bfhTrRNsQgNxctUbjWwE5p4ZNXJ0d7WBce0Lkd5KN5u6N4nvpLx3RuqbYndWbvSqBfsRTw9WEpOTM2320ujgwdlKRKKOAHpuP7UgS1Jc","Permanent_LandmarkKey":"em+Wg6tERbNZ/7FuHdfliNND598oUhqhRRLu8D3OwNDs5P2o638bpQS+8RVdr1gHcUtgmgos6oKRK4GnpuzCNqH011jbschFVgg/dtMqLmvy5uFMEp5tm3BgOSO6zeRf","Permanent_PincodeKey":"KxuYLg5MzpivZhmoOTTlc73kdMsffrvO6LeEdwEhx8PT3QxN1mXoHYWJtXo11D9jM7FoiIUHv0OKl8e6kl6JlI7ng70p4GsCI5DA1w7n1sNE9jQbfSjnbR7vUFyZECfN","Present_HouseNumberKey":"PM5Zxk7fQVML4DK7LKzo4jRAulrI6pR/EKmFoEzltJRe/EbKhrKe5hzsnQO+UNot51jRvkXc5AjBh6Jg3ZrMy6v5ngzG4ZudulamgNZJpNYXl0dw3vSDBgthTpnHvsIw","Present_ApartmentNameKey":"221BXBJ8ncwAC3bnweyBLXq3X8fU2vUYObS6Hwtn9AGjUhBQ6VvGT9LXafMlBxVSgyWkkB6qfyjIVGbO9Qu2JqEJhPxeCgWup+wnhlJg3r2X/cl+U5S2TPBl9EwZj89j","Present_StreetnameKey":"yzO7wrDKI8LH2eKGMvHPHJL6w5zebQ6faKOJNGj+9jGHVcX0rmQ+w1zlFcGVv4lJwPlQp8hT+8xcvxbLnIsn2ENhEL25Ca3Yfd7pr1x2F8l7tDd+UYk7S+XWV1SG7UtE","Present_AreaNameKey":"l/4VH+prxuDe3UIKx/87Gd4s/kO2wRLPGgSEQkLNI+RMhm3awwzpUYZJz+IW7iTiB/Eo/Jv09LOQairMl4ZQXZorYvVdEJGsxTcuMCiVrh6aQ8SK0FHhwlHKoqbFiSpw","Present_LandmarkKey":"E5rav1dXIrJ5kbsWX27jfz/1O0byr51jMPTpjuq216B0j1obt5hSNdoNX5WSZsXg9qQdt+vlQMLO6bzjfcwPEaAeDRkLfR99wZNjqrr2T0NJyFFwq9Z3xyoUmlQrkd89","Present_PincodeKey":"NfEnW/UbIfFUQB58ZzrlFJTiOf3n/qj+RiPtUjbavPZz1kO7BOPq5DNU9BMlvy3yYwOPx7N03LtoMvFrtzDWdWWhMOrtFW8E8ZBbE0EOsk3QuQ951z3LJxHdQCBTOpZt","MemberEligibleForm":1095}

2022-12-09 16-04-44
Rodolfo Cardoso
Staff

Hi @Arkyadeep Bharadwaj ,

From the JSON you present the JSONPath would be $.Firstname, but if you want to apply it to a list of objects with the JSON format you present it would be $[*].Firstname.

Please look at this JSONPath online validator https://jsonpath.com/ and the rules https://goessner.net/articles/JsonPath/index.html#e2 

2023-06-14 08-52-52
Arkyadeep Bharadwaj

getting below json.plz help me to resolve this issue.

{"Id":175,"MemberID":"MEM-5","StudyID":28,"PartnerID":3,"Firstname":"Arkyadeep","Lastname":"bharadwaj","Gender":"Male","Age":"37","Phonenumber":"9830196507","Member_Status":5,"Createdby":579,"CreatedOn":"2023-02-28T11:57:05Z","FirstNameKey":"PT/yEP98EKfMtpurRTAMmjhXM5FVueBAwjkWfwKDsovkneTuk6gzDHGQ6QSUwdYRymxAzPRWJEJPf2TJFEJGNB3BQrKj++btEmHhZgBL/zcfzl0JlkcUBM7auRs9gKYJ","LastNameKey":"10fZF9hS/b8AeQMROGYOf6hXhn/erOgsWv4x2otq+y3NeZ+joj/UmUv6On2ZEP7ZN/lJUcTxYn6AOVUH+f9UUmHhvAyM4iaxoNkjTa7wr4ChDDlbWiyefIZxzezF6UQC","GenderKey":"B1wNsgYNHQ7oJ/RwDddeuUOPHX+9GvBbcPsj7CJRF25GAI/88sKpp+Y1uVhSpfA4YxIupM0XJPmOq666BHL5a8FFO6N1LSW3y8XbHds9dY4o8fttGMKh13C1e0louF18","AgeKey":"JPU140Av6FmbMoAIct6lNtta15PyY/if1A4VlzHAaxG0Ct7FN5aBPvKwCniWz7+jM+KFZKJgxkD9jkbNQo+iBVmDbtbV6z5VrLgX+Q8ljq50Z6EwG5GipqUPW4ZCpYTK","PhonenumberKey":"uYszt0IZuHfBZvBu8Wq6UEfxJ1wmbBXUpNu8g30cD1JlTAvnkE9i6Qj35LeZRHEUH84kTgXD8kUzF4GXn3Yb6eCo7LwIso/tJRQ0lAWycnin/3p1Z7aS31/c53XJsTUY"}

2023-06-14 08-52-52
Arkyadeep Bharadwaj

after changing the node still we are facing issue.

2023-06-14 08-52-52
Arkyadeep Bharadwaj

still i am getting below

2022-12-09 16-04-44
Rodolfo Cardoso
Staff

What's the error you are getting on service center?

Did you tried to debug and check exactly where the error is coming from?

2023-06-14 08-52-52
Arkyadeep Bharadwaj

not getting any error but masking is not happening

with below JSON

{"Id":175,"MemberID":"MEM-5","StudyID":28,"PartnerID":3,"Firstname":"Arkyadeep","Lastname":"bharadwaj","Gender":"Male","Age":"37","Phonenumber":"9830196507","Member_Status":5,"Createdby":579,"CreatedOn":"2023-02-28T11:57:05Z","FirstNameKey":"PT/yEP98EKfMtpurRTAMmjhXM5FVueBAwjkWfwKDsovkneTuk6gzDHGQ6QSUwdYRymxAzPRWJEJPf2TJFEJGNB3BQrKj++btEmHhZgBL/zcfzl0JlkcUBM7auRs9gKYJ","LastNameKey":"10fZF9hS/b8AeQMROGYOf6hXhn/erOgsWv4x2otq+y3NeZ+joj/UmUv6On2ZEP7ZN/lJUcTxYn6AOVUH+f9UUmHhvAyM4iaxoNkjTa7wr4ChDDlbWiyefIZxzezF6UQC","GenderKey":"B1wNsgYNHQ7oJ/RwDddeuUOPHX+9GvBbcPsj7CJRF25GAI/88sKpp+Y1uVhSpfA4YxIupM0XJPmOq666BHL5a8FFO6N1LSW3y8XbHds9dY4o8fttGMKh13C1e0louF18","AgeKey":"JPU140Av6FmbMoAIct6lNtta15PyY/if1A4VlzHAaxG0Ct7FN5aBPvKwCniWz7+jM+KFZKJgxkD9jkbNQo+iBVmDbtbV6z5VrLgX+Q8ljq50Z6EwG5GipqUPW4ZCpYTK","PhonenumberKey":"uYszt0IZuHfBZvBu8Wq6UEfxJ1wmbBXUpNu8g30cD1JlTAvnkE9i6Qj35LeZRHEUH84kTgXD8kUzF4GXn3Yb6eCo7LwIso/tJRQ0lAWycnin/3p1Z7aS31/c53XJsTUY"} 

2023-06-14 08-52-52
Arkyadeep Bharadwaj

hi

i am trying to build details page in ur application then also it is working.i am attaching the OML.can you please check,i need this thing very badly.

DataAnonymization_LIB.oml
DataAnonymization_Demo.oml
2022-12-09 16-04-44
Rodolfo Cardoso
Staff

You are applying a Shuffle rule. The shuffle rule will only work with lists of values. Imagine that you have a list of customers, the shuffle rule will take all Names of customers, shuffle them, and apply them randomly.

In your specific case I would set the rule to Randomize or Mask.

Also, the anonymization rule is case sensitive meaning that if you have $.FirstName it will work if the entity attribute is FirstName and not with Firstname.

2023-06-14 08-52-52
Arkyadeep Bharadwaj

for record detail purpose which rule i can apply.do u have any list

2023-06-14 08-52-52
Arkyadeep Bharadwaj

after changing that still it is not working.i am attaching the OML if u have time can you check plz in the attached OML.

DataAnonymization_LIB.oml
DataAnonymization_Demo.oml
2023-06-14 08-52-52
Arkyadeep Bharadwaj

did u get a chance to check.i need your help sir.

2022-12-09 16-04-44
Rodolfo Cardoso
Staff
2023-06-14 08-52-52
Arkyadeep Bharadwaj
2022-12-09 16-04-44
Rodolfo Cardoso
Staff

The OML doesn't bring the rules, as they are transactional data on the database. For the mask rule you should set a regex as well.

For example, if you set the mask on the Firstname with the Regex (?<=[A-Za-z])[a-z] and replace *

Rodolfo Cardoso will be set to R****** C*******


Here is an example of the regex workin: https://regex101.com/r/e1FVI8/1

2023-06-14 08-52-52
Arkyadeep Bharadwaj
2022-12-09 16-04-44
Rodolfo Cardoso
Staff
Solution

The attribute paths are wrong with this example you should use:

$.FirstName and $.LastName

2023-06-14 08-52-52
Arkyadeep Bharadwaj

do you know where we can generate the regular expression.any online portal is there or not?

2023-06-14 08-52-52
Arkyadeep Bharadwaj

no error is generating in Service center.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.