ContactsPhones
The details related to the phone number.
Table-Specific Information
SELECT
The connector will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the connector.
SELECT * FROM ContactsPhones WHERE phonetypeId = 12 SELECT * FROM ContactsPhones WHERE phonetypeId > 15 SELECT * FROM ContactsPhones WHERE rawnumber LIKE '%test' SELECT * FROM ContactsPhones WHERE phonetypeId IN (12, 23, 123) SELECT * FROM ContactsPhones WHERE rawnumber IS NOT NULL
Columns
| Name | Type | Description |
| ContactsId | Long | The unique identifier of the contact. |
| Number | String | The free-form phone number including non-numeric characters. For example, 1 (406) 522-4200. |
| PhoneTypeId | Long | Id of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry. |
| PhoneTypelookUpName | String | LookUpName of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry. |
| RawNumber | String | The automatically populated numeric string derived by excluding the non-numeric characters from the value of the Number attribute. For example, if the Number attribute has a value of 1 (406) 522-4200, this field is populated as 14065224200. This attribute is read-only. |