JDBC Driver for Microsoft Exchange

Build 22.0.8462

Groups

Groups table for Exchange data provider.

Table Specific Information

Groups require Administrator permissions. To work with them, you must create your own custom OAuth App and set the appropriate OAuthClientId and OAuthClientSecret. In this app, you must configure it to request the Group.Read.All and the Group.ReadWrite.All permissions. This can be done at https://apps.dev.microsoft.com, or in the App Registrations panel at http://portal.azure.com.

To authorize Groups permissions, an administrator must grant the Groups permissions for your organization at large. This can be done via the administrator authorization endpoint. Simply have the administrator navigate to the following web page and grant permissions. Then run the OAuth authorization as normal afterwards.

https://login.microsoftonline.com/common/adminconsent?client_id=[YourClientId]&redirect_uri=http://localhost:33333

Note that if your organization has multiple tenants, you may replace the /common/ in the url with the tenant id to indicate which tenant to grant permissions for.

Select

Retrieve all groups, specify a GroupId (Id), or simply filter by a certain column:

SELECT * FROM Groups
SELECT * FROM Groups WHERE Id = 'Group Id here'
SELECT Id, Description, DisplayName FROM Groups WHERE Name = 'test'

Insert

The following are required to create a new Security Group:

INSERT INTO Groups (DisplayName, MailEnabled, MailNickname, SecurityEnabled) VALUES ('Test group', false, 'test', true)

Columns

Name Type ReadOnly Description
id [KEY] String False

deletedDateTime Datetime False

allowExternalSenders Bool False

assignedLicenses String False

autoSubscribeNewMembers Bool False

classification String False

createdDateTime Datetime False

description String False

displayName String False

groupTypes String False

hasMembersWithLicenseErrors Bool False

isArchived Bool False

isSubscribedByMail Bool False

licenseProcessingState_state String False

mail String False

mailEnabled Bool False

mailNickname String False

onPremisesLastSyncDateTime Datetime False

onPremisesProvisioningErrors String False

onPremisesSecurityIdentifier String False

onPremisesSyncEnabled Bool False

preferredDataLocation String False

proxyAddresses String False

renewedDateTime Datetime False

securityEnabled Bool False

unseenCount Int False

visibility String False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462