Activities

You can use a data pattern rule on a Dataverse table to validate if a field value matches a defined pattern.

To set up a data pattern rule, first set up the data pattern to be applied. Define the data pattern, using a regular expression.

You can, for example, set up data patterns to validate:

• Email addresses
• Website URLs
• VAT numbers

For more information on regular expressions, refer to Regular expression.

You can use rules to check if data, that is entered in a Dataverse table, is in line with the defined standards.
Use a data pattern rule to validate if a field value matches a defined pattern.

Before you can set up a data pattern rule, set up the data pattern to be applied.

This topic explains how to set up a rule of type Data pattern.

On a Dataverse table, you can use a web service rule to:

• Validate if a field value matches a value in another internal or external source.
• Set a field value with a value from another internal or external source.

To set up a web service rule, first set up the web service to be used.

You can find the required web service settings, to be used for the web service setup, in the technical documentation as provided by the web service provider.

On a Dataverse table, you can use web service rules for these purposes:

• Validate data
• Validate and set data

Before you can set up a web service rule, set up the web service to be used.

This topic explains how to set up a web service rule.

You can find the required web service settings, to be used for the web service rule, in the technical documentation as provided by the web service provider.

Validate data

Using a web service, you can validate if a new or changed field value in a Dataverse table matches a value in another internal or external source.

Example:

Use a web service rule to validate a ZIP code and house number combination.

For request type 'POST', the request JSON is, for example:

  {

      "code":3905 NR,

      "housenumber":2

  }

Validate and set data

Using a web service, you can:

1. Validate if a new or changed field value in a Dataverse table matches a value in another internal or external source.
2. Get a field value from another internal or external source and set this value in a Dataverse table.

Example:

Use a web service rule to first validate if a ZIP code and house number combination is valid. If valid, based on the ZIP code, set address data like street name, city name, and province name.

For request type 'POST', the response JSON is, for example, when successful:

  {

      "response":true,

      "street":Kazemat,

      "city":Veenendaal,

      "province":Utrecht

  }

Note: With a web service rule, you can only set field values in Dataverse if first a validation is successfully done.