JDBC Driver for Microsoft Teams

Build 22.0.8479

ChannelMembers

Get members from channel.

Table Specific Information

SELECT

The 本製品 uses the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators:

  • ChannelId supports '=' operator.
  • TeamId supports '=,IN' operators.

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

For example, the following queries are processed server side:

SELECT * FROM ChannelMembers WHERE ChannelId = '19:de0aadf89578408aaecdb6fdf47ee83d@thread.skype' AND TeamId = 'f7985bee-7fb4-404d-a954-5ba68ae7c8db'

SELECT * FROM ChannelMembers WHERE ChannelId = '19:de0aadf89578408aaecdb6fdf47ee83d@thread.skype' AND TeamId IN ('f7985bee-7fb4-404d-a954-5ba68ae7c8db', 'da838338-4e77-4c05-82a6-79d9f0274511')

Columns

Name Type Description
Id [KEY] String Member Id.
TeamId String Team 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.
ChannelId String The Channel Id.

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