ODBC Driver for Microsoft Excel Online

Build 24.0.9060

SharepointURL

The base URL of your Sharepoint Server.

Data Type

string

Default Value

""

Remarks

To query the SharePointSites, this base URL of your Sharepoint Server must be specified. A protocol prefix, either "http://" or "https://", must be provided in the value supplied for this property.

For example: https://SomeTenantName.sharepoint.com. This property can also be used to control what drives, workbooks, and worksheets are exposed by the driver. If you specify SharepointURL and do not specify Drive, the driver will enumerate drives from the specified site as schemas, and enumerate all the worksheets from all the workbooks in each drive as tables in their respective schema. If this property is specified when using AzureServicePrincipal or AzureServicePrincipalCert authentication, the search endpoint will not be used. This property must be specified if working with a custom application that has Sites.Selected as its highest privilege.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060