GroupMembers
Create, update, delete, and query the members for a group.
Table Specific Information
Select
To get a list of all the members of a group, the GroupId column is required. If not specified, the Id of the first group from the Groups table will be used.
The following query shows the only filter processed server side by the Google Directory API:
SELECT * FROM GroupMembers WHERE GroupId = '12345'
Insert
To insert a member, the following columns are required: Email and GroupId.
The Role column only accepts the following values: MEMBER, MANAGER, and OWNER.
INSERT INTO GroupMembers (Email, GroupId, Role) VALUES ('[email protected]', '12345', 'MEMBER')
Update
To update a member, the following columns are required: GroupId and Id.
UPDATE GroupMembers SET Role = 'MEMBER' WHERE GroupId = '1234' AND Id = '12345'
Delete
To delete a member, the following columns are required: GroupId and Id.
DELETE FROM GroupMembers WHERE GroupId = '1234' AND Id = '12345'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier for the member. |
GroupId | String | True |
The unique identifier for the member. |
String | False |
The email of the member. | |
Role | String | False |
The name of the member. |
Status | String | True |
The status of the member. |
Type | String | True |
The type of members. |
ETag | String | True |
ETag of the resource |