Set up web service rule

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.