Specifies whether the provider creates supplemental ID columns for Microsoft SharePoint fields that reference values from other lists. Applies only to the SOAP schema.

Data Type

bool

Default Value

true

Remarks

In Microsoft SharePoint, certain fields, such as Lookup columns and Person or Group columns, store values that reference items in other lists. By default, when querying these fields using the SOAP schema, the server returns both the value and a supplemental ID column containing the referenced entry’s ID from the original list.

When set to true, the server creates these ID columns alongside the referenced values, making it easier to trace relationships and perform lookups.

When set to false, only the referenced values are returned, and the related IDs are not included.

This property is useful for preserving relational context and enabling more advanced filtering or joins when working with data that includes references to other lists.

Performance Considerations

Creating supplemental ID columns may increase the size of result sets and slightly impact performance when working with large datasets or wide tables. Disabling this property can reduce result set complexity and improve performance if the additional ID information is not needed.