Excel Add-In for Google Directory

Build 24.0.9060

DomainAliases

Create, update, and query aliases of a domain.

Table Specific Information

Select

To get a list of all the aliases for a domain, 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 DomainAliases

Insert

To insert an alias, the following columns are required: CustomerId, ParentDomain, and DomainAliasName.

INSERT INTO DomainAliases (CustomerId, DomainAliasName, ParentDomain) VALUES ('12345', 'Alias', 'parentdomain.com')

Update

UPDATEs are not supported for this table.

Delete

To delete an alias, the following columns are required: CustomerId and DomainAliasName.

DELETE FROM DomainAliases WHERE CustomerId = 'C020vaw0q' AND DomainAliasName = 'Alias'

Columns

Name Type ReadOnly Description
DomainAliasName [KEY] String False

The domain alias name.

ParentDomain String False

The parent domain name that the domain alias is associated with.

IsVerified Boolean True

Indicates the verification state of a domain alias.

CreationDate Timestamp True

Creation date timestamp of the domain alias in milliseconds.

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060