SSIS Components for Google Directory

Build 24.0.9062

GroupAliases

Create, delete, and query aliases for a group.

Table Specific Information

Select

To get a list of all the aliases for a group, the GroupId column is required. If not specified, the GroupId of the first group from the Groups table will be used.

The following query shows the only filter processed server side by the Google Directory API:

SELECT * FROM GroupAliases WHERE GroupId = '12345'

Insert

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

INSERT INTO GroupAliases (GroupId, Alias) VALUES ('12345', 'Alias')

Update

UPDATEs are not supported for this table.

Delete

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

DELETE FROM GroupAliases WHERE GroupId = '12345' AND Alias = 'Alias'

Columns

Name Type ReadOnly Description
Alias [KEY] String False

The alias email address.

GroupId String True

Id of the group.

PrimaryEmail String True

PrimaryEmail of the group.

ETag String True

ETag of the resource.

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