ODBC Driver for Microsoft Planner

Build 23.0.8839


The Groups resource provides methods that allow you to manage groups for the account.

Table Specific Information


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'


Name Type Description
id [KEY] String
Etag String
deletedDateTime Datetime
allowExternalSenders Bool
assignedLicenses String
autoSubscribeNewMembers Bool
classification String
createdDateTime Datetime
description String
displayName String
groupTypes String
hasMembersWithLicenseErrors Bool
isArchived Bool
isSubscribedByMail Bool
licenseProcessingState_state String
mail String
mailEnabled Bool
mailNickname String
onPremisesLastSyncDateTime Datetime
onPremisesProvisioningErrors String
onPremisesSecurityIdentifier String
onPremisesSyncEnabled Bool
preferredDataLocation String
proxyAddresses String
renewedDateTime Datetime
securityEnabled Bool
unseenCount Int
visibility String

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