JDBC Driver for Microsoft Teams

Build 22.0.8462

Apps

Apps table for MSTeams data provider.

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 driver 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 driver.

  • 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

The catalog app's generated app ID.

displayName String False

The name of the catalog app provided by the app developer.

distributionMethod String False

The method of distribution for the app.

externalId String False

The ID of the catalog provided by the app developer in the Microsoft Teams zip app package.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462