Contacts
Provides access to the organizational contact list, including external and internal contact details.
Table Specific Information
Select
Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition.
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. |