Excel Add-In for Google Directory

Build 24.0.9062

Tokens

Query and delete tokens for a user.

Table Specific Information

Select

To get a current set of tokens a specified user has issued to 3rd party applications, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. If not specified, the Id of the first user from the Users table will be used.

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

SELECT * FROM Tokens

INSERT

INSERTs are not supported for this table.

Update

UPDATEs are not supported for this table.

Delete

To delete a token, the UserId and Id columns are required.

DELETE FROM Tokens WHERE UserId = '12345' AND Id = '123456'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The Client ID of the application the token is issued to.

UserId String False

Aggregate of child privileges.

DisplayText String False

The displayable name of the application the token is issued to.

IsAnonymous Boolean False

Indicates if the name of the privilege.

IsNativeApp Boolean False

Indicates if the token is issued to an installed application.

ScopesAggregate String False

Aggregate of child privileges.

Etag String False

Etag of the resource.

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