JDBC Driver for Act! CRM

Build 21.0.8137

CompanyContacts

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137