ODBC Driver for Google Directory

Build 24.0.9062

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

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