Query the Contacts belonging to a Company.

Table Specific Information

Select

• Id supports the '=' operator.
• CompanyId supports the '=' operator.
• Created supports the '<=,<,=,!=,>,>=' operator.
• FullName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AltEmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AlternateExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AlternatePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Birthday supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• BusinessPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Company supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• ContactType supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Department supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Edited supports the '<=,<,=,!=,>,>=' operator.
• EditedBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• EmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• FaxExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• FaxPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• FirstName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomeExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HomePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• IdStatus supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• IsUser supports the '=' operator.
• JobTitle supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• LastName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• LastResults supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Latitude supports the '<=,<,=,!=,>,>=' operator.
• Longitude supports the '<=,<,=,!=,>,>=' operator.
• MessengerID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• MiddleName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• MobileExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• MobilePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• NamePrefix supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• NameSuffix supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• PagerExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• PagerPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• PersonalEmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• RecordOwner supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• ReferredBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Salutation supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Website supports the '<=,<,=,!=,>,>=,CONTAINS' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following query is processed server side:

SELECT * FROM CompanyContacts WHERE Fullname = 'Contact name' 

Delete

CompanyContacts can be deleted by providing CompanyId and Id and issuing a DELETE statement.

DELETE FROM CompanyContacts WHERE CompanyId = '12345' AND Id = '56789'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (id) for this contact.
CompanyId [KEY]	String	The unique identifier (id) of the company to retrieve contacts from.
Created	Datetime	Created data of the contact.
FullName	String	The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!
AltEmailAddress	String	A unique electronic address that an individual can be contacted.
AlternateExtension	String	The contact's alternate phone number extension.
AlternatePhone	String	The contact's alternate phone number.
Birthday	String	The anniversary of the day on which a person was born.
BusinessAddressCity	String	An inhabited place of greater size, population, or importance than a town or village.
BusinessAddressCountry	String	A nation with its own government, occupying a particular territory.
BusinessAddressLine1	String	Primary street address
BusinessAddressLine2	String	Secondary street address
BusinessAddressLine3	String	Miscellaneous street address
BusinessAddressPostalCode	String	A code of letters and digits added to a postal address to aid in the sorting of mail.
BusinessAddressState	String	A nation or territory considered as an organized political community under one government.
BusinessExtension	String	The contact's business phone number extension.
BusinessPhone	String	The contact's business phone number.
Company	String	The organization that this contact is associated with.
ContactType	String	The type of contact: Contact, Secondary, or User.
Department	String	An area of special expertise or responsibility.
Edited	Datetime	Edited date of the contact.
EditedBy	String	User who edited the contact.
EmailAddress	String	A unique electronic address that an individual can be contacted.
FaxExtension	String	The contact's fax phone number extension.
FaxPhone	String	The contact's fax phone number.
FirstName	String	A personal given name.
HomeAddressCity	String	An inhabited place of greater size, population, or importance than a town or village.
HomeAddressCountry	String	A nation with its own government, occupying a particular territory.
HomeAddressLine1	String	Primary street address
HomeAddressLine2	String	Secondary street address
HomeAddressLine3	String	Miscellaneous street address
HomeAddressPostalCode	String	A code of letters and digits added to a postal address to aid in the sorting of mail.
HomeAddressState	String	A nation or territory considered as an organized political community under one government.
HomeExtension	String	The contact's home phone extension.
HomePhone	String	The contact's home phone number.
IdStatus	String	The relative social or professional position of an individual within a group or organization.
IsUser	Bool	An indicator if this contact is also a user within the system.
JobTitle	String	The title or position this contact holds.
LastName	String	The family name or surname.
LastResults	String	Identifies last communication or action with a contact.
Latitude	Decimal	The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.
Longitude	Decimal	The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.
MessengerID	String	An online identifier alias.
MiddleName	String	A name between one's first name and surname.
MobileExtension	String	The contact's mobile phone extension.
MobilePhone	String	The contact's mobile phone number.
NamePrefix	String	A patronymic prefix.
NameSuffix	String	Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.
PagerExtension	String	The contact's pager phone number extension
PagerPhone	String	The contact's pager phone number.
PersonalEmailAddress	String	A unique electronic address that an individual can be contacted.
RecordOwner	String	Owner user of the record.
ReferredBy	String	Indiciates how this contact came about.
Salutation	String	A gesture or utterance made as a greeting or acknowledgment.
Website	String	The contact's web site.