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 driver processes other queries client-side in memory.

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 ('john@example.com', '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