Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| CalculatedDataType | The data type to be used for calculated fields. This property applies only to the SOAP schema. |
| ContinueOnError | Indicates whether to continue updating items in a batch after an error. |
| CreateIDColumns | Create supplemental ID columns for SharePoint columns that use values from information stored in other Lists. This property applies only to the SOAP schema. |
| DisableFilterLimit | Microsoft SharePoint natively supports listing up to 5000 records as they appear in your list filter. Use this property to pull more than 5000 records from the list filter at the cost of additional performance overhead. This property applies only to the REST schema. |
| FolderOption | An option to determine how to display folders in results. Enter either FilesOnly, FilesAndFolders, Recursive, or RecursiveAll. This property applies only to the SOAP schema. |
| GetColumnsMetadata | Specifies when the provider should retrieve column metadata. This property applies only to the REST schema. |
| IncludeLookupColumns | This option controls whether the driver returns the lookup columns defined on a table. This property applies only to the SOAP schema. |
| IncludeLookupDisplayValueColumns | Determines whether the display values for lookup columns should be included. This property applies only to the REST schema. |
| MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties. |
| Pagesize | Specifies the maximum number of results to return from Microsoft SharePoint, per page. This setting overrides the default page size set by the datasource, which is optimized for most use cases. |
| Readonly | Toggles read-only access to Microsoft SharePoint from the provider. |
| ShowHiddenColumns | Boolean determining if hidden columns should be shown or not. If false, all hidden columns will be removed from the column listing. |
| ShowPredefinedColumns | Boolean determining if predefined columns should be shown or not. If false, all columns derived from a base type will be removed from the column listing. |
| ShowVersionViews | Indicates whether to include the list version views during metadata discovery. This property applies only to the SOAP schema. |
| STSURL | The URL of the security token service (STS) when using single sign-on (SSO). |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. The default is 60 seconds. Set to 0 to disable the timeout. |
| UseDisplayNames | Boolean determining if the display names for the columns should be used instead of the API names. |
| UseEntityTypeName | Boolean determining if the list's EntityTypeName field should be used as the table name during metadata discovery instead of the Title field. This property applies only to the REST schema. |
| UseNTLMV1 | Determines whether the driver will attempt to connect with NTLMv1 or NTLMv2 (default). |
| UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |