Groups
null
Table Specific Information
Select
The add-in 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 add-in.
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 | |
deletedDateTime | Datetime | |
allowExternalSenders | Bool | |
assignedLabels | String | |
assignedLicenses | String | |
autoSubscribeNewMembers | Bool | |
classification | String | |
createdDateTime | Datetime | |
description | String | |
displayName | String | |
expirationDateTime | Datetime | |
groupTypes | String | |
hasMembersWithLicenseErrors | Bool | |
hideFromAddressLists | Bool | |
hideFromOutlookClients | Bool | |
isArchived | Bool | |
isAssignableToRole | Bool | |
isSubscribedByMail | Bool | |
licenseProcessingState_state | String | |
String | ||
mailEnabled | Bool | |
mailNickname | String | |
membershipRule | String | |
membershipRuleProcessingState | String | |
onPremisesDomainName | String | |
onPremisesLastSyncDateTime | Datetime | |
onPremisesNetBiosName | String | |
onPremisesProvisioningErrors | String | |
onPremisesSamAccountName | String | |
onPremisesSecurityIdentifier | String | |
onPremisesSyncEnabled | Bool | |
preferredDataLocation | String | |
preferredLanguage | String | |
proxyAddresses | String | |
renewedDateTime | Datetime | |
securityEnabled | Bool | |
securityIdentifier | String | |
serviceProvisioningErrors | String | |
theme | String | |
uniqueName | String | |
unseenCount | Int | |
visibility | String | |
calendar_id | String | |
createdOnBehalfOf_id | String | |
drive_id | String | |
onenote_id | String | |
photo_id | String | |
planner_id | String | |
team_id | String |