ADO.NET Provider for Zoho CRM

Build 26.0.9655

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 COQL, 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 REST or BULK to use the REST or BULK API instead

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.

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_Street String False

Mailing street address of the contact.

Mailing_City String False

Mailing city of the contact.

Mailing_State String False

Mailing state of the contact.

Mailing_Zip String False

Mailing ZIP or postal code 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_Street String False

Other street address of the contact.

Other_City String False

Other city of the contact.

Other_State String False

Other state of the contact.

Other_Zip String False

Other ZIP or postal code of the contact.

Last_Visited_Time Datetime True

Date and time when the contact most recently visited your website or tracked page.

First_Visited_URL String True

URL of the first webpage the contact visited during their initial tracked session.

Average_Time_Spent_Minutes Double True

Average duration in minutes the contact spends per visit on tracked pages.

Number_Of_Chats Int True

Total number of chat interactions initiated by or with the contact.

Referrer String True

Source or referring site/channel that directed the contact to your website.

Visitor_Score Long True

Engagement score assigned to the contact based on their tracked website activity.

First_Visited_Time Datetime True

Date and time when the contact first visited your website or tracked page.

Days_Visited Int True

Count of distinct days on which the contact visited tracked pages.

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.

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