Specifies whether the provider includes hidden columns in metadata and query results.

Data Type

bool

Default Value

false

Remarks

The ShowHiddenColumns property determines whether hidden columns in Microsoft SharePoint lists or libraries are displayed in metadata and query results.

When set to true, hidden columns are included, allowing access to fields that are not visible by default in the Microsoft SharePoint UI.

When set to false, hidden columns are excluded from the column listing.

This property applies to both the SOAP and REST schemas and is useful for advanced querying scenarios where hidden metadata fields or internal columns need to be accessed or analyzed.

Performance Considerations

Including hidden columns may increase result set size and metadata processing time, especially for lists with many internal or system fields. Excluding hidden columns can improve performance and simplify result sets, reducing unnecessary overhead in most use cases.