The Id or WebUrl of the drive. A list of all drives, including their Ids and WebUrls, is available from the Drives view.

Data Type

string

Default Value

""

Remarks

Specifies the drive to connect to. You can supply either the Drive Id or the WebUrl of the drive.

If you specify a WebUrl (for example, https://mycompany.sharepoint.com/sites/finance), the driver automatically resolves it to the corresponding Drive Id by querying the Drives table. The resolution logic varies based on the connection configuration:

• When IncludeSharePointSites is true, the driver extracts the parent SharePoint Site from the WebUrl and uses it to filter the Drives query, improving performance by narrowing the search scope.
• When SharepointURL is specified and contains the target drive, the driver resolves the WebUrl within that SharePoint site context.
• When neither IncludeSharePointSites nor SharepointURL is configured, the driver resolves the WebUrl for personal OneDrive drives.

You can find the WebUrl for a drive by querying the Drives view and inspecting the WebUrl column.

This property takes precedence over SharepointURL. This means that if SharepointURL and Drive are specified, a schema will only be identified for the drive specified by Drive, and tables will only be identified from the worksheets in workbooks in this drive.