Contacts
Create, update, delete, and query information regarding contacts.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
INSERT INTO Contacts (FirstName, LastName, Email) VALUES ('John', 'Smith', '[email protected]')
Required fields: LastName.
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM Contacts WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Contacts SET Description = 'John helped us in the past with setting up the servers.' WHERE Id = '3152079000000484021'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier for this record. |
ContactOwner_Id | String | False |
The Id of the owner of the contact. |
ContactOwner_FirstName | String | False |
The First Name of the owner of the contact. |
ContactOwner_LastName | String | False |
The Last Name of the owner of the contact. |
LeadSource | String | False |
The source of the lead. |
FirstName | String | False |
The first name of the contact. |
LastName | String | False |
The last name of the contact. |
AccountName_Id | String | False |
The id of the account concerning this contact. |
VendorName_Id | String | False |
The Id of the vendor concerning this account. |
String | False |
The email of the contact. | |
Title | String | False |
The title of the contact. |
Department | String | False |
The Department of the contact. |
Phone | String | False |
The phone of the contact. |
HomePhone | String | False |
The home phone of the contact. |
OtherPhone | String | False |
A different phone number of the contact. |
Fax | String | False |
The fax of the contact. |
Mobile | String | False |
The mobile of the contact. |
DateofBirth | Date | False |
The date of birth of the contact. |
Tag | String | False |
A list of tags of the contact. |
Assistant | String | False |
The assistant of the contact. |
AsstPhone | String | False |
The phone number of the assistant of the contact. |
ReportsTo | String | False |
To whom the contact reports to. |
EmailOptOut | Bool | False |
Whether this contact has opted out from receiving emails. |
CreatedBy_Id | String | False |
The Id of the User who created the record. |
SkypeID | String | False |
The Skype ID of the contact. |
ModifiedBy_Id | String | False |
The Id of the User who modified the record. |
ModifiedBy_FirstName | String | False |
The First Name of the User who modified the record. |
ModifiedBy_LastName | String | False |
The Last Name of the User who modified the record. |
CreatedTime | Datetime | False |
The time when the record was created. |
ModifiedTime | Datetime | False |
The time when the record was modified. |
FullName | String | False |
The full name of the contact. |
Salutation | String | False |
The salutation the contact likes to be referenced as. |
SecondaryEmail | String | False |
The secondary email of the contact. |
LastActivityTime | Datetime | False |
The time of the contact's last activity. |
String | False |
The twitter handle of the contact. | |
MailingStreet | String | False |
The mailing street of the contact. |
OtherStreet | String | False |
The other street of the contact. |
MailingCity | String | False |
The mailing city of the contact. |
OtherCity | String | False |
The other city of the contact. |
MailingState | String | False |
The mailing state of the contact. |
OtherState | String | False |
The other state of the contact. |
MailingZip | String | False |
The mailing zip of the contact. |
OtherZip | String | False |
The other zip of the contact. |
MailingCountry | String | False |
The mailing country of the contact. |
OtherCountry | String | False |
The other country of the contact. |
Description | String | False |
The description of the contact. |
MostRecentVisit | Datetime | False |
The most recent visit of the contact. |
FirstVisit | Datetime | False |
The first visit of the contact. |
Referrer | String | False |
The referrer of the contact. |
FirstPageVisited | String | False |
The first page the contact has visited. |
NumberOfChats | Int | False |
The number of chats the contact has had. |
AverageTimeSpent_Minutes_ | String | False |
The average time in minutes the contact has spent. |
DaysVisited | Int | False |
The number of days the contact has visited. |
VisitorScore | Long | False |
The visitor score 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 |
Word | String |
Used to search for a specific word in records. |
DuplicateCheckFields | String |
The field/s to be used for checking in an upsert. |
Converted | Boolean |
Set to true to return only converted records. |
Approved | Boolean |
Set to true to return only approved records. |
CustomViewId | String |
The custom view Id to be used for filtering this record. |