Fine-Tuning Data Access
Fine Tuning the Microsoft SharePoint Connection
To make it easier to access data in advanced integrations, use the following connection properties to control column name identifiers and other aspects of data access:
- UseDisplayNames: Set this to true to return column names that match field names in the underlying API
. By default, the add-in uses column names that match the field names defined in SharePoint. - UseSimpleNames: Set this to true to perform substitutions on special characters in column names that SharePoint allows but that many databases typically do not.
- ShowPredefinedColumns: Set this to false to exclude fields derived from fields in the list; for example, Author and CreatedAt
. This setting excludes the predefined fields from being returned in SELECT * statements and schema discovery. - ShowHiddenColumns: When true, columns marked as hidden in SharePoint will be displayed by the add-in.