This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
Note
| 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 |
j
