MCP Server for Microsoft SharePoint

Build 24.0.9300

CalculatedDataType

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

Calculated, Boolean, Date, DateTime, Double, Integer, String

Data Type

string

Default Value

"Calculated"

Remarks

In SharePoint’s SOAP schema, calculated fields can return varying data types depending on how they are configured in the UI. By default, the server 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 server 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 server to optimize type handling based on metadata. Manual overrides should only be used when type inconsistencies cause issues.

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