SSIS Components for Google Directory

Build 24.0.9060

Roles

Lists roles in a domain.

Table Specific Information

Select

To get a list of all the roles, 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 Roles

Columns

Name Type Description
Id [KEY] String The unique identifier for the role.
Name String Name of the role.
Description String A short description of the role.
PrivilegeName String The name of the privilege.
ServiceId String The ID of the service the privilege is for.
IsSystemRole Boolean Indicates if it is a pre-defined system role.
IsSuperAdminRole Boolean Indicates if the role is a super admin role.
Etag String 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