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. |
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. |