Note: Replaced by 'ResolveCalculatedTypes'.

Specifies the data type to use for calculated fields in the SOAP schema. Set this if Microsoft SharePoint returns unexpected types for calculated fields.

Possible Values

Data Type

string

Default Value

"Calculated"

Remarks

Note: This connection property is deprecated. Instead, use the ResolveCalculatedTypes connection property to configure how the connector assigns data types to calculated fields.

In SharePoint’s SOAP schema, calculated fields can return varying data types depending on how they are configured in the UI. By default, the connector attempts to detect the correct type based on the metadata, using the Calculated option. However, in some cases, calculated fields may return inconsistent or unexpected values that do not match the detected type. When this occurs, you can use the CalculatedDataType property to manually specify the data type that the connector should use for these fields.

Performance Considerations

Overriding the calculated field data type can reduce errors and improve query reliability by avoiding type mismatches. However, forcing a data type that conflicts with the underlying data may lead to conversion overhead or truncated values, which can slow query performance, especially with large result sets. Relying on the default Calculated setting allows the connector to optimize type handling based on metadata. Manual overrides should only be used when type inconsistencies cause issues.