Microsoft Teams Connector Objects
| Name | Description |
|---|---|
| Apps | Apps table for MSTeams data provider. |
| CallRecords | Details of calls on MS Teams. |
| CallRecordSessions | Details of call sessions on MS Teams. |
| CallRecordSessionSegments | Details of call session segments on MS Teams. |
| ChannelMembers | Get members from channel. |
| ChannelMessages | Get Channel messages and its replies. |
| Channels | Channels table for MSTeams data provider. |
| ChatMembers | Get members from chat. |
| ChatMessages | Get Chat Messages. |
| Chats | Get Chats. |
| DirectRoutingCalls | Retrieves a list of direct routing calls |
| GroupMembers | GroupMembers table for MSTeams data provider. |
| GroupOwners | GroupOwners table for MSTeams data provider. |
| Groups | Groups table for MSTeams data provider. |
| OpenShifts | Shifts table for MSTeams data provider. |
| PstnCalls | Retrieves a list of PSTN Calls |
| Schedules | Schedules table for MSTeams data provider. |
| SchedulingGroups | SchedulingGroups table for MSTeams data provider. |
| Shifts | Shifts table for MSTeams data provider. |
| TeamMembers | Get members from team. |
| Teams | Teams table for MSTeams data provider. |
| TeamsInstalledApps | TeamsInstalledApps table for MSTeams data provider. |
| TeamTabs | TeamTabs table for MSTeams data provider. |
| TimeOffReasons | TimesOffReasons table for MSTeams data provider. |
| TimesOff | TimesOff table for MSTeams data provider. |
| UserPresence | UserPresence table for MSTeams data provider. |
| Users | Users table for MSTeams data provider. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The catalog app's generated app ID. | |
| displayName | String | False | No | The name of the catalog app provided by the app developer. | |
| distributionMethod | String | False | No | The method of distribution for the app. | |
| externalId | String | False | No | The ID of the catalog provided by the app developer in the Microsoft Teams zip app package. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | Call record Id | |
| EndDateTime | Datetime | False | No | Time the call ended | |
| JoinWebUrl | String | False | No | URL used to join Meeting | |
| LastModifiedDateTime | Datetime | False | No | Last Modified date of this call record | |
| Modalities | String | False | No | Modalities which can be one or more of audio, video, videoBasedScreenSharing, data and screenSharing | |
| Organizer | String | False | No | Details of the organizer of the meeting | |
| Participants | String | False | No | Participants of the call. | |
| StartDateTime | Datetime | False | No | Start time of the meeting | |
| Type | String | False | No | Type of call peerToPeer or groupCall | |
| Version | Long | False | No | Version | |
| CallRecordsId | String | False | CallRecords.Id | No | Call record Id. Mandatory internal column to be used in WHERE clause |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Call record Id | |
| Callee_UserAgent_ApplicationVersion | String | True | No | Callee UserAgent Application Version | |
| Callee_UserAgent_HeaderValue | String | True | No | Callee UserAgent Header Value | |
| Caller_UserAgent_ApplicationVersion | String | True | No | Caller UserAgent Application Version | |
| Caller_UserAgent_HeaderValue | String | True | No | Caller UserAgent Header Value | |
| EndDateTime | Datetime | True | No | Time the call ended | |
| FailureInfo_Reason | String | True | No | Failure Information Reason | |
| FailureInfo_Stage | String | True | No | Failure Information Stage | |
| Modalities | String | True | No | Modalities which can be one or more of audio, video, videoBasedScreenSharing, data and screenSharing | |
| StartDateTime | Datetime | True | No | Start time of the meeting | |
| CallRecordsId | String | True | No | Call record Id. Mandatory internal column to be used in WHERE clause |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Call record Id | |
| Callee_UserAgent_ApplicationVersion | String | True | No | Callee UserAgent Application Version | |
| Callee_UserAgent_HeaderValue | String | True | No | Callee UserAgent Header Value | |
| Caller_UserAgent_ApplicationVersion | String | True | No | Caller UserAgent Application Version | |
| Caller_UserAgent_HeaderValue | String | True | No | Caller UserAgent Header Value | |
| EndDateTime | Datetime | True | No | Time the call ended | |
| FailureInfo_Reason | String | True | No | Failure Information Reason | |
| FailureInfo_Stage | String | True | No | Failure Information Stage | |
| Media | String | True | No | Call media details | |
| StartDateTime | Datetime | True | No | Start time of the meeting | |
| CallRecordsId | String | True | No | Call record Id. Mandatory internal column to be used in WHERE clause |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Member Id. | |
| TeamId | String | True | Teams.Id | No | Team Id. |
| DisplayName | String | True | No | Display name. | |
| String | True | No | Email of member. | ||
| Roles | String | True | No | Role of member. | |
| TenantId | String | True | No | Tenant Id. | |
| UserId | String | True | No | User Id. | |
| StartDateTime | Datetime | True | No | History start date time. | |
| ChannelId | String | True | Channels.Id | No | The Channel Id. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Channel Messsages Id. | |
| BodyContent | String | True | No | Content of the Body. | |
| BodyContentType | String | True | No | Type of BodyContent. | |
| ChannelId | String | True | Channels.Id | No | The Channel Id. |
| TeamId | String | True | Teams.Id | No | The Team Id. |
| Mentions | String | True | No | List of entities mentioned in the channel message. Supported entities are: user, bot, team, and channel. | |
| Reactions | String | True | No | Reactions for the channel messages (for example, Like). | |
| Attachments | String | True | No | References to attached objects like files, tabs, meetings etc. | |
| Importance | String | True | No | Importance of the messages. | |
| CreatedDateTime | Datetime | True | No | Timestamp of when the channel message was created. | |
| LastEditedDateTime | Datetime | True | No | The timestamp on which this message was last edited. | |
| LastModifiedDateTime | Datetime | True | No | The timestamp on which this message was last updated. | |
| DeletedDateTime | Datetime | True | No | Timestamp at which the channel messages was deleted, or null if not deleted. | |
| MessageType | String | True | No | Type of Channel message. | |
| ChatId | String | True | No | The Chat Id. | |
| Etag | String | True | No | Version number of the channel message. | |
| FromUserDisplayName | String | True | No | From User Display Name. | |
| FromUserId | String | True | No | From User Id. | |
| FromUserUserIdentityType | String | True | No | From User UserIdentityType. | |
| FromApplication | String | True | No | The From Application. | |
| FromDevice | String | True | No | The From Device. | |
| Locale | String | True | No | Locale of the channel message set by the client. Always set to en-us. | |
| PolicyViolation | String | True | No | Channel Message Policy Violation. | |
| ReplyToId | String | True | No | ID of the parent chat message or root chat message of the thread. | |
| Subject | String | True | No | The subject of the channel message, in plaintext. | |
| Summary | String | True | No | Summary text of the channel message that could be used for push notifications and summary views or fall back views. Only applies to channel chat messages, not chat messages in a chat. | |
| WebUrl | String | True | No | Link to the message in Microsoft Teams. | |
| EventDetail | String | True | No | The Event Message Detail. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The channel's unique identifier. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| CreatedDateTime | Datetime | False | No | Timestamp at which the channel was created. | |
| Description | String | False | No | Optional textual description for the channel. | |
| DisplayName | String | False | No | Channel name as it will appear to the user in Microsoft Teams. | |
| String | False | No | The email address for sending messages to the channel. Read-only. | ||
| IsFavoriteByDefault | Bool | False | No | Indicates whether the channel should automatically be marked 'favorite' for all members of the team. Can only be set programmatically with Create team. Default: false. | |
| MembershipType | String | False | No | The type of the channel. Can be set during creation and cannot be changed. Default: standard. | |
| WebUrl | String | False | No | A hyperlink that will go to the channel in Microsoft Teams. This is the URL that you get when you right-click a channel in Microsoft Teams and select Get link to channel. This URL should be treated as an opaque blob, and not parsed. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Member Id. | |
| ChatId | String | True | Chats.Id | No | Chat Id. |
| DisplayName | String | True | No | Display name. | |
| String | True | No | Email of member. | ||
| Roles | String | True | No | Role of member. | |
| TenantId | String | True | No | Tenant Id. | |
| UserId | String | True | Users.Id | No | User Id. |
| StartDateTime | Datetime | True | No | History start date time. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Chat Messages Id. | |
| ChatId | String | True | No | The Chat Id. | |
| BodyContent | String | True | No | Content of the Body. | |
| BodyContentType | String | True | No | Type of BodyContent. | |
| MessageType | String | True | No | Type of chat message. | |
| CreatedDateTime | Datetime | True | No | Timestamp of when the chat message was created. | |
| LastEditedDateTime | Datetime | True | No | The timestamp on which this message was last edited. | |
| LastModifiedDateTime | Datetime | True | No | The timestamp on which this message was last updated. | |
| DeletedDateTime | Datetime | True | No | Timestamp at which the chat message was deleted, or null if not deleted. | |
| Reactions | String | True | No | Reactions for the chat message (for example, Like). | |
| Mentions | String | True | No | List of entities mentioned in the chat message. Supported entities are: user, bot, team, and channel. | |
| Attachments | String | True | No | References to attached objects like files, tabs, meetings etc. | |
| Importance | String | True | No | Importance of the messages. | |
| FromUserDisplayName | String | True | No | From User Display Name. | |
| FromUserId | String | True | No | From User Id. | |
| FromUserIdentityType | String | True | No | From User UserIdentityType. | |
| ChannelIdentity | String | True | No | Identity of the Channel. | |
| Locale | String | True | No | Locale of the chat message set by the client. Always set to en-us. | |
| ReplyToId | String | True | No | ID of the parent chat message or root chat message of the thread. | |
| Subject | String | True | No | The subject of the chat message, in plaintext. | |
| Summary | String | True | No | Summary text of the chat message that could be used for push notifications and summary views or fall back views. Only applies to channel chat messages, not chat messages in a chat. | |
| PolicyViolation | String | True | No | Chat Message Policy Violation. | |
| Etag | String | True | No | Version number of the chat message. | |
| FromApplication | String | True | No | The From Application. | |
| FromDevice | String | True | No | The From Device. | |
| WebUrl | String | True | No | Link to the message in Microsoft Teams. | |
| EventDetail | String | True | No | The Event Message Detail. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Chat Id. | |
| ChatType | String | True | No | The type of Chat. | |
| UserId | String | True | Users.Id | No | The User Id. |
| CreatedDateTime | Datetime | True | No | Timestamp of when the message was created. | |
| LastUpdatedDateTime | Datetime | True | No | The timestamp on which this message was last updated. | |
| Topic | String | True | No | The Topic. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id of the Direct routing call | |
| CorrelationId | String | True | No | The Correlation ID | |
| UserId | String | True | No | The Id of the user | |
| UserPrincipalName | String | True | No | The principal name of the user | |
| UserDisplayName | String | True | No | The display name of the user | |
| StartDateTime | Edm.DateTimeOffset | True | No | The start date time of the call | |
| InviteDateTime | Edm.DateTimeOffset | True | No | The invite date time | |
| FailureDateTime | Edm.DateTimeOffset | True | No | The failure date time | |
| EndDateTime | Edm.DateTimeOffset | True | No | The end date time of the call | |
| Duration | Integer | True | No | The duration of the call | |
| CallType | String | True | No | The type of the call | |
| SuccessfulCall | String | True | No | The successful call | |
| CallerNumber | String | True | No | The caller number | |
| CalleeNumber | String | True | No | The callee number | |
| MediaPathLocation | String | True | No | The media path location | |
| SignalingLocation | String | True | No | The signaling location | |
| FinalSipCode | Integer | True | No | The final SIP Code | |
| CallEndSubReason | Integer | True | No | The sub reason of the call end | |
| FinalSipCodePhrase | String | True | No | The final SIP code phrase | |
| MediaBypassEnabled | Boolean | True | No | Whether Media Bypass is enabled or not | |
| FromDate | Edm.Date | True | No | The date from which calls to be fetched | |
| ToDate | Edm.Date | True | No | the date till when calls to be fetched |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| GroupId [KEY] | String | False | No | The Id of the Group. | |
| MemberId [KEY] | String | False | No | The User Id of the member listed. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| GroupId [KEY] | String | False | No | The Id of the Group. | |
| OwnerId [KEY] | String | False | No | The User Id of the owner listed. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier for the group. | |
| DeletedDateTime | Datetime | False | No | Timestamp of when the group was deleted. | |
| AllowExternalSenders | Bool | False | No | Indicates if people external to the organization can send messages to the group. Default value is false. | |
| AssignedLabels | String | False | No | The list of sensitivity label pairs (label ID, label name) associated with a Microsoft 365 group. | |
| AssignedLicenses | String | False | No | The licenses that are assigned to the group. | |
| AutoSubscribeNewMembers | Bool | False | No | Indicates if new members added to the group will be auto-subscribed to receive email notifications. You can set this property in a PATCH request for the group; do not set it in the initial POST request that creates the group. Default value is false. | |
| Classification | String | False | No | Describes a classification for the group (such as low, medium or high business impact). | |
| CreatedDateTime | Datetime | False | No | Timestamp of when the group was created. | |
| Description | String | False | No | An optional description for the group. | |
| DisplayName | String | False | No | The display name for the group. | |
| ExpirationDateTime | Datetime | False | No | Timestamp of when the group is set to expire. | |
| GroupTypes | String | False | No | Specifies the group type and its membership. | |
| HideFromAddressLists | Bool | False | No | true if the group is not displayed in certain parts of the Outlook user interface: in the Address Book, in address lists for selecting message recipients, and in the Browse Groups dialog for searching groups; false otherwise. Default value is false. | |
| HideFromOutlookClients | Bool | False | No | true if the group is not displayed in Outlook clients, such as Outlook for Windows and Outlook on the web, false otherwise. Default value is false. | |
| IsSubscribedByMail | Bool | False | No | Indicates whether the signed-in user is subscribed to receive email conversations. | |
| LicenseProcessingState_state | String | False | No | Indicates status of the group license assignment to all members of the group. | |
| String | False | No | The SMTP address for the group | ||
| MailEnabled | Bool | False | No | Specifies whether the group is mail-enabled. | |
| MailNickname | String | False | No | The mail alias for the group, unique in the organization. | |
| MembershipRule | String | False | No | The rule that determines members for this group if the group is a dynamic group (groupTypes contains DynamicMembership). | |
| MembershipRuleProcessingState | String | False | No | Indicates whether the dynamic membership processing is on or paused. Possible values are On or Paused. | |
| OnPremisesDomainName | String | False | No | Contains the on-premises domain FQDN, also called dnsDomainName synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Azure Active Directory via Azure AD Connect. | |
| OnPremisesLastSyncDateTime | Datetime | False | No | Indicates the last time at which the group was synced with the on-premises directory. | |
| OnPremisesNetBiosName | String | False | No | Contains the on-premises netBios name synchronized from the on-premises directory. | |
| OnPremisesProvisioningErrors | String | False | No | Errors when using Microsoft synchronization product during provisioning. | |
| OnPremisesSamAccountName | String | False | No | Contains the on-premises SAM account name synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Azure Active Directory via Azure AD Connect. | |
| OnPremisesSecurityIdentifier | String | False | No | Contains the on-premises security identifier (SID) for the group that was synchronized from on-premises to the cloud. | |
| OnPremisesSyncEnabled | Bool | False | No | true if this group is synced from an on-premises directory; false if this group was originally synced from an on-premises directory but is no longer synced; null if this object has never been synced from an on-premises directory (default). | |
| PreferredDataLocation | String | False | No | The preferred data location for the group. | |
| PreferredLanguage | String | False | No | The preferred language for a Microsoft 365 group. | |
| ProxyAddresses | String | False | No | Email addresses for the group that direct to the same group mailbox. | |
| RenewedDateTime | Datetime | False | No | Timestamp of when the group was last renewed. | |
| SecurityEnabled | Bool | False | No | Specifies whether the group is a security group. | |
| SecurityIdentifier | String | False | No | Security identifier of the group, used in Windows scenarios. | |
| Theme | String | False | No | Specifies a Microsoft 365 group's color theme. Possible values are Teal, Purple, Green, Blue, Pink, Orange or Red. | |
| UnseenCount | Int | False | No | Count of conversations that have received new posts since the signed-in user last visited the group. | |
| Visibility | String | False | No | Specifies the group join policy and group content visibility for groups. | |
| Members | String | False | No | The Members Id. | |
| Owners | String | False | No | The Owners Id. | |
| UserId | String | False | Users.Id | No | The User Id. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID for the scheduling group that the open shift belongs to. | |
| CreatedDateTime | Datetime | False | No | Timestamp at which the openshift was created. | |
| LastModifiedBy_application_displayName | String | False | No | The display name of the application that last modified. | |
| LastModifiedBy_application_id | String | False | No | The id of the application that last modified. | |
| LastModifiedDateTime | Datetime | False | No | The timestamp on which this openshift was last updated. | |
| DraftOpenShift_openSlotCount | Int | False | No | OpenSlotCount of DraftOpenShift | |
| SchedulingGroupId | String | False | No | The SchedulingGroupId. | |
| SharedOpenShift_openSlotCount | Int | False | No | OpenSlotCount of SharedOpenShift | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| DraftOpenShift_displayName | String | False | No | The shift label of the shiftItem.. | |
| DraftOpenShift_notes | String | False | No | The shift notes for the shiftItem.. | |
| DraftOpenShift_StartDateTime | Datetime | False | No | StartDateTime of DraftOpenShift | |
| DraftOpenShift_EndDateTime | Datetime | False | No | EndDateTime of DraftOpenShift | |
| SharedOpenShift_displayName | String | False | No | The shift label of the shiftItem.. | |
| SharedOpenShift_notes | String | False | No | The shift notes for the shiftItem.. | |
| SharedOpenShift_StartDateTime | Datetime | False | No | StartDateTime of SharedOpenShift | |
| SharedOpenShift_EndDateTime | Datetime | False | No | EndDateTime of SharedOpenShift |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id of of the PSTN Call | |
| CallId | String | True | No | The Id of the Call | |
| UserId | String | True | No | The Id of the user | |
| UserPrincipalName | String | True | No | The principal name of the user | |
| UserDisplayName | String | True | No | The display name of the user | |
| StartDateTime | Edm.DateTimeOffset | True | No | The datetime of the call when it was started | |
| EndDateTime | Edm.DateTimeOffset | True | No | The datetime of the call when it was ended | |
| Duration | Integer | True | No | The call duration | |
| Charge | Edm.Double | True | No | The charge | |
| CallType | String | True | No | The type of the call | |
| Currency | String | True | No | Currency | |
| CallerNumber | String | True | No | The number of the caller | |
| CalleeNumber | String | True | No | The number of the callee | |
| UsageCountryCode | String | True | No | The usage country code | |
| TenantCountryCode | String | True | No | The tenant country code | |
| ConnectionCharge | Edm.Double | True | No | The connection charge | |
| DestinationName | String | True | No | The destination name | |
| ConferenceId | String | True | No | The Id of the conference | |
| LicenseCapability | String | True | No | The License Capability | |
| InventoryType | String | True | No | The type of the inventory | |
| FromDate | Edm.Date | True | No | The date from which calls to be fetched | |
| ToDate | Edm.Date | True | No | the date till when calls to be fetched |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID of the schedule. | |
| TeamId [KEY] | String | False | Teams.Id | No | The Team Id. |
| Enabled | Bool | False | No | Indicates whether the schedule is enabled for the team. | |
| OfferShiftRequestsEnabled | Bool | False | No | Indicates whether offer shift requests are enabled for the schedule. | |
| OpenShiftsEnabled | Bool | False | No | Indicates whether open shifts are enabled for the schedule. | |
| ProvisionStatus | String | False | No | The status of the schedule provisioning. The possible values are notStarted, running, completed, failed. | |
| ProvisionStatusCode | String | False | No | Additional information about why schedule provisioning failed. | |
| SwapShiftsRequestsEnabled | Bool | False | No | Indicates whether swap shifts requests are enabled for the schedule. | |
| TimeClockEnabled | Bool | False | No | Indicates whether time clock is enabled for the schedule. | |
| TimeOffRequestsEnabled | Bool | False | No | Indicates whether time off requests are enabled for the schedule. | |
| TimeZone | String | False | No | Indicates the time zone of the schedule team using tz database format. | |
| WorkforceIntegrationIds | String | False | No | The WorkforceIntegration Ids. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID of the schedulingGroup. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| CreatedDateTime | Datetime | False | No | The time stamp in which this schedulingGroup was first created. | |
| LastModifiedBy_application_displayName | String | False | No | The display name of the application that last modified. | |
| LastModifiedBy_application_id | String | False | No | The id of the application that last modified. | |
| LastModifiedDateTime | Datetime | False | No | The time stamp in which this schedulingGroup was last updated. | |
| DisplayName | String | False | No | The display name for the schedulingGroup. | |
| IsActive | Bool | False | No | Indicates whether the schedulingGroup can be used when creating new entities or updating existing ones. | |
| UserIds | String | False | No | The list of user IDs that are a member of the schedulingGroup. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID of the shift. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| UserId | String | False | No | ID of the user assigned to the shift. | |
| CreatedDateTime | Datetime | False | No | The timestamp on which this shift was first created. | |
| LastModifiedBy_application_displayName | String | False | No | The display name of the application that last modified. | |
| LastModifiedBy_application_id | String | False | No | The id of the application that last modified. | |
| LastModifiedDateTime | Datetime | False | No | The timestamp on which this shift was last updated. | |
| DraftShift_activities | String | False | No | An incremental part of a shift which can cover details of when and where an employee is during their shift. For example, an assignment or a scheduled break or lunch. | |
| DraftShift_displayName | String | False | No | The shift label of the shiftItem. | |
| DraftShift_notes | String | False | No | The shift notes for the shiftItem. | |
| DraftShift_startDateTime | Datetime | False | No | The start date and time for the Draftshift | |
| DraftShift_endDateTime | Datetime | False | No | The end date and time for the Draftshift | |
| SchedulingGroupId | String | False | No | ID of the scheduling group the shift is part of. | |
| SharedShift_activities | String | False | No | An incremental part of a shift which can cover details of when and where an employee is during their shift. For example, an assignment or a scheduled break or lunch. | |
| SharedShift_displayName | String | False | No | The shift label of the shiftItem. | |
| SharedShift_notes | String | False | No | The shift notes for the shiftItem. | |
| SharedShift_startDateTime | Datetime | False | No | The start date and time for the Sharedshift | |
| SharedShift_endDateTime | Datetime | False | No | The end date and time for the Sharedshift |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | Member Id. | |
| TeamId | String | True | Teams.Id | No | Team Id. |
| DisplayName | String | True | No | Display name. | |
| String | True | No | Email of member. | ||
| Roles | String | True | No | Role of member. | |
| TenantId | String | True | No | Tenant Id. | |
| UserId | String | True | No | User Id. | |
| StartDateTime | Datetime | True | No | History start date time. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Team Id. | |
| GroupId | String | False | Groups.Id | No | The Group Id. |
| DisplayName | String | False | No | The name of the team. | |
| Description | String | False | No | An optional description for the team. | |
| Classification | String | False | No | An optional label. Typically describes the data or business sensitivity of the team. Must match one of a pre-configured set in the tenant's directory. | |
| CreatedDateTime | Datetime | False | No | Timestamp at which the team was created. | |
| FunSettings_allowCustomMemes | Bool | False | No | If set to true, enables users to include custom memes. | |
| FunSettings_allowGiphy | Bool | False | No | If set to true, enables Giphy use. | |
| FunSettings_allowStickersAndMemes | Bool | False | No | If set to true, enables users to include stickers and memes. | |
| FunSettings_giphyContentRating | String | False | No | Giphy content rating. Possible values are: moderate, strict. | |
| GuestSettings_allowCreateUpdateChannels | Bool | False | No | If set to true, guests can add and update channels. | |
| GuestSettings_allowDeleteChannels | Bool | False | No | If set to true, guests can delete channels. | |
| InternalId | String | False | No | A unique ID for the team that has been used in a few places such as the audit log/Office 365 Management Activity API. | |
| IsArchived | Bool | False | No | Whether this team is in read-only mode. | |
| MemberSettings_allowAddRemoveApps | Bool | False | No | If set to true, members can add and remove apps. | |
| MemberSettings_allowCreatePrivateChannels | Bool | False | No | If set to true, members can add and update private channels. | |
| MemberSettings_allowCreateUpdateChannels | Bool | False | No | If set to true, members can add and update any channels. | |
| MemberSettings_allowCreateUpdateRemoveConnectors | Bool | False | No | If set to true, members can add, update, and remove connectors. | |
| MemberSettings_allowCreateUpdateRemoveTabs | Bool | False | No | If set to true, members can add, update, and remove tabs. | |
| MemberSettings_allowDeleteChannels | Bool | False | No | If set to true, members can delete channels. | |
| MessagingSettings_allowChannelMentions | Bool | False | No | If set to true, @channel mentions are allowed. | |
| MessagingSettings_allowOwnerDeleteMessages | Bool | False | No | If set to true, owners can delete any message. | |
| MessagingSettings_allowTeamMentions | Bool | False | No | If set to true, @team mentions are allowed. | |
| MessagingSettings_allowUserDeleteMessages | Bool | False | No | If set to true, users can delete their messages. | |
| MessagingSettings_allowUserEditMessages | Bool | False | No | If set to true, users can edit their messages. | |
| Specialization | String | False | No | Optional. Indicates whether the team is intended for a particular use case. Each team specialization has access to unique behaviors and experiences targeted to its use case. | |
| Visibility | String | False | No | The visibility of the group and team. Defaults to Public. | |
| WebUrl | String | False | No | A hyperlink that will go to the team in the Microsoft Teams client. This is the URL that you get when you right-click a team in the Microsoft Teams client and select Get link to team. This URL should be treated as an opaque blob, and not parsed. | |
| summary_guestsCount | Integer | True | No | Count of guests in a team. | |
| summary_membersCount | Integer | True | No | Count of members in a team. | |
| summary_ownersCount | Integer | True | No | Count of owners in a team. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| TeamId | String | False | Teams.Id | No | Id of Team. |
| TeamsAppId | String | False | Apps.Id | No | Id of TeamsApp. |
| TeamsAppDefinitionDescription | String | False | No | Teams App Definition Description. | |
| TeamsAppDefinitionDisplayName | String | False | No | Teams App Definition Display Name | |
| TeamsAppDefinitionLastModifiedDateTime | Datetime | False | No | Teams App Definition Last Modified Date Time | |
| TeamsAppDefinitionPublishingState | String | False | No | Teams App Definition Publishing State | |
| TeamsAppDefinitionShortDescription | String | False | No | Teams App Definition Short Description | |
| TeamsAppDefinitionVersion | String | False | No | Teams App Definition Version |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| id [KEY] | String | False | No | Identifier that uniquely identifies a specific instance of a channel tab. | |
| AppId | String | False | Apps.Id | No | The App Id. |
| ChannelId | String | False | Channels.Id | No | The Channel Id. |
| Configuration_contentUrl | String | False | No | Url used for rendering tab contents in Teams. Required. | |
| Configuration_entityId | String | False | No | Identifier for the entity hosted by the tab provider. | |
| Configuration_removeUrl | String | False | No | Url called by Teams client when a Tab is removed using the Teams Client. | |
| Configuration_websiteUrl | String | False | No | Url for showing tab contents outside of Teams. | |
| DisplayName | String | False | No | Name of the tab. | |
| WebUrl | String | False | No | Deep link URL of the tab instance. | |
| TeamsApp_id | String | True | No | App definition identifier of the tab. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID of the timeOffReason. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| CreatedDateTime | Datetime | False | No | The time stamp on which this timeOffReason was first created. | |
| LastModifiedBy_application_displayName | String | False | No | The display name of the application that last modified. | |
| LastModifiedBy_application_id | String | False | No | The id of the application that last modified. | |
| LastModifiedDateTime | Datetime | False | No | The time stamp on which this timeOffReason was last updated. | |
| DisplayName | String | False | No | The name of the timeOffReason. Required. | |
| IconType | String | False | No | Supported icon types: none; car; calendar; running; plane; firstAid; doctor; notWorking; clock; juryDuty; globe; cup; phone; weather; umbrella; piggyBank; dog; cake; trafficCone; pin; sunny. | |
| IsActive | Bool | False | No | Indicates whether the timeOffReason can be used when creating new entities or updating existing ones. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | ID of the timeOff. | |
| UserId | String | False | No | ID of the user assigned to the timeOff. | |
| TeamId | String | False | Teams.Id | No | The Team Id. |
| CreatedDateTime | Datetime | False | No | The time stamp at which this timeOff was first created. | |
| LastModifiedBy_application_displayName | String | False | No | The display name of the application that last modified. | |
| LastModifiedBy_application_id | String | False | No | The id of the application that last modified. | |
| LastModifiedDateTime | Datetime | False | No | The time stamp at which this timeOff was last updated. | |
| DraftTimeOff_timeOffReasonId | String | False | No | DraftTimeOff's timeOffReasonId | |
| SharedTimeOff_timeOffReasonId | String | False | No | SharedTimeOff's timeOffReasonId | |
| DraftTimeOff_StartDateTime | Datetime | False | No | StartDateTime of DraftTimeOff | |
| DraftTimeOff_EndDateTime | Datetime | False | No | EndDateTime of DraftTimeOff | |
| SharedTimeOff_StartDateTime | Datetime | False | No | StartDateTime of DraftTimeOff | |
| SharedTimeOfft_EndDateTime | Datetime | False | No | EndDateTime of DraftTimeOff |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | False | Users.Id | No | Id of the users. |
| Availability | String | False | No | Availbility of user | |
| Activity | String | False | No | Activity of user | |
| StatusMessage_ExpiryDateTime_DateTime | String | False | No | StatusMessage_ExpiryDateTime_DateTime of user | |
| StatusMessage_ExpiryDateTime_TimeZone | String | False | No | StatusMessage_ExpiryDateTime_TimeZone of user | |
| StatusMessage_Message_Content | String | False | No | StatusMessage_Message_Content of user | |
| StatusMessage_PublishedDateTime | Datetime | False | No | StatusMessage_PublishedDateTime of user |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| id [KEY] | String | False | No | The id of the user. | |
| deletedDateTime | Datetime | False | No | The deletedDateTime of the user. | |
| accountEnabled | Bool | False | No | Indicates if accountEnabled for the user. | |
| assignedLicenses | String | False | No | The assignedLicenses of the user. | |
| businessPhones | String | False | No | The businessPhones of the user. | |
| city | String | False | No | The city of the user. | |
| companyName | String | False | No | The companyName of the user. | |
| country | String | False | No | The country of the user. | |
| createdDateTime | Datetime | False | No | The createdDateTime of the user. | |
| department | String | False | No | The department of the user. | |
| displayName | String | False | No | The displayName of the user. | |
| employeeHireDate | Datetime | False | No | The employeeHireDate of the user. | |
| employeeId | String | False | No | The employeeId of the user. | |
| employeeOrgData_costCenter | String | False | No | The employeeOrgData_costCenter of the user. | |
| employeeOrgData_division | String | False | No | The employeeOrgData_division of the user. | |
| employeeType | String | False | No | The employeeType of the user. | |
| givenName | String | False | No | The givenName of the user. | |
| identities | String | False | No | The identities of the user. | |
| imAddresses | String | False | No | The imAddresses of the user. | |
| isManagementRestricted | Bool | False | No | Indicator if user is management restricted. | |
| isResourceAccount | Bool | False | No | Indicates if it isResourceAccount of the user. | |
| jobTitle | String | False | No | The jobTitle of the user. | |
| lastPasswordChangeDateTime | Datetime | False | No | The lastPasswordChangeDateTime of the user. | |
| String | False | No | The mail of the user. | ||
| mailNickname | String | False | No | The mailNickname of the user. | |
| mobilePhone | String | False | No | The mobilePhone of the user. | |
| officeLocation | String | False | No | The officeLocation of the user. | |
| onPremisesDistinguishedName | String | False | No | The onPremisesDistinguishedName of the user. | |
| onPremisesDomainName | String | False | No | The onPremisesDomainName of the user. | |
| onPremisesExtensionAttributes_extensionAttribute1 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute1 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute10 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute10 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute11 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute11 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute12 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute12 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute13 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute13 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute14 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute14 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute15 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute15 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute2 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute2 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute3 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute3 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute4 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute4 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute5 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute5 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute6 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute6 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute7 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute7 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute8 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute8 of the user. | |
| onPremisesExtensionAttributes_extensionAttribute9 | String | False | No | The onPremisesExtensionAttributes_extensionAttribute9 of the user. | |
| onPremisesImmutableId | String | False | No | The onPremisesImmutableId of the user. | |
| onPremisesLastSyncDateTime | Datetime | False | No | The onPremisesLastSyncDateTime of the user. | |
| onPremisesProvisioningErrors | String | False | No | The onPremisesProvisioningErrors of the user. | |
| onPremisesSamAccountName | String | False | No | The onPremisesSamAccountName of the user. | |
| onPremisesSecurityIdentifier | String | False | No | The onPremisesSecurityIdentifier of the user. | |
| onPremisesSyncEnabled | Bool | False | No | Indicates onPremisesSyncEnabled for the user. | |
| onPremisesUserPrincipalName | String | False | No | The onPremisesUserPrincipalName of the user. | |
| otherMails | String | False | No | The otherMails of the user. | |
| passwordProfile_forceChangePasswordNextSignIn | Bool | False | No | The passwordProfile_forceChangePasswordNextSignIn of the user. | |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | False | No | The passwordProfile_forceChangePasswordNextSignInWithMfa of the user. | |
| passwordProfile_password | String | False | No | The passwordProfile_password of the user. | |
| postalCode | String | False | No | The postalCode of the user. | |
| preferredLanguage | String | False | No | The preferredLanguage of the user. | |
| serviceProvisioningErrors | String | False | No | The service provisioning errors of the user. | |
| state | String | False | No | The state of the user. | |
| streetAddress | String | False | No | The streetAddress of the user. | |
| surname | String | False | No | The surname of the user. | |
| userPrincipalName | String | False | No | The userPrincipalName of the user. | |
| userType | String | False | No | The userType of the user. | |
| Authentication_id | String | False | No | The Authentication Id | |
| Calendar_id | String | False | No | The Calendar Id | |
| Drive_id | String | False | No | The Drive Id | |
| InferenceClassification_id | String | False | No | The InferenceClassification Id | |
| Insights_id | String | False | No | The Insights Id | |
| Manager_id | String | False | No | The Manager Id | |
| Onenote_id | String | False | No | The Onenote Id | |
| Outlook_id | String | False | No | The Outlook Id | |
| Photo_id | String | False | No | The Photo Id | |
| Planner_id | String | False | No | The Planner Id | |
| Presence_id | String | False | No | The Presence Id | |
| Settings_id | String | False | No | The Settings Id | |
| Teamwork_id | String | False | No | The Teamwork Id | |
| Todo_id | String | False | No | The Todo Id |