Contacts

Stores individual contact records, such as names, job titles, phone numbers, and email addresses, with full support for creating, updating, deleting, and querying contact data.

Table-Specific Information

Select

This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.

Note: When ReadAPI is set to REST, a SELECT * query may fail due to the large number of columns in this table. To avoid this error:

Specify fewer than 50 columns in the SELECT clause
Or set the ReadAPI connection property to COQL to enable COQL
Or set the ReadAPI connection property to BULK tO use the BULK API

Insert

You must specify the LastName column when inserting a new contact. The following example demonstrates an insert operation:

-- Insert a contact with a first name, last name, and email address
INSERT INTO Contacts (FirstName, LastName, Email) VALUES ('John', 'Smith', '[email protected]')

Required fields: LastName is required.

Any field which is not read-only (ReadOnly = false in the table schema) can be inserted.

Delete

You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:

-- Delete a contact by its unique ID
DELETE FROM Contacts WHERE Id = '3152079000000153079'

Update

You must specify the Id column in the WHERE clause to update a record. The following example demonstrates an update operation:

-- Update the description field for a specific contact
UPDATE Contacts SET Description = 'John helped us in the past with setting up the servers.' WHERE Id = '3152079000000484021'

Required fields: Id is required. The update must target a specific record.

Any field which is not read-only (ReadOnly = false in the table schema) can be updated.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier for the contact.
Mailing_Latitude	Double	False	Latitude coordinate of the contact's primary mailing address.
Mailing_Longitude	Double	False	Longitude coordinate of the contact's primary mailing address.
Other_Latitude	Double	False	Latitude coordinate of the contact's secondary/other address.
Other_Longitude	Double	False	Longitude coordinate of the contact's secondary/other address.
Owner_Id	String	False	Unique identifier of the contact owner.
Owner_FirstName	String	True	First name of the contact owner.
Owner_LastName	String	True	Last name of the contact owner.
Owner_Email	String	True	Email address of the contact owner.
Lead_Source	String	False	Source from which the contact was generated.
First_Name	String	False	First name of the contact.
Last_Name	String	False	Last name of the contact.
Full_Name	String	False	Full name of the contact.
Account_Name_Id	String	False	Unique identifier of the associated account.
Vendor_Name_Id	String	False	Unique identifier of the associated vendor.
Email	String	False	Email address of the contact.
Title	String	False	Job title of the contact.
Department	String	False	Department the contact belongs to.
Phone	String	False	Primary phone number of the contact.
Home_Phone	String	False	Home phone number of the contact.
Other_Phone	String	False	Additional phone number for the contact.
Fax	String	False	Fax number of the contact.
Mobile	String	False	Mobile phone number of the contact.
Date_of_Birth	Date	False	Date of birth of the contact.
Assistant	String	False	Name of the contact's assistant.
Asst_Phone	String	False	Phone number of the assistant.
Email_Opt_Out	Bool	False	Indicates whether the contact has opted out of email communications.
Skype_ID	String	False	Skype identifier of the contact.
Created_By_Id	String	False	Unique identifier of the user who created the record.
Modified_By_Id	String	False	Unique identifier of the user who last modified the record.
Modified_By_FirstName	String	True	First name of the user who last modified the record.
Modified_By_LastName	String	True	Last name of the user who last modified the record.
Modified_By_Email	String	True	Email address of the user who last modified the record.
Created_Time	Datetime	False	Date and time when the contact was created.
Modified_Time	Datetime	False	Date and time when the contact was last modified.
Salutation	String	False	Salutation used for the contact.
Secondary_Email	String	False	Secondary email address of the contact.
Last_Activity_Time	Datetime	True	Date and time of the last activity related to the contact.
Twitter	String	False	Twitter handle of the contact.
Tag	String	False	Tag associated with the contact.
Description	String	False	Additional information or notes about the contact.
Record_Image	String	False	Image associated with the contact.
Reporting_To_Id	String	False	Unique identifier of the contact's manager or reporting person.
Unsubscribed_Mode	String	True	Method by which the contact unsubscribed from communications.
Unsubscribed_Time	Datetime	True	Date and time when the contact unsubscribed.
Id_CustomModule	Long	True	Record identifier used internally.
Change_Log_Time__s	Datetime	True	Timestamp of the last change to the record.
Locked__s	Bool	True	Indicates whether the record is locked from changes.
Last_Enriched_Time__s	Datetime	True	Date and time when the contact record was last enriched.
Enrich_Status__s	String	True	Current enrichment status of the contact.
Record_Status__s	String	False	Internal system status representing the current lifecycle/state of the contact record.
Mailing_City	String	False	Mailing city of the contact.
Mailing_Country	String	False	Mailing country of the contact.
Mailing_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the mailing address.
Mailing_State	String	False	Mailing state of the contact.
Mailing_Street	String	False	Mailing street address of the contact.
Mailing_Zip	String	False	Mailing ZIP or postal code of the contact.
Other_City	String	False	Other city of the contact.
Other_Country	String	False	Other country of the contact.
Other_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the other address.
Other_State	String	False	Other state of the contact.
Other_Street	String	False	Other street address of the contact.
Other_Zip	String	False	Other ZIP or postal code of the contact.

Pseudo-Columns

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


Name	Type	Description
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.

ADO.NET Provider for Zoho CRM