Activities

Stores activities such as tasks, calls, and events and lets you delete or query these records for scheduling and reporting.

Table-Specific Information

Select

The 本製品 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 本製品.

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	Unique identifier for the activity.
ActivityOwner_Id	String	False	Identifier of the user who owns the activity.
ActivityOwner_FirstName	String	True	First name of the activity owner.
ActivityOwner_LastName	String	True	Last name of the activity owner.
ActivityOwner_Email	String	True	Email address of the activity owner.
ActivityOwner_Name	String	True	Full name of the activity owner.
Subject	String	False	Title or subject line of the activity.
CreatedBy_Id	String	False	Identifier of the user who created the activity.
CreatedBy_FirstName	String	True	First name of the user who created the activity.
CreatedBy_LastName	String	True	Last name of the user who created the activity.
CreatedBy_Email	String	True	Email address of the user who created the activity.
CreatedBy_Name	String	True	Full name of the user who created the activity.
ModifiedBy_Id	String	False	Identifier of the user who last modified the activity.
ModifiedBy_FirstName	String	True	First name of the user who last modified the activity.
ModifiedBy_LastName	String	True	Last name of the user who last modified the activity.
ModifiedBy_Email	String	True	Email address of the user who last modified the activity.
ModifiedBy_Name	String	True	Full name of the user who last modified the activity.
CreatedAt	Datetime	False	Date and time when the activity was created.
ModifiedAt	Datetime	False	Date and time when the activity was last modified.
ActivityType	String	False	Type of activity, such as call or meeting.
ContactName_Id	String	False	Identifier of the contact associated with the activity.
ContactName_Name	String	True	Name of the contact associated with the activity.
RelatedTo_Id	String	False	Identifier of the related record for this activity.
RelatedTo_Name	String	True	Name of the related record for this activity.
Description	String	False	Detailed description of the activity.
DueDate	Date	False	Due date for the activity to be completed.
Status	String	False	Current status of the activity.
Priority	String	False	Priority level assigned to the activity.
ClosedTime	Datetime	True	Date and time when the activity was closed.
Repeat_Id	String	False	Identifier of the repeat rule linked to the activity.
Repeat_Name	String	True	Name of the repeat rule linked to the activity.
Tag	String	False	Tags associated with the activity for categorization.
Locked	Bool	True	Indicates whether the activity is locked from edits.
LastActivityTime	Datetime	False	Timestamp of the most recent activity update.
Location	String	False	Location where the activity is scheduled.
Allday	Bool	False	Indicates whether the activity lasts all day.
From	Datetime	False	Start time of the activity.
To	Datetime	False	End time of the activity.
Participants	String	False	List of participants involved in the activity.
Check-InTime	Datetime	True	Time when the user checked in to the activity.
Check-InBy_Id	String	False	Identifier of the user who performed the check-in.
Check-InBy_Name	String	True	Name of the user who performed the check-in.
Check-InComment	String	True	Comments added during the check-in.
Check-InSub-Locality	String	True	Sub-locality information for the check-in.
Check-InCity	String	True	City where the check-in occurred.
Check-InState	String	True	State where the check-in occurred.
Check-InCountry	String	True	Country where the check-in occurred.
Latitude	Double	True	Latitude coordinate of the check-in location.
Longitude	Double	True	Longitude coordinate of the check-in location.
ZipCode	String	True	Postal code of the check-in location.
Check-InAddress	String	True	Full address of the check-in location.
CheckedInStatus	String	True	Status of the check-in, such as completed or pending.
CallType	String	False	Type of call, such as outbound or inbound.
CallPurpose	String	False	Purpose of the call, such as follow-up or demo.
CallStartTime	Datetime	False	Start time of the call activity.
CallDuration	String	False	Duration of the call in human-readable format.
CallDuration(inseconds)	Int	False	Duration of the call in seconds.
CallResult	String	False	Outcome of the call, such as successful or missed.
CTIEntry	Bool	False	Indicates whether the call was logged using CTI integration.
Reminder	String	False	Reminder details for the activity.
OutgoingCallStatus	String	False	Status of the outgoing call.
ScheduledinCRM	String	True	Indicates whether the call was scheduled in the CRM.
CallAgenda	String	False	Agenda or topics to be discussed during the call.
CallerID	String	True	Caller ID information displayed during the call.
DialledNumber	String	True	Phone number that was dialed.
VoiceRecording	String	False	Link or reference to the voice recording of the call.

Pseudo-Columns

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