Comments
4 comments
-
Hi Frank,
Have you had a look of this documentation? https://documentation.red-gate.com/dms6/data-masker-help/masking-rules/about-xml-masker-rules
If you still require further assistant, can you attach your masking set? -
Hi Tianjiao Li,
Thanks for your reply - I did read the documentation and after some trial and error was able to work it out.
I had to work out the XPath specification - but once that was done it worked perfectly.
If anyone else is reading this and having similar issues, I found the following website particularly useful for working out the XPath to traverse my XML:
https://www.freeformatter.com/xpath-tester.html
Kind regards,
Frank Doyle
-
Hi Tianjiao Li,
Thanks for your reply - I did read the documentation and after some trial and error was able to work it out.
I had to work out the XPath specification - but once that was done it worked perfectly.
If anyone else is reading this and having similar issues, I found the following website particularly useful for working out the XPath to traverse my XML:
https://www.freeformatter.com/xpath-tester.html
Kind regards,
Frank -
@FPD
It's great to hear you've worked it out and thanks for sharing the useful link!
Add comment
Please sign in to leave a comment.
Hello,
Hoping someone can help, please. I'm trying to mask an XML attribute but not having much luck setting up the rule. My data looks like this:
<clientlifestyles>
<clientlifestyle unit="0" name="NoLifestyle" cont_id="424583" cont_set_id="0" isassumed="false" value="" containsassumeddata="false" />
<clientlifestyle unit="21" name="ClientName" cont_id="0" cont_set_id="1" isassumed="false" value="Example Name" containsassumeddata="false" />
<clientlifestyle unit="24" name="ClientDOB" cont_id="0" cont_set_id="2" isassumed="false" value="16/09/1987" containsassumeddata="false" />
<clientlifestyle unit="25" name="ClientGender" cont_id="0" cont_set_id="3" isassumed="false" value="Male" containsassumeddata="false" />
<clientlifestyle unit="26" name="OccupationId" cont_id="0" cont_set_id="7" isassumed="false" value="purchasing manager" containsassumeddata="false" />
<clientlifestyle unit="23" name="PostCode" cont_id="0" cont_set_id="9" isassumed="false" value="BN20 8XS" containsassumeddata="false" />
<clientlifestyle unit="0" name="ClientTitleOther" cont_id="0" cont_set_id="2739" isassumed="false" value="" containsassumeddata="false" />
...and I'm trying to mask the "Example Name" attribute.Would someone please be able to help with the XPath to target that attribute, please?
Many thanks,
Frank