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.

SSIS Components for Google Directory