Activities

Delete, and query information regarding activities.

Table-Specific Information

Select

The server uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the server.

DueDate supports the '=' operator.
ClosedTime supports the '=' operator.
Location supports the '=, LIKE' operators.
From supports the '=' operator.
To supports the '=' operator.
Check-InTime supports the '=' operator.
Check-InComment supports the '=, LIKE'.
Check-InSub-Locality supports the '=, LIKE' operators.
Check-InCity supports the '=, LIKE' operators.
Check-InState supports the '=, LIKE' operators.
Check-InCountry supports the '=, LIKE' operators.
ZipCode supports the '=, LIKE' operators.
Check-InAddress supports the '=, LIKE' operators.
CheckedInStatus supports the '=, LIKE' operators.
CallStartTime supports the '=' operator.
CallDuration supports the '=, LIKE' operators.
CallResult supports the '=, LIKE' operators.
Reminder supports the '=, LIKE' operators.
CallStatus supports the '=, LIKE' operators.
Subject supports the '=, LIKE' operators.
CreatedTime supports the '=' operator.
ModifiedTime supports the '=' operator.
ActivityType supports the '=, LIKE' operators.
Description supports the '=, LIKE' operators.

For example, the following queries are processed server side:

SELECT * FROM Activities WHERE Id = '3152079000000154214'

SELECT * FROM Activities WHERE Subject = 'event'

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Activities WHERE Id = '3152079000000156229'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id
ActivityOwner_Id	String	False	ActivityOwner Id
ActivityOwner_FirstName	String	True	ActivityOwner FirstName
ActivityOwner_LastName	String	True	ActivityOwner LastName
ActivityOwner_Email	String	True	ActivityOwner Email
ActivityOwner_Name	String	True	ActivityOwner Name
Subject	String	False	Subject
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
CreatedAt	Datetime	False	CreatedAt
ModifiedAt	Datetime	False	ModifiedAt
ActivityType	String	False	ActivityType
ContactName_Id	String	False	ContactName Id
ContactName_Name	String	True	ContactName Name
RelatedTo_Id	String	False	RelatedTo Id
RelatedTo_Name	String	True	RelatedTo Name
Description	String	False	Description
DueDate	Date	False	DueDate
Status	String	False	Status
Priority	String	False	Priority
ClosedTime	Datetime	True	ClosedTime
Repeat_Id	String	False	Repeat Id
Repeat_Name	String	True	Repeat Name
Tag	String	False	Tag
Locked	Bool	True	Locked
LastActivityTime	Datetime	False	LastActivityTime
Location	String	False	Location
Allday	Bool	False	Allday
From	Datetime	False	From
To	Datetime	False	To
Participants	String	False	Participants
Check-InTime	Datetime	True	Check-InTime
Check-InBy_Id	String	False	Check-InBy Id
Check-InBy_Name	String	True	Check-InBy Name
Check-InComment	String	True	Check-InComment
Check-InSub-Locality	String	True	Check-InSub-Locality
Check-InCity	String	True	Check-InCity
Check-InState	String	True	Check-InState
Check-InCountry	String	True	Check-InCountry
Latitude	Double	True	Latitude
Longitude	Double	True	Longitude
ZipCode	String	True	ZipCode
Check-InAddress	String	True	Check-InAddress
CheckedInStatus	String	True	CheckedInStatus
CallType	String	False	CallType
CallPurpose	String	False	CallPurpose
CallStartTime	Datetime	False	CallStartTime
CallDuration	String	False	CallDuration
CallDuration(inseconds)	Int	False	CallDuration(inseconds)
CallResult	String	False	CallResult
CTIEntry	Bool	False	CTIEntry
Reminder	String	False	Reminder
OutgoingCallStatus	String	False	OutgoingCallStatus
ScheduledinCRM	String	True	ScheduledinCRM
CallAgenda	String	False	CallAgenda
CallerID	String	True	CallerID
DialledNumber	String	True	DialledNumber
VoiceRecording	String	False	VoiceRecording

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.