JDBC Driver for Microsoft Exchange

Build 22.0.8462

Contacts

Contacts table for Exchange data provider.

Table Specific Information

Select

You can query Contacts by specifying an Id or selecting all:

SELECT * FROM Contacts WHERE Id = 'your Contact Id goes here'

Select a certain column from the entity and filter by that column:

SELECT GivenName FROM Contacts WHERE GivenName LIKE 'John%'

Insert

Specify a GivenName and a Surname as a minimum in order to create a new Contact:

INSERT INTO Contacts (GivenName, Surname) VALUES ('John', 'Smith')

Columns

Name Type ReadOnly Description
id [KEY] String False

categories String False

changeKey String False

createdDateTime Datetime False

lastModifiedDateTime Datetime False

assistantName String False

birthday Datetime False

businessAddress_street String False

businessAddress_city String False

businessAddress_state String False

businessAddress_countryOrRegion String False

businessAddress_postalCode String False

businessHomePage String False

businessPhones String False

children String False

companyName String False

department String False

displayName String False

emailAddresses String False

fileAs String False

generation String False

givenName String False

homeAddress_street String False

homeAddress_city String False

homeAddress_state String False

homeAddress_countryOrRegion String False

homeAddress_postalCode String False

homePhones String False

imAddresses String False

initials String False

jobTitle String False

manager String False

middleName String False

mobilePhone String False

nickName String False

officeLocation String False

otherAddress_street String False

otherAddress_city String False

otherAddress_state String False

otherAddress_countryOrRegion String False

otherAddress_postalCode String False

parentFolderId String False

personalNotes String False

profession String False

spouseName String False

surname String False

title String False

yomiCompanyName String False

yomiGivenName String False

yomiSurname String False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
userId String

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