Groups

null

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

Description [KEY] String Datetime Bool String String Bool String Datetime String String Datetime String Bool Bool Bool Bool Bool Bool String String Bool String String String String Datetime String String String String Bool String String String Datetime Bool String String String String Int String String String String String String String String


Name	Type
id
deletedDateTime
allowExternalSenders
assignedLabels
assignedLicenses
autoSubscribeNewMembers
classification
createdDateTime
description
displayName
expirationDateTime
groupTypes
hasMembersWithLicenseErrors
hideFromAddressLists
hideFromOutlookClients
isArchived
isAssignableToRole
isSubscribedByMail
licenseProcessingState_state
mail
mailEnabled
mailNickname
membershipRule
membershipRuleProcessingState
onPremisesDomainName
onPremisesLastSyncDateTime
onPremisesNetBiosName
onPremisesProvisioningErrors
onPremisesSamAccountName
onPremisesSecurityIdentifier
onPremisesSyncEnabled
preferredDataLocation
preferredLanguage
proxyAddresses
renewedDateTime
securityEnabled
securityIdentifier
serviceProvisioningErrors
theme
uniqueName
unseenCount
visibility
calendar_id
createdOnBehalfOf_id
drive_id
onenote_id
photo_id
planner_id
team_id

JDBC Driver for Microsoft Planner

Groups

Table Specific Information

Select

Columns