TeamTabs
TeamTabs table for MSTeams data provider.
Table Specific Information
Select
To query the TeamsTabs table you need to specify TeamId and ChannelId filters in order to retreive tabs for the specified channel which belongs to the specified team. The connector will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- TeamId and ChannelId support the '=' and IN operators. All the other columns support the '=', IN, LIKE, !=, IS, IS NOT operators.
For example, the following queries are processed server side:
SELECT * FROM TeamsTabs WHERE TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511' AND ChannelId = '19:[email protected]' SELECT * FROM TeamsTabs WHERE TeamId = '12d95e4d-f90f-434c-b280-dd7f8b8615e5' AND ChannelId IN (SELECT Id FROM Channels WHERE TeamId = '12d95e4d-f90f-434c-b280-dd7f8b8615e5') AND Id LIKE '%-ade1-400a-a82b-e7a435199b7a' SELECT * FROM TeamsTabs WHERE TeamId = '12d95e4d-f90f-434c-b280-dd7f8b8615e5' AND ChannelId IN (SELECT Id FROM Channels WHERE TeamId = '12d95e4d-f90f-434c-b280-dd7f8b8615e5') AND configuration_entityId IS NOT NULL
Insert
At least TeamId, ChannelId and AppID are required to insert a new tab in a channel. You can specify any other field as well.
INSERT INTO TeamsTabs (TeamId, ChannelId, DisplayName, AppID) VALUES ('4729c5e5-f923-4435-8a41-44423d42ea79', '19:[email protected]', 'new tab for test', '0d820ecd-def2-4297-adad-78056cde7c78')
Update
To update a tab record you need to specify the Id, ChannelId and TeamId in the WHERE clause.
UPDATE TeamsTabs SET DisplayName = 'updatetabname' WHERE Id = 'c41cbfe0-7713-44d6-96dd-b692569f1766' AND ChannelId = '19:[email protected]' AND TeamId = '4729c5e5-f923-4435-8a41-44423d42ea79'
Delete
To delete a tab record you need to specify the Id, ChannelId and TeamId in the WHERE clause.
DELETE FROM TeamsTabs WHERE TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511' AND ChannelId = '19:[email protected]' AND Id = '16ba49df-d7e1-4dc7-b6c3-ea721d327d38'
Columns
Name | Type | ReadOnly | Description |
id [KEY] | String | False |
Identifier that uniquely identifies a specific instance of a channel tab. |
AppId | String | False |
The App Id. |
ChannelId | String | False |
The Channel Id. |
Configuration_contentUrl | String | False |
Url used for rendering tab contents in Teams. Required. |
Configuration_entityId | String | False |
Identifier for the entity hosted by the tab provider. |
Configuration_removeUrl | String | False |
Url called by Teams client when a Tab is removed using the Teams Client. |
Configuration_websiteUrl | String | False |
Url for showing tab contents outside of Teams. |
DisplayName | String | False |
Name of the tab. |
WebUrl | String | False |
Deep link URL of the tab instance. |
TeamsApp_id | String | True |
App definition identifier of the tab. |
TeamId | String | False |
The Team Id. |