JDBC Driver for Azure Active Directory

Build 22.0.8509

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.
mail 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509