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	True	Id
ContactOwner_Id	String	False	ContactOwner Id
ContactOwner_FirstName	String	True	ContactOwner FirstName
ContactOwner_LastName	String	True	ContactOwner LastName
ContactOwner_Email	String	True	ContactOwner Email
ContactOwner_Name	String	True	ContactOwner Name
LeadSource	String	False	LeadSource
FirstName	String	False	FirstName
LastName	String	False	LastName
FullName	String	False	FullName
AccountName_Id	String	False	AccountName Id
AccountName_Name	String	True	AccountName Name
VendorName_Id	String	False	VendorName Id
VendorName_Name	String	True	VendorName Name
Email	String	False	Email
Title	String	False	Title
Department	String	False	Department
Phone	String	False	Phone
HomePhone	String	False	HomePhone
OtherPhone	String	False	OtherPhone
Fax	String	False	Fax
Mobile	String	False	Mobile
DateofBirth	Date	False	DateofBirth
Assistant	String	False	Assistant
AsstPhone	String	False	AsstPhone
EmailOptOut	Bool	False	EmailOptOut
SkypeID	String	False	SkypeID
CreatedBy_Id	String	False	CreatedBy Id
CreatedBy_FirstName	String	True	CreatedBy FirstName
CreatedBy_LastName	String	True	CreatedBy LastName
CreatedBy_Email	String	True	CreatedBy Email
CreatedBy_Name	String	True	CreatedBy Name
ModifiedBy_Id	String	False	ModifiedBy Id
ModifiedBy_FirstName	String	True	ModifiedBy FirstName
ModifiedBy_LastName	String	True	ModifiedBy LastName
ModifiedBy_Email	String	True	ModifiedBy Email
ModifiedBy_Name	String	True	ModifiedBy Name
CreatedTime	Datetime	False	CreatedTime
ModifiedTime	Datetime	False	ModifiedTime
Salutation	String	False	Salutation
SecondaryEmail	String	False	SecondaryEmail
LastActivityTime	Datetime	True	LastActivityTime
Twitter	String	False	Twitter
Tag	String	False	Tag
MailingStreet	String	False	MailingStreet
OtherStreet	String	False	OtherStreet
MailingCity	String	False	MailingCity
OtherCity	String	False	OtherCity
MailingState	String	False	MailingState
OtherState	String	False	OtherState
MailingZip	String	False	MailingZip
OtherZip	String	False	OtherZip
MailingCountry	String	False	MailingCountry
OtherCountry	String	False	OtherCountry
Description	String	False	Description
ContactImage	String	False	ContactImage
ReportingTo_Id	String	False	ReportingTo Id
ReportingTo_Name	String	True	ReportingTo Name
UnsubscribedMode	String	True	UnsubscribedMode
UnsubscribedTime	Datetime	True	UnsubscribedTime
RecordId	Long	True	RecordId
ChangeLogTime	Datetime	True	ChangeLogTime
Locked	Bool	True	Locked
LastEnrichedTime	Datetime	True	LastEnrichedTime
EnrichStatus	String	True	EnrichStatus

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	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.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.

MCP Server for Zoho CRM