ODBC Driver for Microsoft Planner

Build 24.0.9063

Groups

It is automatically created to support a plan that is created.

Table Specific Information

Select

The 本製品 will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.

If Scope = AdminConsent, List all the data related to groups.

  • Id supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Groups WHERE Id = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

Columns

Name Type Description
Id [KEY] String Unique identifier for the group.
deletedDateTime Datetime Timestamp of when the group was deleted.
allowExternalSenders Bool Typically used for people external to the organization that can send messages to the group.
assignedLabels String Specifies list of sensitivity label pairs associated with a group.
assignedLicenses String Specifies licenses that are assigned to the group.
autoSubscribeNewMembers Bool Typically used for new members added to the group that are autosubscribed to receive email notifications.
classification String Specifies classification for the group.
createdDateTime Datetime Specifies timestamp of when the group was created.
description String An optional description for the group.
displayName String The display name for the group.
expirationDateTime Datetime Timestamp of when the group is set to expire.
groupTypes String Specifies the group type and its membership.
hasMembersWithLicenseErrors Bool Specifies members in this group that have license errors from its group-based license assignment.
hideFromAddressLists Bool This property is true if the group is not displayed in certain parts.
hideFromOutlookClients Bool The label Hide from Outlook Clients corresponds to this field.
isArchived Bool Typically used for groups associated with a team and whether the team is in read-only mode.
isAssignableToRole Bool Specifies whether a group can be assigned to a Microsoft Entra role.
isSubscribedByMail Bool Specifies the signed-in user that is subscribed to receive email conversations.
licenseProcessingState_state String Specifies the status of the group license assignment to all group members.
mail String The mail for the group.
mailEnabled Bool Specifies whether the group is mail-enabled.
mailNickname String Specifies the mail alias for the group.
membershipRule String Specifies the rule for members of this group.
membershipRuleProcessingState String Specifies whether the dynamic membership processing is on or paused.
onPremisesDomainName String Specifies the on-premises domain.
onPremisesLastSyncDateTime Datetime Specifies the on-premises last sync date time.
onPremisesNetBiosName String Specifies the on-premises netBios name synchronized from the on-premises directory.
onPremisesProvisioningErrors String Specifies the on-premises provisioning errors.
onPremisesSamAccountName String Specifies the on-premises SAM account name synchronized from the on-premises directory.
onPremisesSecurityIdentifier String Specifies the on-premises security identifier for the group that is synchronized from on-premises to the cloud.
onPremisesSyncEnabled Bool Specifies whether the group is currently synced from an on-premises directory.
preferredDataLocation String Specifies the preferred date location.
preferredLanguage String The preferred language for a group.
proxyAddresses String Specifies the email addresses for the group that direct to the same group mailbox.
renewedDateTime Datetime Timestamp of when the group was last renewed.
securityEnabled Bool Specifies whether the group is a security group.
securityIdentifier String Specifies the security identifier of the group.
serviceProvisioningErrors String Specifies service provisioning errors.
theme String Specifies a group's color theme.
uniqueName String The unique identifier that can be assigned to a group and used as an alternate key.
unseenCount Int Specifies the count of conversations that have received new posts since the user last visited the group.
visibility String Specifies the group join policy and group content visibility for groups.
calendar_id String Unique identifier of the calendar.
createdOnBehalfOf_id String Unique identifier of the user (or application) that created the group.
drive_id String Unique identifier of the drive.
onenote_id String Unique identifier of the onenote. Read-only
photo_id String Unique identifier of the group's profile photo.
planner_id String Unique identifier of the planner.
team_id String Unique identifier of the team associated with the group.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063