Contacts
Retrieves the Contacts for the organization.
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 id of the organizationalContact. |
| deletedDateTime | Datetime | The datetime when the contact was deleted. |
| addresses | String | The addresses of the organizationalContact. |
| companyName | String | The companyName of the organizationalContact. |
| department | String | The department of the organizationalContact. |
| displayName | String | The displayName of the organizationalContact. |
| givenName | String | The givenName of the organizationalContact. |
| jobTitle | String | The jobTitle of the organizationalContact. |
| String | The mail of the organizationalContact. | |
| mailNickname | String | The mailNickname of the organizationalContact. |
| onPremisesLastSyncDateTime | Datetime | The onPremisesLastSyncDateTime of the organizationalContact. |
| onPremisesProvisioningErrors | String | The provisioning errors of the organizationalContact. |
| onPremisesSyncEnabled | Bool | Indicator if organizationalContact is onPremisesSyncEnabled. |
| phones | String | The phones of the organizationalContact. |
| proxyAddresses | String | The proxyAddresses of the organizationalContact. |
| surname | String | The surname of the organizationalContact. |