Tableau Connector for Salesforce

Build 25.0.9434

ReportExactPicklistLength

Specifies whether to report the exact length of picklist fields as defined in Salesforce, or to report them with a default length of 255.

Data Type

bool

Default Value

false

Remarks

By default, the connector reports all picklist fields with a length of 255, regardless of their actual length in Salesforce. This simplifies schema definitions, but may not accurately reflect field constraints.

When this property is set to true, the connector reports each picklist field with its exact length as defined in the Salesforce metadata. This is helpful for applications or integrations that require strict adherence to field size constraints.

Reporting exact lengths may slightly increase the complexity of schema discovery but ensures accurate metadata for data validation and form generation. Using a fixed length of 255 simplifies schema management but may cause issues if values exceed the actual limits enforced by Salesforce. This property should be enabled when working with systems that need to respect Salesforce’s exact field constraints for picklist fields.

This property is useful for developers or data architects who require precise metadata for picklist fields when designing integrations, forms, or validation logic.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434