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