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 add-in 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. |