SSIS Components for Microsoft Teams

Build 26.0.9770

OnlineMeetings

Contains information about a meeting, including the URL used to join, the list of attendees, and the description.

Table-Specific Information

Select

The component uses the Microsoft Teams API to process WHERE clause conditions built with the column and operator shown below. The rest of the filter is executed client-side within the component.

  • Id supports the = operator.

Note: The Id column is required to retrieve results from this table and must be specified in the WHERE clause.

Example Queries

Use the Id returned by the Microsoft Teams API to retrieve the meeting details, including the associated UserId. You can then use both the UserId and Id to query the meeting directly. 

SELECT * FROM OnlineMeetings WHERE Id = 'MSphMjIxNGQwZS0zMDlkLTQ4YTAtYjRiMi1kMzI3MmNkNmZjMjQqMCoqMTk6bWVldGluZ19aREZqTXpjNFpERXRObUkyTWkwME9EYzVMVGxqWkRVdFlqY3lNVEF5WkRjMFlXTTFAdGhyZWFkLnYy'

SELECT * FROM OnlineMeetings WHERE UserId = '4729c5e5-f923-4435-8a41-44423d42ea79' AND Id = 'MSphMjIxNGQwZS0zMDlkLTQ4YTAtYjRiMi1kMzI3MmNkNmZjMjQqMCoqMTk6bWVldGluZ19aREZqTXpjNFpERXRObUkyTWkwME9EYzVMVGxqWkRVdFlqY3lNVEF5WkRjMFlXTTFAdGhyZWFkLnYy'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier for the online meeting.

AllowAttendeeToEnableCamera Bool False

Indicates whether attendees are allowed to enable their cameras during the meeting.

AllowAttendeeToEnableMic Bool False

Indicates whether attendees are allowed to enable their microphones during the meeting.

AllowBreakoutRooms Bool False

Indicates whether breakout rooms are enabled for the meeting.

AllowCopyingAndSharingMeetingContent Bool False

Indicates whether attendees are allowed to copy and share meeting content.

AllowedLobbyAdmitters String False

Specifies which participants have permission to admit others from the meeting lobby.

AllowedPresenters String False

Specifies which participants are permitted to present content during the meeting.

AllowLiveShare String False

Specifies the Live Share option for collaborative content sharing during the meeting.

AllowMeetingChat String False

Specifies the chat mode for the meeting, controlling whether participants can send messages.

AllowParticipantsToChangeName Bool False

Indicates whether participants are allowed to change their display name during the meeting.

AllowPowerPointSharing Bool False

Indicates whether participants are allowed to share PowerPoint presentations during the meeting.

AllowRecording Bool False

Indicates whether recording is allowed during the meeting.

AllowTeamworkReactions Bool False

Indicates whether participants can use reactions, such as emojis, during the meeting.

AllowTranscription Bool False

Indicates whether automatic transcription is enabled for the meeting.

AllowWhiteboard Bool False

Indicates whether participants are allowed to use the whiteboard feature during the meeting.

AudioConferencing_conferenceId String False

The conference Id for the audio conferencing session associated with the meeting.

AudioConferencing_dialinUrl String False

The URL for dialing into the audio conferencing session for the meeting.

AudioConferencing_tollFreeNumber String False

The toll-free phone number for joining the audio conferencing session.

AudioConferencing_tollFreeNumbers String False

A list of toll-free phone numbers available for joining the audio conferencing session.

AudioConferencing_tollNumber String False

The toll phone number for joining the audio conferencing session.

AudioConferencing_tollNumbers String False

A list of toll phone numbers available for joining the audio conferencing session.

ChatInfo_messageId String False

The Id of the chat message associated with the meeting.

ChatInfo_replyChainMessageId String False

The Id of the reply chain message in the chat thread associated with the meeting.

ChatInfo_threadId String False

The Id of the chat thread associated with the meeting.

ChatRestrictions_allowTextOnly Bool False

Indicates whether the meeting chat is restricted to text-only messages.

IsEndToEndEncryptionEnabled Bool False

Indicates whether end-to-end encryption is enabled for the meeting.

IsEntryExitAnnounced Bool False

Indicates whether an announcement is played when participants enter or exit the meeting.

JoinInformation_content String False

The content of the join information for the meeting, such as formatted joining instructions for attendees.

JoinInformation_contentType String False

The content type of the join information, specifying the format in which joining instructions are presented.

JoinMeetingIdSettings_isPasscodeRequired Bool False

Indicates whether a passcode is required to join the meeting using the meeting Id.

JoinMeetingIdSettings_joinMeetingId String False

The meeting Id used by participants to join the meeting directly.

JoinMeetingIdSettings_passcode String False

The passcode required to join the meeting when passcode enforcement is enabled.

JoinWebUrl String False

The URL used to join the online meeting from a web browser.

LobbyBypassSettings_isDialInBypassEnabled Bool False

Indicates whether participants who dial in by phone can bypass the meeting lobby.

LobbyBypassSettings_scope String False

Specifies which participants are allowed to bypass the meeting lobby and join the meeting directly.

RecordAutomatically Bool False

Indicates whether the meeting is configured to start recording automatically when it begins.

ShareMeetingChatHistoryDefault String False

Specifies the default setting for sharing meeting chat history with participants after the meeting ends.

Subject String False

The subject or title of the online meeting.

VideoTeleconferenceId String False

The video teleconference Id associated with the meeting.

WatermarkProtection_isEnabledForContentSharing Bool False

Indicates whether watermark protection is enabled for content shared during the meeting.

WatermarkProtection_isEnabledForVideo Bool False

Indicates whether watermark protection is enabled for video feeds during the meeting.

AttendeeReport String False

The attendee report stream for the meeting. This field cannot be updated directly.

BroadcastSettings_allowedAudience String False

Specifies the audience permitted to view the broadcast meeting.

BroadcastSettings_captions_isCaptionEnabled Bool False

Indicates whether captions are enabled for the broadcast meeting.

BroadcastSettings_captions_spokenLanguage String False

The spoken language configured for captions in the broadcast meeting.

BroadcastSettings_captions_translationLanguages String False

A list of languages into which captions are translated during the broadcast meeting.

BroadcastSettings_isAttendeeReportEnabled Bool False

Indicates whether the attendee report is enabled for the broadcast meeting.

BroadcastSettings_isQuestionAndAnswerEnabled Bool False

Indicates whether the question and answer feature is enabled for the broadcast meeting.

BroadcastSettings_isRecordingEnabled Bool False

Indicates whether recording is enabled for the broadcast meeting.

BroadcastSettings_isVideoOnDemandEnabled Bool False

Indicates whether video on demand is enabled for the broadcast meeting.

CreationDateTime Datetime False

The date and time when the meeting was created.

EndDateTime Datetime False

The date and time when the meeting is scheduled to end.

ExternalId String False

The external Id used to identify the meeting in an external system.

IsBroadcast Bool False

Indicates whether the meeting is configured as a broadcast event.

MeetingTemplateId String False

The Id of the template used to create the meeting.

Participants_attendees String False

A list of attendees participating in the meeting, including their identities and assigned roles.

Participants_organizer_identity_application_displayName String False

The display name of the application identity acting as the meeting organizer.

Participants_organizer_identity_application_id String False

The Id of the application identity acting as the meeting organizer.

Participants_organizer_role String False

The role assigned to the organizer of the meeting.

Participants_organizer_upn String False

The user principal name (UPN) of the meeting organizer.

StartDateTime Datetime False

The date and time when the meeting is scheduled to start.

UserId String False

The Id of the user whose online meetings are retrieved.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770