Specifies whether the provider includes lookup columns in query results when using the SOAP schema.

Data Type

bool

Default Value

true

Remarks

Microsoft SharePoint tables can contain lookup columns, which pull data from other lists or sources. By default, the provider includes these columns when returning query results.

When set to true, the component returns all defined lookup columns along with other table columns.

When set to false, lookup columns are excluded from query results, reducing the number of fields retrieved.

This property is useful for limiting query size and avoiding issues caused by Microsoft SharePoint server restrictions on the number of lookup columns returned in a single request.

Performance Considerations

Including lookup columns can significantly increase query size and complexity, especially in lists with many lookup fields. This may lead to slower performance or server rejections if the number of included lookup columns exceeds SharePoint’s internal limits. Excluding lookup columns can improve performance and reliability when working with large or complex tables.