Excel Add-In for Zoho CRM

Build 24.0.9062

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.

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

Twitter 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
DuplicateCheckFields String

The field/s to be used for checking in an upsert.

CustomViewId Long

The custom view Id to be used for filtering this record. Will work when useCOQL=false.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062