SSIS Components for Zoho CRM

Build 25.0.9434

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 COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.

Note: When UseCOQL is set to true, 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 UseCOQL connection property to false to disable COQL and use the REST or 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.

ContactOwner_Id String False

Unique identifier of the contact owner.

ContactOwner_FirstName String True

First name of the contact owner.

ContactOwner_LastName String True

Last name of the contact owner.

ContactOwner_Email String True

Email address of the contact owner.

ContactOwner_Name String True

Full name of the contact owner.

LeadSource String False

Source from which the contact was generated.

FirstName String False

First name of the contact.

LastName String False

Last name of the contact.

FullName String False

Full name of the contact.

AccountName_Id String False

Unique identifier of the associated account.

AccountName_Name String True

Name of the associated account.

VendorName_Id String False

Unique identifier of the associated vendor.

VendorName_Name String True

Name 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.

HomePhone String False

Home phone number of the contact.

OtherPhone 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.

DateofBirth Date False

Date of birth of the contact.

Assistant String False

Name of the contact's assistant.

AsstPhone String False

Phone number of the assistant.

EmailOptOut Bool False

Indicates whether the contact has opted out of email communications.

SkypeID String False

Skype identifier of the contact.

CreatedBy_Id String False

Unique identifier of the user who created the record.

CreatedBy_FirstName String True

First name of the user who created the record.

CreatedBy_LastName String True

Last name of the user who created the record.

CreatedBy_Email String True

Email address of the user who created the record.

CreatedBy_Name String True

Full name of the user who created the record.

ModifiedBy_Id String False

Unique identifier of the user who last modified the record.

ModifiedBy_FirstName String True

First name of the user who last modified the record.

ModifiedBy_LastName String True

Last name of the user who last modified the record.

ModifiedBy_Email String True

Email address of the user who last modified the record.

ModifiedBy_Name String True

Full name of the user who last modified the record.

CreatedTime Datetime False

Date and time when the contact was created.

ModifiedTime Datetime False

Date and time when the contact was last modified.

Salutation String False

Salutation used for the contact.

SecondaryEmail String False

Secondary email address of the contact.

LastActivityTime 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.

MailingStreet String False

Mailing street address of the contact.

OtherStreet String False

Other street address of the contact.

MailingCity String False

Mailing city of the contact.

OtherCity String False

Other city of the contact.

MailingState String False

Mailing state of the contact.

OtherState String False

Other state of the contact.

MailingZip String False

Mailing ZIP or postal code of the contact.

OtherZip String False

Other ZIP or postal code of the contact.

MailingCountry String False

Mailing country of the contact.

OtherCountry String False

Other country of the contact.

Description String False

Additional information or notes about the contact.

ContactImage String False

Image associated with the contact.

ReportingTo_Id String False

Unique identifier of the contact's manager or reporting person.

ReportingTo_Name String True

Name of the contact's manager or reporting person.

UnsubscribedMode String True

Method by which the contact unsubscribed from communications.

UnsubscribedTime Datetime True

Date and time when the contact unsubscribed.

RecordId Long True

Record identifier used internally.

ChangeLogTime Datetime True

Timestamp of the last change to the record.

Locked Bool True

Indicates whether the record is locked from changes.

LastEnrichedTime Datetime True

Date and time when the contact record was last enriched.

EnrichStatus String True

Current enrichment status 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
DuplicateCheckFields String

Fields used to check for duplicates during upsert. Only one field is allowed when using the BULK API.

Trigger String

Specifies whether to trigger workflows when inserting the record into the CRM account.

CustomViewId Long

Custom view identifier to filter this record. Works only when the useCOQL parameter is false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434