Masking nested XML attributes

FPD · January 24, 2019 9:42AM

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:

...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

Tianjiao_Li · January 25, 2019 2:27PM

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?

FPD · January 25, 2019 3:01PM

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

FPD · January 28, 2019 1:14PM

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

Tianjiao_Li · January 31, 2019 10:32AM

@FPD

It's great to hear you've worked it out and thanks for sharing the useful link!

Masking nested XML attributes

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk