ChannelFiles
Get file 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.
- DriveId supports the = operator.
- ItemId supports the = operator.
Example Queries
To retrieve files within a specific drive and folder:
SELECT * FROM ChannelFiles WHERE DriveId = 'b!r68obG9YM06sZvJpTZRioX1vF3JBlPtCjqjFjq4Eh77Ca_Lu7Q77Qpy7-YcAyTPM' AND ItemId = '01IT6WWIEUTYZ63HY7KVFLXISQZ5F72IDR'
Columns
| Name | Type | Description |
| DriveId [KEY] | String | The identifier of the SharePoint drive that backs the channel. |
| ItemId [KEY] | String | The identifier of the folder or file to search within. |
| FileId [KEY] | String | The identifier of the file. |
| FileName | String | The name of the file. |
| ParentItemId | String | The identifier of the folder containing this file. |
| ParentItemName | String | The name of the folder containing this file. |
| ParentSiteId | String | The site identifier of the folder containing this file. |
| ParentDriveType | String | The drive type of the folder containing this file. |
| ParentPath | String | The path of the folder containing this file. |
| FileMimeType | String | The MIME type of the file. |
| FileHash | String | The quickXorHash of the file. |
| Size | String | The size of the file in bytes. |
| DownloadUrl | String | The URL to download the file. |
| WebUrl | String | The URL to view the file in a browser. |
| CreatedDateTime | Datetime | The date and time at which the file was created. |
| LastModifiedDateTime | Datetime | The date and time at which the file was last modified. |