XML Mask

This is a composite generator.

Runs a selected generator on values that match a user specified path expression.

Path expressions are defined using the XPath syntax.

For example, for the following XML content:

<?xml version="1.0" encoding="UTF-8"?>
    <household>
        <member>
            <first_name>John</first_name>
            <last_name>Smith</last_name>
            <age>25</age>
            <occupation>Teacher</occupation>
            <salary>45000</salary>
        </member>
    </household>
</xml>

To get the first_name value, you would use /household/member/first_name.

You can also select a fallback generator to run on the entire XML value if there is any error during data generation.

Characteristics

How to configure

Adding a sub-generator

To assign a generator to a path expression:

  1. Under Sub-generators, click Add Generator. On the sub-generator configuration panel, the Cell XML field contains a sample value from the source database. You can use the previous and next icons to page through different values.

  2. In the Path Expression field, type the path expression to identify the value to apply the generator to. Matched XML Values shows the result from the value in Cell XML.

  3. From the Generator Configuration dropdown list, select the generator to apply to the value at the path expression. You cannot select another composite generator.

  4. Configure the selected generator. You cannot configure the selected generator to be consistent with another column.

  5. To save the configuration and immediately add a generator for another path expression, click Save and Add Another. To save the configuration and close the add generator panel, click Save.

Managing the sub-generators list

From the Sub-Generators list:

  • To edit a generator assignment, click the edit icon.

  • To remove a generator assignment, click the delete icon.

  • To move a generator assignment up or down in the list, click the up or down arrow.

Selecting a fallback generator

From the Fallback Generator dropdown list, select the generator to use if any error occurs in the generation.

The fallback generator is then used for the entire XML value.

The options are:

Last updated