SSIS Components for Google Directory

Build 24.0.9062

UserPhones

Query the phone numbers for a user.

Table Specific Information

Select

To get a list of phones 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 UserPhones

Columns

Name Type Description
PhoneNumber String The user's phone number.
UserId String The unique identifier for the user.
IsPrimary String Indicates if this is the user's primary IM.
CustomType String The custom type of the phone number.
Type String The type of the phone number.

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