Contact Free trial Login

Change the Value of a Field

This DataWeave example changes the values of some XML elements. Here, it changes the values of keys containing sensitive data to a set of asterisks (****).

It uses these functions:

  • mapObject to go through the users in the input. When on each user, it uses two other mapObject functions to go through the fields in both personal information and the login information.

  • if and else to mask the values of the ssn and password keys.

DataWeave
%dw 2.0
output application/xml
---
users: { (payload.users mapObject (userObject) -> {
    user: {
         personal_information: userObject.personal_information mapObject (value, key) ->
         {
            (if (key ~= "ssn") (key): "****"  else (key): value)
         },
         login_information: userObject.login_information mapObject (value, key) ->
         {
            (if (key ~= "password") (key): "****" else (key): value)
         }
      }
   })
}
Input XML
<users>
    <user>
        <personal_information>
            <first_name>Emiliano</first_name>
            <middle_name>Romoaldo</middle_name>
            <last_name>Lesende</last_name>
            <ssn>001-08-84382</ssn>
        </personal_information>
        <login_information>
            <username>3miliano</username>
            <password>mypassword1234</password>
        </login_information>
    </user>
    <user>
        <personal_information>
            <first_name>Mariano</first_name>
            <middle_name>Toribio</middle_name>
            <last_name>de Achaval</last_name>
            <ssn>002-05-34738</ssn>
        </personal_information>
        <login_information>
            <username>machaval</username>
            <password>mypassword4321</password>
        </login_information>
    </user>
</users>
Output XML
<?xml version="1.0" encoding="UTF-8"?>
<users>
  <user>
    <personal_information>
      <first_name>Emiliano</first_name>
      <middle_name>Romoaldo</middle_name>
      <last_name>Lesende</last_name>
      <ssn>****</ssn>
    </personal_information>
    <login_information>
      <username>3miliano</username>
      <password>****</password>
    </login_information>
  </user>
  <user>
    <personal_information>
      <first_name>Mariano</first_name>
      <middle_name>Toribio</middle_name>
      <last_name>de Achaval</last_name>
      <ssn>****</ssn>
    </personal_information>
    <login_information>
      <username>machaval</username>
      <password>****</password>
    </login_information>
  </user>
</users>

Was this article helpful?

💙 Thanks for your feedback!

Edit on GitHub