JDBC Driver for SuiteCRM

Build 22.0.8462

Contacts

Create, update, delete, and query the contacts in SuiteCRM

Table Specific Information

Select

You can query the Contacts table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Contacts WHERE Title like 'PhD' 

Insert

Create a Contact by specifying any writable column.

INSERT INTO Contacts ([First name],[Last name]) VALUES ('Heisen','Schulz')

Update

You can update any Contact column that is writable, by specifying the Id.

UPDATE Contacts SET Home = '004284294' WHERE Id = 'Test123' 

Delete

Delete a Contact by specifying the Id.

DELETE FROM Contacts WHERE Id = 10003

Columns

Name Type ReadOnly Description
ID [KEY] String False

The unique identifier for the record.

AcceptStatus String True

Id of the event status

AcceptStatusC String True

The call accept status fields.

AcceptStatusId String True

The Id of the accept status.

AcceptStatusM String True

The meeting accept status fields.

AcceptStatusName String True

The name of the accept status.

AccountDisabled Bool False

Whether the portal account has been disabled for the contact.

AccountID String True

The Id of the account associated with the contact.

AccountName String True

The name of the account associated with the contact.

Address String True

Address from Google Maps of the contact.

AlternateAddressCity String False

The city for the alternate address.

AlternateAddressCountry String False

The country for the alternate address.

AlternateAddressPostal_Code String False

The postal code for the alternate address.

AlternateAddressState String False

The state for the alternate address.

AlternateAddressStreet String False

The street address for the alternate address.

AlternateAddressStreet2 String True

The second line of the alternate address.

AlternateAddressStreet3 String True

The third line of the alternate address.

AnyEmail String True

The email for the contact.

Assignedto String True

The name of the user assigned to the record.

AssignedUser String False

The user Id assigned to the record.

Assistant String False

The name of the assistant of the contact.

AssistantPhone String False

The phone number of the assistant of the contact.

Birthdate Date False

The birthdate of the contact.

Campaign String False

The first campaign name for Contact.

CampaignID String False

The campaign that generated the lead.

CreatedById String False

The Id of the user who created the record.

CreatedByName String False

The name of the user who created the record.

DateCreated Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

Deleted Bool False

Record deletion indicator.

Department String False

The department of the contact.

Description String False

The full text of the note.

DoNotCall Bool False

An indicator of whether the contact can be called.

Email String True

The email and name of the contact.

EmailAddress String False

The alternate email for the contact.

EmailOptOut Bool True

Whether the contact has opted out of emails.

Fax String False

The contact fax number.

FirstName String False

The first name of the contact.

Fullname String True

The full name of hte contact.

GeocodeStatus String True

Geocode from Google Maps of the contact.

Home String False

Home phone number of the contact.

InvalidEmail Bool True

Whether the contact email has been marked as invalid.

JoomlaAccountID String False

Id of the contact's Joomla account.

LastName String False

The last name of the contact.

Latitude Double True

Latitude from Google Maps of the contact.

LBL_CONT_ACCEPT_STATUS String True

The event accept status fields.

LBL_CONT_INVITE_STATUS String True

The event invite status fields.

LBL_JOOMLA_ACCOUNT_ACCESS String True

Access point for the contact's Joomla account.

LBL_LIST_ACCEPT_STATUS_EVENT String True

Accept status for the event

LBL_LIST_INVITE_STATUS String True

Id for the event invite

LBL_LIST_INVITE_STATUS_EVENT String True

Invite status of the event

LeadSource String False

The lead source for the contact.

Longitude Double True

Longitude from Google Maps of the contact.

Mobile String False

Mobile phone number of the contact.

ModifiedById String False

The Id of the user who last modified the record.

ModifiedByName String True

The user name of the user who last modified the record.

Name String True

The name of the contact.

NonPrimaryEmails String True

The nonprimary email addresses for the contact.

OfficePhone String False

Work phone number of the contact.

OpportunityRole String True

The opportunity role.

OpportunityRoleFields String True

The opportunity role fields.

OpportunityRoleID String True

The Id of the opportunity role.

OtherEmail String True

The alternate email for the contact.

OtherPhone String False

Other phone number for the contact.

Photo String False

The avatar for the contact.

PortalUserType String False

Type of the contact's portal account.

PrimaryAddressCity String False

The city for the primary address.

PrimaryAddressCountry String False

The country for primary address.

PrimaryAddressPostalCode String False

The postal code for the primary address.

PrimaryAddressState String False

The state for the primary address.

PrimaryAddressStreet String False

The street address for the alternate address.

PrimaryAddressStreet2 String True

The second line of the alternate address.

PrimaryAddressStreet3 String True

The third line of the alternate address.

ReportsTo String True

The name of the contact this contact reports to.

ReportstoID String False

The Id of the contact this contact reports to.

Salutation String False

The contact salutation (e.g., Mr. or Ms.).

SynctoOutlook_reg_ Bool True

Whether the lead is synced to Outlook.

Title String False

The title of the contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Rows@Next String

Identifier for the next page of results. Do not set this value manually.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462