JDBC Driver for Google Directory

Build 22.0.8462

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. The driver processes other queries client-side in memory.

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CustomerId String

Id of the customer

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462