Excel Add-In for Google Directory

Build 24.0.9062

UserAliases

Lists aliases, which are alternative email addresses for a user.

Table Specific Information

Select

To get a list of all the aliases for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the 本製品 will automatically use the Id of the first user from the Users table.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM Aliases

Insert

To insert an alias, the following columns are required: UserId and Alias.

INSERT INTO Aliases (UserId, Alias) VALUES ('12345', 'Alias')

Update

UPDATEs are not supported for this table.

Delete

To delete an alias, the following columns are required: UserId and Alias.

DELETE FROM Aliases WHERE Id = '12345' AND Alias = 'Alias'

Columns

Name Type ReadOnly Description
Alias [KEY] String False

The alias email address.

UserId String True

Id of the user.

PrimaryEmail String True

PrimaryEmail of the user.

ETag String True

ETag of the resource.

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