Contacts
Provides access to the organizational contact list, including external and internal contact details.
View-Specific Information
SELECT
Id must be filtered using either the = or IN operator. For example:SELECT * FROM Contacts WHERE Id = '8b0a526e-178d-4494-a276-8819b74d7933'
SELECT * FROM Contacts WHERE Id IN ('8b0a526e-178d-4494-a276-8819b74d7933', 'a8f14261-fb3b-42f7-a27a-d29877b5010b')
SELECT * FROM Contacts WHERE DisplayName LIKE '%Test%'
Columns
| Name | Type | Description |
| id [KEY] | String | The unique identifier for the organizational contact, used for tracking and referencing. |
| deletedDateTime | Datetime | The timestamp indicating when the contact was deleted, if applicable. |
| addresses | String | A list of physical or postal addresses associated with the organizational contact. |
| companyName | String | The name of the company that the organizational contact is associated with. |
| department | String | The department within the company where the organizational contact works. |
| displayName | String | The full display name of the organizational contact, typically used in directories. |
| givenName | String | The first name or given name of the organizational contact. |
| jobTitle | String | The professional title or role of the organizational contact within the organization. |
| String | The primary email address of the organizational contact. | |
| mailNickname | String | An alias or nickname used for the contact's email. |
| onPremisesLastSyncDateTime | Datetime | The last recorded timestamp when the contact was synchronized with on-premises systems. |
| onPremisesProvisioningErrors | String | Details of any errors encountered during the provisioning of the contact on-premises. |
| onPremisesSyncEnabled | Bool | Indicates whether the contact is enabled for synchronization with on-premises systems. |
| phones | String | A list of phone numbers associated with the organizational contact. |
| proxyAddresses | String | Secondary email addresses or aliases associated with the organizational contact. |
| surname | String | The last name or family name of the organizational contact. |