OrganizationUnits
Create, update, delete, and query the organization units for a customer.
Table Specific Information
Select
To get a list of all the organization units, the CustomerId column is required. It can be set 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 APIs:
SELECT * FROM OrganizationUnits
Insert
To insert an organization unit, the following columns are required: CustomerId, Name, and ParentOrgUnitId. If not specified, the CustomerId of the current account will be used.
INSERT INTO OrganizationUnits (CustomerId, Name, Description, OrgUnitPath, ParentOrgUnitId, ParentOrgUnitPath) VALUES ('12345', 'OrgUnit Name', 'OrgUnit Description', 'Path', '123456', 'ParentPath', '1234')
Update
To update an organization unit, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.
UPDATE OrganizationUnits SET Name = 'OrgUnit Name', 'Description = 'OrgUnit Description', OrgUnitPath = 'Path', ParentOrgUnitId = '123456', ParentOrgUnitPath = 'ParentPath' WHERE CustomerId = '1234' AND Id = '12345'
Delete
To delete an organization unit, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.
DELETE FROM OrganizationUnits WHERE CustomerId = '1234' AND Id = '12345'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
Id of the Organization Unit. |
Name | String | False |
Name of the Organization Unit. |
Description | String | False |
Description of the Organization Unit. |
OrgUnitPath | String | False |
Path of the OrgOrganization Unit.Unit |
ParentOrgUnitPath | String | False |
Path of the Organization Unit's parent. |
ParentOrgUnitId | String | False |
Id of the Organization Unit's parent |
ETag | String | True |
ETag of the resource. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CustomerId | String |
Id of the customer |