ChannelDrives
Get folder information from a Microsoft Teams channel.
View-Specific Information
SELECT
The connector uses the Microsoft Teams API to process WHERE clause conditions built with the columns and operator shown below. The rest of the filter is executed client-side within the connector.
- ChannelId supports the = operator.
- TeamId supports the = operator.
Note: For best performance, specify both ChannelId and TeamId in the WHERE clause.
Example Queries
To retrieve drives for a specific team:
SELECT * FROM ChannelDrives WHERE TeamId = 'acf47a3c-bad3-4c2e-b566-2a14fef3de6f'
To retrieve drives for a specific channel:
SELECT * FROM ChannelDrives WHERE ChannelId = '19:[email protected]'
Columns
| Name | Type | Description |
| ChannelId [KEY] | String | The identifier of the Microsoft Teams channel. |
| TeamId [KEY] | String | The identifier of the team that owns the channel. |
| ItemId | String | The identifier of the channel folder (drive item). |
| DriveId | String | The identifier of the SharePoint drive that backs the channel. |
| FolderName | String | The display name of the channel folder. |
| ChildCount | Integer | The number of items directly inside the channel folder. |