ODBC Driver for Google Directory

Build 24.0.9062

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.

Email 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062