ODBC Driver for Act! CRM

Build 26.0.9770

SecondaryContacts

Query, create, update and delete secondary contacts for a contact.

Table Specific Information

Select

  • ParentContactId supports the '=' operator.
  • Id supports the '=' operator.
  • Created supports the '<=,<,=,!=,>,>=' operator.
  • FullName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Birthday supports the '<=,<,=,!=,>,>=' operator.
  • Edited supports the '<=,<,=,!=,>,>=' operator.
  • FirstName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • IsUser supports the '=' operator.
  • LastName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • IsFavorite supports the '=' operator.
  • IsImported supports the '=' operator.
  • ImportDate supports the '<=,<,=,!=,>,>=' operator.
  • IsPrivate supports the '=' operator.
  • LastEmail supports the '<=,<,=,!=,>,>=' operator.
  • LastAttempt supports the '<=,<,=,!=,>,>=' operator.
  • LastReach supports the '<=,<,=,!=,>,>=' operator.
  • LastMeeting supports the '<=,<,=,!=,>,>=' operator.
  • LastLetterSent supports the '<=,<,=,!=,>,>=' operator.
  • AemOptOut supports the '=' operator.
  • AemBounceBack supports the '=' 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 queries are processed server side: 
SELECT * FROM SecondaryContacts WHERE ParentContactId = '12345'
SELECT * FROM SecondaryContacts WHERE ParentContactId = '12345' AND LastName = 'Smith'

Insert

To insert a secondary contact, you must specify the ParentContactId of the parent contact, along with the FirstName, LastName, JobTitle, and EmailAddress. 

INSERT INTO SecondaryContacts (ParentContactId, FirstName, LastName, JobTitle, EmailAddress) VALUES ('972df268-a4db-41db-bc32-4af89ab3034b', 'Jane1', 'Smith1', 'Assistant', '[email protected]')

Update

Any column where ReadOnly=False can be updated. Specify the ParentContactId and Id when updating a secondary contact. 

UPDATE SecondaryContacts SET AltEmailAddress = '[email protected]', BusinessAddressCity = 'Delhi' WHERE Id = 'f99d63eb-c9d1-42bf-b345-cf30183d9a80' AND ParentContactId = '972df268-a4db-41db-bc32-4af89ab3034b'

Delete

SecondaryContacts can be deleted by providing a ParentContactId and Id and issuing a DELETE statement. 

DELETE FROM SecondaryContacts WHERE ParentContactId = '972df268-a4db-41db-bc32-4af89ab3034b' AND Id = '187a795f-a7dc-4681-9e4c-41b86146bb07'

Columns

Name Type ReadOnly Description
ParentContactId [KEY] String False

The Id of the parent contact.

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 suffixes defined within Act!

Company String False

The organization that this contact is associated with.

AltEmailAddress String False

The contact's alternate email address.

AlternateExtension String False

The contact alternate phone number extension.

AlternatePhone String False

The contact alternate phone number.

Birthday Date False

The contact's date of birth.

BusinessAddressCity String False

The city of the contact's business address.

BusinessAddressCountry String False

The country of the contact's business address.

BusinessAddressLine1 String False

The first line of the contact's business street address.

BusinessAddressLine2 String False

The second line of the contact's business street address.

BusinessAddressLine3 String False

The third line of the contact's business street address.

BusinessAddressPostalCode String False

The postal code of the contact's business address.

BusinessAddressState String False

The state or province of the contact's business address.

BusinessExtension String False

The contact business phone number extension.

BusinessPhone String False

The contact business phone number.

CompanyID String False

The unique identifier (id) of the company associated with this contact.

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

The contact's primary email address.

FaxExtension String False

The contact fax phone number extension.

FaxPhone String False

The contact fax phone number.

FirstName String False

A personal given name.

HomeAddressCity String False

The city of the contact's home address.

HomeAddressCountry String False

The country of the contact's home address.

HomeAddressLine1 String False

The first line of the contact's home street address.

HomeAddressLine2 String False

The second line of the contact's home street address.

HomeAddressLine3 String False

The third line of the contact's home street address.

HomeAddressPostalCode String False

The postal code of the contact's home address.

HomeAddressState String False

The state or province of the contact's home address.

HomeExtension String False

The contact home phone extension.

HomePhone String False

The contact home phone number.

IdStatus String False

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

IsUser Boolean 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 equator.

Longitude Decimal False

The angular distance of a place east or west of the meridian at Greenwich, England.

MessengerID String True

The contact's instant messenger ID or username.

MiddleName String False

A name between one first name and surname.

MobileExtension String False

The contact mobile phone extension.

MobilePhone String False

The contact mobile phone number.

NamePrefix String False

A title or honorific placed before the contact's name (e.g. Mr., Dr.).

NameSuffix String False

Provides additional information about the person identifying an individual position, educational degree, accreditation, office, or honors.

PagerExtension String False

The contact pager phone number extension

PagerPhone String False

The contact pager phone number.

PersonalEmailAddress String False

The contact's personal email address.

RecordOwner String True

The user who owns the contact record.

ReferredBy String False

Indicates how this contact came about.

Salutation String True

The greeting or salutation used when addressing this contact (e.g. Dear Mr. Smith).

Website String False

The contact web site.

IsFavorite Boolean False

Indicates whether this contact is marked as a favorite.

IsImported Boolean False

Indicates whether this contact was imported into the system.

ImportDate Datetime False

The date that the contact was imported into the system.

IsPrivate Boolean False

Indicates elevated security that only the creator/owner has access to this contact.

LastEmail Datetime False

The date of the last email sent to or from this contact.

LastAttempt Datetime False

The date of the last contact attempt.

LastReach Datetime False

The date this contact was last reached.

LastMeeting Datetime False

The date of the last meeting with this contact.

LastLetterSent Datetime False

The date of the last letter sent to this contact.

AmaScore Integer False

The contact AMA score.

BusinessAddressLatitude Decimal False

Business address latitude.

BusinessAddressLongitude Decimal False

Business address longitude.

BusinessCountryCode Integer False

The contact business phone country code.

BusinessMaskFormat String False

The contact business phone mask format.

MobileCountryCode Integer False

The contact mobile phone country code.

MobileMaskFormat String False

The contact mobile phone mask format.

FaxCountryCode Integer False

The contact fax phone country code.

FaxMaskFormat String False

The contact fax phone mask format.

HomeAddressLatitude Decimal False

Home address latitude.

HomeAddressLongitude Decimal False

Home address longitude.

HomeCountryCode Integer False

The contact home phone country code.

HomeMaskFormat String False

The contact home phone mask format.

AlternateCountryCode Integer False

The contact alternate phone country code.

AlternateMaskFormat String False

The contact alternate phone mask format.

PagerCountryCode Integer False

The contact pager phone country code.

PagerMaskFormat String False

The contact pager phone mask format.

AemOptOut Boolean False

Indicates whether this contact has opted out of Act! email marketing (AEM).

AemBounceBack Boolean False

Indicates whether emails to this contact have bounced back in Act! email marketing (AEM).

RecordManagerId String False

The unique identifier (id) of the record manager for this contact.

QuickBooksId String False

Quickbooks external Id to match record with quickbooks contact.

CustomFields String False

Custom fields.

NylasContactId String False

Nylas contact Id to match record with a contact.

RecordManager String False

The name of the record manager for this contact.

Acl String True

The access control level of the record.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770