Contacts

Stores contact information for users, including names, email addresses, phone numbers, and other metadata. This table provides access to personal or organizational contact directories.

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	Unique identifier for the contact entry in the Exchange system. This ID is used to reference the contact in queries and operations.
categories	String	False	List of user-defined categories assigned to the contact. Categories help organize and filter contacts in the address book.
changeKey	String	False	Versioning token used to detect changes to the contact. A new change key is generated every time the contact is updated.
createdDateTime	Datetime	False	Timestamp indicating when the contact was originally created in the mailbox.
lastModifiedDateTime	Datetime	False	Timestamp of the most recent update to the contact's information.
assistantName	String	False	Full name of the contact's assistant, if one is specified.
birthday	Datetime	False	Contact's birthdate, stored in Coordinated Universal Time (UTC).
businessAddress_street	String	False	Street address of the contact's primary business location.
businessAddress_city	String	False	City associated with the contact's business address.
businessAddress_state	String	False	State or province of the contact's business address.
businessAddress_countryOrRegion	String	False	Country or region of the contact's business address, formatted as a string.
businessAddress_postalCode	String	False	Postal or ZIP code of the contact's business address.
businessHomePage	String	False	URL to the contact's company or business homepage, if provided.
businessPhones	String	False	Comma-separated list of business phone numbers associated with the contact. Each number should be in international format if possible.
children	String	False	Comma-separated list of names of the contact's children, if provided.
companyName	String	False	Name of the organization or company where the contact is employed.
department	String	False	Department or division within the company where the contact works.
displayName	String	False	Formatted full name of the contact as displayed in Exchange and client interfaces.
emailAddresses	String	False	Comma-separated list of the contact's email addresses. Each address includes the name and the actual email address.
fileAs	String	False	Specifies how the contact should be filed or sorted, such as 'LastName, FirstName'.
generation	String	False	Contact's generational suffix, such as Jr., Sr., III, used in formal naming.
givenName	String	False	Contact's first name or given name.
homeAddress_street	String	False	Street portion of the contact's home address.
homeAddress_city	String	False	City portion of the contact's home address.
homeAddress_state	String	False	The state or province portion of the contact's residential address, used for geographic or mailing purposes.
homeAddress_countryOrRegion	String	False	The country or region of the contact's home address, typically used for location context or international correspondence.
homeAddress_postalCode	String	False	The postal code or ZIP code associated with the contact's home address, used for mailing and location identification.
homePhones	String	False	One or more home phone numbers for the contact, separated by commas if multiple are listed. Used for personal communication.
imAddresses	String	False	A list of instant messaging addresses associated with the contact, separated by commas. May include addresses for Skype, Teams, or other services.
initials	String	False	The initials of the contact's full name, often used for identification or display in address books.
jobTitle	String	False	The contact's job title or professional role, typically reflecting their current employment position.
manager	String	False	The name or identifier of the contact's manager or supervisor, if applicable. Useful for organizational hierarchy mapping.
middleName	String	False	The contact's middle name or middle initial, used as part of the full legal name or for identification purposes.
mobilePhone	String	False	The contact's personal or work mobile phone number, used for direct and often urgent communication.
nickName	String	False	The informal or preferred name the contact goes by, which can differ from their legal first name.
officeLocation	String	False	The physical office location or room number where the contact works, helpful for in-person meetings or mail delivery.
otherAddress_street	String	False	The street portion of an alternate address for the contact, often used when a secondary residence or mailing location is maintained.
otherAddress_city	String	False	The city or municipality of the alternate address associated with the contact.
otherAddress_state	String	False	The state or province of the alternate address, used for region-specific identification.
otherAddress_countryOrRegion	String	False	The country or region associated with the alternate address of the contact.
otherAddress_postalCode	String	False	The postal or ZIP code for the contact's alternate address, supporting mailing and location-based services.
parentFolderId	String	False	The unique identifier of the parent folder where the contact is stored, used for organizing and retrieving contact records.
personalNotes	String	False	Any freeform notes or remarks related to the contact, typically added by the user to store personal or contextual information.
profession	String	False	The professional field or industry in which the contact works, such as Engineering, Medicine, or Education.
spouseName	String	False	The full name of the contact's spouse or partner, when applicable.
surname	String	False	The family or last name of the contact, often used as the primary identifier in sorted lists.
title	String	False	An honorific or courtesy title for the contact, such as Mr., Ms., Dr., or Prof.
yomiCompanyName	String	False	The phonetic Japanese reading (Yomi) of the company name where the contact works. Useful in Japanese-language sorting or pronunciation support.
yomiGivenName	String	False	The Yomi phonetic version of the contact's given (first) name, primarily used in Japanese locales.
yomiSurname	String	False	The Yomi phonetic version of the contact's surname (family name), used for pronunciation and alphabetical ordering in Japanese systems.

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.