ODBC Driver for Google Directory

Build 24.0.9062

Groups

Create, update, delete, and query groups.

Table Specific Information

Select

To get a list of all the groups, the CustomerId is required. You can either set it in the connection string or in the WHERE clause condition. If not specified, the CustomerId of the current account will be used.

For example, the following query is processed server side by the Google Directory API:

SELECT * FROM Groups

Insert

To insert a group, the Email column is required.

INSERT INTO Groups (Email, Name, Description) VALUES ('[email protected]', 'Group Example Name', 'Example Description')

Update

To update a group, the Id is required.

UPDATE Groups SET Email = '[email protected]', Name = 'Group', Description = 'Description' WHERE Id = 1231

Delete

To delete a group, the Id column is required.

DELETE FROM Groups WHERE Id = '12345'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The unique identifier for the group.

Email String False

The email of the group.

Name String False

The name of the group.

MembersCount Long True

The number of members.

Description String False

Description of the group.

Aliases String True

Aliases of the group.

AdminCreated Boolean True

Indicates if the group was created by an admin.

ETag String True

ETag of the resource

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CustomerId String

The customer Id of the group.

Domain String

Domain name.

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