JDBC Driver for Microsoft Teams

Build 22.0.8479

ChatMembers

Get members from chat.

Table Specific Information

SELECT

The 本製品 use the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:

  • UserId supports '=' operator.
  • ChatId supports '=,IN' operators.

The rest of the filter is executed client side within the 本製品.

The following is an example query:

SELECT * FROM ChatMembers WHERE UserId = 'e4ea490e-b30c-4b1e-92b0-337117920315' AND ChatId = '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_90a27c51-5c74-453b-944a-134ba86da790@unq.gbl.spaces'

SELECT * FROM ChatMembers WHERE UserId = 'e4ea490e-b30c-4b1e-92b0-337117920315' AND ChatId IN ('19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_90a27c51-5c74-453b-944a-134ba86da790@unq.gbl.spaces', '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_b62067c0-8314-42f8-9d02-d1c2051dfcdc@unq.gbl.spaces')

Columns

Name Type Description
Id [KEY] String Member Id.
ChatId String Chat Id.
DisplayName String Display name.
email String Email of member.
Roles String Role of member.
TenantId String Tenant Id.
UserId String User Id.
StartDateTime Datetime History start date time.

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