Contacts

Retrieves a list of all contacts.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True
GivenName	String	False
FamilyName	String	False
MiddleName	String	False
Addresses	String	False
Anniversary	Datetime	False
Birthday	Datetime	False
CompanyId	Integer	False	Companies.Id
TagId	String	True
CompanyName	String	True
ContactType	String	False
CustomFields	String	True
EmailAddresses	String	False
IsEmailOptedIn	Boolean	True
EmailStatus	String	True
FaxNumbers	String	False
JobTitle	String	False
LeadSourceId	Integer	False
OwnerId	Integer	False
PhoneNumbers	String	False
PreferredLocale	String	False
PreferredName	String	False
Prefix	String	False
ScoreValue	String	True
SocialAccounts	String	False
SourceType	String	True
SpouseName	String	False
Suffix	String	False
TimeZone	String	False
Website	String	False
DateCreated	Datetime	True
LastUpdated	Datetime	True

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
Email	String	Optional email address to query on