ChannelFiles
Get file 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.
- 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. |