Skip to main content

aliases

Creates, updates, deletes, gets or lists an aliases resource.

Overview

Namealiases
TypeResource
Idgoogleadmin.directory.aliases

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
aliasesarray
etagstring
kindstring (default: admin#directory#aliases)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectuserKeyeventLists all aliases for a user.
insertinsertuserKeyAdds an alias.
deletedeleteuserKey, aliasRemoves an alias.
watchexecuserKeyeventWatches for changes in users list.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
aliasstring
userKeystring
eventstring

SELECT examples

Lists all aliases for a user.

SELECT
aliases,
etag,
kind
FROM googleadmin.directory.aliases
WHERE userKey = '{{ userKey }}' -- required
AND event = '{{ event }}';

INSERT examples

Adds an alias.

INSERT INTO googleadmin.directory.aliases (
data__alias,
data__etag,
data__id,
data__kind,
data__primaryEmail,
userKey
)
SELECT
'{{ alias }}',
'{{ etag }}',
'{{ id }}',
'{{ kind }}',
'{{ primaryEmail }}',
'{{ userKey }}'
RETURNING
id,
alias,
etag,
kind,
primaryEmail
;

DELETE examples

Removes an alias.

DELETE FROM googleadmin.directory.aliases
WHERE userKey = '{{ userKey }}' --required
AND alias = '{{ alias }}' --required;

Lifecycle Methods

Watches for changes in users list.

EXEC googleadmin.directory.aliases.watch 
@userKey='{{ userKey }}' --required,
@event='{{ event }}'
@@json=
'{
"id": "{{ id }}",
"token": "{{ token }}",
"expiration": "{{ expiration }}",
"type": "{{ type }}",
"address": "{{ address }}",
"payload": {{ payload }},
"params": "{{ params }}",
"resourceId": "{{ resourceId }}",
"resourceUri": "{{ resourceUri }}",
"kind": "{{ kind }}"
}';