GroupMembers
Group Members 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 GroupMember.Read.All and the GroupMember.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 GroupMembers permissions, an administrator must grant the GroupMembers 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
The add-in uses the Microsoft Exchange API to process WHERE clause conditions. The rest of the filter is executed client-side in the add-in.
For example, the following query is processed server-side:
SELECT * FROM GroupMembers
Columns
Name | Type | Description |
Id [KEY] | String | |
GroupId | String | |
AssistantName | String | |
BusinessPhones | String | |
Classification | String | |
CreatedDateTime | Datetime | |
CreationOptions | String | |
DeletedDateTime | Datetime | |
Description | String | |
DisplayName | String | |
ExpirationDateTime | Datetime | |
GivenName | String | |
GroupTypes | String | |
IsAssignableToRole | Boolean | |
JobTitle | String | |
String | ||
MailEnabled | Bool | |
MailNickname | String | |
MembershipRule | String | |
MembershipRuleProcessingState | String | |
MobilePhone | String | |
OfficeLocation | 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 | |
Surname | String | |
UserPrincipalName | String | |
Visibility | String |