Specifies whether the provider validates column values against the allowed choices defined in ServiceNow when executing INSERT or UPDATE statements.

Data Type

bool

Default Value

false

Remarks

When set to true, the driver retrieves the valid choices for each field and checks that any inserted or updated value matches one of the available options. If a value does not match, an error is returned.

In ServiceNow, some elements (columns) are limited to a predefined list of valid values. For example, a Type of Issue field might only accept Bug, Enhancement, or Documentation. If you attempt to insert a record with an invalid value, ServiceNow normally replaces it with a default value.

Setting this property to true ensures that only valid values are used when modifying records. When set to false, the driver does not perform this validation and relies on ServiceNow to handle invalid values.

Display values are case-sensitive, and this property honors the DisplayValue connection property.

This property is useful for maintaining data integrity by preventing invalid field values during record creation or update.