Power BI Connector for ServiceNow

Build 25.0.9540

EnforceColumnValues

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

データ型

bool

デフォルト値

false

解説

When set to true, the 本製品 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 本製品 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540