JDBC Driver for Act! CRM

Build 21.0.8137

Contacts

Create, update, delete and query the Contacts in your Act! CRM database.

Table Specific Information

  • Id supports the '=' operator.
  • Created supports the '<=,<,=,!=,>,>=' operator.
  • FullName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Company 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.
  • 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.

Select

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 queries are processed server side:

SELECT * FROM Contacts WHERE Id = '12345'
 
SELECT * FROM Contacts WHERE FullName = 'Full contact name' 

Insert

To insert a contact, you need to specify the contact name.

INSERT INTO Contacts(FirstName) VALUES('Contact First Name')

Update

Any column where ReadOnly=False can be updated. Specify the Contact Id when updating a group

UPDATE Contacts SET Company = 'User Company' Website = 'UserWebsite.com' WHERE Id = '12345'

Delete

Contacts can be deleted by providing an Id and issuing a DELETE statement.

DELETE FROM Contacts WHERE Id = '12345'
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 ReadOnly Description
Id [KEY] String True

The unique identifier (id) for this contact.

Created Datetime True

Created date of the contact.

FullName String True

The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!

Company String False

The organization that this contact is associated with.

AltEmailAddress String False

A unique electronic address that an individual can be contacted.

AlternateExtension String False

The contact's alternate phone number extension.

AlternatePhone String False

The contact's alternate phone number.

Birthday String False

The anniversary of the day on which a person was born.

BusinessAddressCity String False

An inhabited place of greater size, population, or importance than a town or village.

BusinessAddressCountry String False

A nation with its own government, occupying a particular territory.

BusinessAddressLine1 String False

Primary street address

BusinessAddressLine2 String False

Secondary street address

BusinessAddressLine3 String False

Miscellaneous street address

BusinessAddressPostalCode String False

A code of letters and digits added to a postal address to aid in the sorting of mail.

BusinessAddressState String False

A nation or territory considered as an organized political community under one government.

BusinessExtension String False

The contact's business phone number extension.

BusinessPhone String False

The contact's business phone number.

CompanyID String False

The unique identifier (companyID) for a given companies.

ContactType String True

The type of contact: Contact, Secondary, or User.

Department String False

An area of special expertise or responsibility.

Edited Datetime True

Edited date of the contact.

EditedBy String True

User who edited the contact.

EmailAddress String False

A unique electronic address that an individual can be contacted.

FaxExtension String False

The contact's fax phone number extension.

FaxPhone String False

The contact's fax phone number.

FirstName String False

A personal given name.

HomeAddressCity String False

An inhabited place of greater size, population, or importance than a town or village.

HomeAddressCountry String False

A nation with its own government, occupying a particular territory.

HomeAddressLine1 String False

Primary street address

HomeAddressLine2 String False

Secondary street address

HomeAddressLine3 String False

Miscellaneous street address

HomeAddressPostalCode String False

A code of letters and digits added to a postal address to aid in the sorting of mail.

HomeAddressState String False

A nation or territory considered as an organized political community under one government.

HomeExtension String False

The contact's home phone extension.

HomePhone String False

The contact's home phone number.

IdStatus String False

The relative social or professional position of an individual within a group or organization.

IsUser Bool True

An indicator if this contact is also a user within the system.

JobTitle String False

The title or position this contact holds.

LastName String False

The family name or surname.

LastResults String False

Identifies last communication or action with a contact.

Latitude Decimal False

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 False

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 True

An online identifier alias.

MiddleName String False

A name between one's first name and surname.

MobileExtension String False

The contact's mobile phone extension.

MobilePhone String False

The contact's mobile phone number.

NamePrefix String False

A patronymic prefix.

NameSuffix String False

Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.

PagerExtension String False

The contact's pager phone number extension

PagerPhone String False

The contact's pager phone number.

PersonalEmailAddress String False

A unique electronic address that an individual can be contacted.

RecordOwner String True

Owner user of the contact.

ReferredBy String False

Indiciates how this contact came about.

Salutation String True

A gesture or utterance made as a greeting or acknowledgment.

Website String False

The contact's web site.

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