ChannelDrives
Get folder information from a Microsoft Teams channel.
View-Specific Information
SELECT
The add-in 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 add-in.
- 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. |