Controls whether available values for an element are retrieved and checked when executing INSERT or UPDATE statements.

Syntax

Connect-ServiceNow -EnforceColumnValues SwitchParameter

Data Type

bool

Default Value

false

Remarks

Controls whether available values for an element are retrieved and checked when executing INSERT or UPDATE statements. If the value is not a valid choice, an error will be thrown. Elements (columns) in ServiceNow could be limited to a set of valid values (choices in a list). For example, a 'Type of Issue' element could only have valid values like 'Bug','Enhancement' or 'Documentation'. If creating a record with an invalid value, ServiceNow will discard the value and assign a default value for the record. Setting this property to 'true' will retrieve the available choices beforehand, and check if any inserted values are part of the list of valid values when possible. Note that display values are case-senstitive. This property honours the DisplayValue connection property.