Drives
Displays all OneDrive drives accessible to the current user, including personal and shared drives.
Table Specific Information
UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.
Due to API limitations, all operators on this view are executed client-side.
Columns
| Name | Type | References | Description |
| driveType | String | Specifies the classification of the OneDrive drive, such as personal, business, or documentLibrary. | |
| owner_application_displayName | String | The human-readable name of the application that owns or created the drive. | |
| owner_application_id | String | The unique ID assigned to the application that owns or manages the drive. | |
| quota_deleted | Long | The total number of bytes used by deleted items that are still retained in the recycle bin or recovery folder. | |
| quota_remaining | Long | The total number of bytes still available for use in the drive's allocated storage limit. | |
| quota_state | String | The current status of the drive's storage capacity, such as normal, nearing, or exceeded. | |
| quota_storagePlanInformation_upgradeAvailable | Bool | Specifies whether the user is eligible to upgrade their current storage plan based on available tiers. | |
| quota_total | Long | The maximum number of bytes allocated to the drive under the user's current storage plan. | |
| quota_used | Long | The total number of bytes currently used in the drive, including active and deleted content. | |
| sharePointIds_listId | String | The identifier of the SharePoint list associated with the current item, if applicable. | |
| sharePointIds_listItemId | String | The unique numeric identifier of a specific item within a SharePoint list. | |
| sharePointIds_listItemUniqueId | String | The globally unique identifier assigned to the list item within the SharePoint environment. | |
| sharePointIds_siteId | String | The identifier of the SharePoint site that contains the list or library associated with the current item. | |
| sharePointIds_siteUrl | String | The full URL of the SharePoint site that hosts the associated list or document library. | |
| sharePointIds_tenantId | String | The Microsoft 365 tenant identifier that owns the SharePoint site where the list or item is stored. | |
| sharePointIds_webId | String | The identifier of the SharePoint web (subsite) that contains the associated list or item. | |
| Linkedfollowing | String | A hyperlink to items or folders in OneDrive that the user is actively following for updates or collaboration. | |
| Linkeditems | String | A hyperlink to the child items contained within a folder or parent item in OneDrive. | |
| Linkedlist | String | A hyperlink that navigates to the SharePoint list which contains the current item. | |
| Linkedroot | String | A hyperlink to the root directory of the drive, representing the top-level folder or entry point. | |
| Linkedspecial | String | A hyperlink to system-defined special folders including Documents, Photos, Camera Roll, or similar. | |
| ParentReference | String | A reference object containing metadata about the immediate parent item or folder of the current item. | |
| Id [KEY] | String | A system-generated unique string that identifies the item within the drive. | |
| Name | String | The file or folder name as it appears in OneDrive, including its original casing and formatting. | |
| Description | String | A user-defined or system-generated description that provides context about the item's contents or purpose. | |
| owner_user_id | String | The unique identifier of the OneDrive user who owns or created the drive instance. |