Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| DirectoryRetrievalDepth | Specify how many folders deep you want to get results for Files table. The resources directly in the root are located at depth 0. The resources one folder deeper are located at depth 1 and so on. You can specify the value -1 to get all the data in a drive no matter the depth they're in. |
| MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
| Other | These hidden properties are used only in specific use cases. |
| Pagesize | The maximum number of results to return per page from Microsoft Office 365. |
| Readonly | You can use this property to enforce read-only access to Microsoft Office 365 from the provider. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UseClientSidePaging | Whether or not the CData ADO.NET Provider for Microsoft Office 365 should use client side paging. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |