Apps
Contains metadata for third-party and internal apps integrated into Microsoft Teams, including installation details, permissions, and usage metrics.
Table Specific Information
Select
This includes apps from the Microsoft Teams store, as well as apps from your organization's app catalog (the tenant app catalog). To get apps from your organization's app catalog only, specify Organization as the distributionMethod. The server 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 server.
- displayName, Id, externalId support the '=', '!=', IN, LIKE, IS, IS NOT operator.
For example, the following queries are processed server side:
SELECT * FROM Apps WHERE DisplayName = 'MailChimp'
SELECT * FROM Apps WHERE DisplayName IN ('OneNote', 'Teams')
SELECT * FROM Apps WHERE Id LIKE '%-3b58-%'
SELECT * FROM Apps WHERE externalId IN (123, 156)
Delete
You can only remove the app from your organization's app catalog (the tenant app catalog). To remove an app record you need to specify the Id in WHERE clause.
DELETE FROM Apps WHERE Id = 'ffdb7239-3b58-46ba-b108-7f90a6d8799b'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
A unique identifier automatically assigned to the app when it is added to the Teams app catalog. |
| displayName | String | False |
The human-readable name of the app as defined by the app developer for display in Microsoft Teams. |
| distributionMethod | String | False |
Specifies how the app is made available to users, such as via store listing, side-loading, or organization-wide deployment. |
| externalId | String | False |
The custom identifier defined by the app developer within the Teams app package, used for linking or internal tracking. |