Groups
The Office365 table Groups.
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. See Creating an Azure AD Application for more details on creating a custom app.
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 WHERE Id = 'Group Id here' SELECT Id, Description, DisplayName FROM Groups WHERE DisplayName = '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 | References | Description |
| id [KEY] | String | True |
The unique identifier for the group. | |
| Etag | String | False | ||
| deletedDateTime | Datetime | False | ||
| allowExternalSenders | Bool | False |
Indicates if people external to the organization can send messages to the group. | |
| assignedLabels | String | False | ||
| assignedLicenses | String | False | ||
| autoSubscribeNewMembers | Bool | False |
Indicates if new members added to the group will be auto-subscribed to receive email notifications. | |
| classification | String | False | ||
| createdDateTime | Datetime | False | ||
| description | String | False |
An optional description for the group. | |
| displayName | String | False |
The display name for the group. | |
| expirationDateTime | Datetime | False | ||
| groupTypes | String | False |
Specifies the type of group to create. Possible values are Unified to create an Office 365 group, or DynamicMembership for dynamic groups. For all other group types, like security-enabled groups and email-enabled security groups, do not set this property. | |
| hasMembersWithLicenseErrors | Bool | False | ||
| hideFromAddressLists | Bool | False | ||
| hideFromOutlookClients | Bool | False | ||
| isArchived | Bool | False | ||
| isSubscribedByMail | Bool | False |
Indicates whether the current user is subscribed to receive email conversations. | |
| licenseProcessingState_state | String | False | ||
| String | False |
The SMTP address for the group. | ||
| mailEnabled | Bool | False |
Specifies whether the group is mail-enabled. If the securityEnabled property is also true, the group is a mail-enabled security group; otherwise, the group is a Microsoft Exchange distribution group. | |
| mailNickname | String | False |
The mail alias for the group, unique in the organization. | |
| membershipRule | String | False | ||
| membershipRuleProcessingState | String | False | ||
| onPremisesDomainName | String | False | ||
| onPremisesLastSyncDateTime | Datetime | False |
Indicates the last time at which the group was synced with the on-premises directory. | |
| onPremisesNetBiosName | String | False | ||
| onPremisesProvisioningErrors | String | False | ||
| onPremisesSamAccountName | String | False | ||
| onPremisesSecurityIdentifier | String | False |
Contains the on-premises security identifier (SID) for the group that was synchronized from on-premises to the cloud. | |
| onPremisesSyncEnabled | Bool | False |
True if this group is synced from an on-premises directory; false if this group was originally synced from an on-premises directory but is no longer synced; null if this object has never been synced from an on-premises directory. | |
| preferredDataLocation | String | False | ||
| preferredLanguage | String | False | ||
| proxyAddresses | String | False |
The proxy addresses for the table Groups. | |
| renewedDateTime | Datetime | False | ||
| securityEnabled | Bool | False |
Specifies whether the group is a security group. If the mailEnabled property is also true, the group is a mail-enabled security group; otherwise it is a security group. Must be false for Office 365 groups. | |
| securityIdentifier | String | False | ||
| theme | String | False | ||
| unseenCount | Int | False |
Count of posts that the current user has not seen since his last visit. | |
| visibility | String | False |
Specifies the visibility of an Office 365 group. The possible values are: Private, Public, HiddenMembership, or empty (which is interpreted as Public). |