Activities

Stores CRM activities such as tasks, calls, and events, with support for deletion and retrieval.

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 record.
ActivityOwner_Id	String	False	Unique identifier of the user who owns the activity.
ActivityOwner_FirstName	String	True	First name of the user who owns the activity.
ActivityOwner_LastName	String	True	Last name of the user who owns the activity.
ActivityOwner_Email	String	True	Email address of the user who owns the activity.
ActivityOwner_Name	String	True	Full name of the user who owns the activity.
Subject	String	False	Title or subject line of the activity.
CreatedBy_Id	String	False	Unique 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	Unique 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	Timestamp indicating when the activity was created.
ModifiedAt	Datetime	False	Timestamp indicating when the activity was last modified.
ActivityType	String	False	Type of activity, such as task, call, or meeting.
ContactName_Id	String	False	Unique identifier of the related contact.
ContactName_Name	String	True	Full name of the related contact.
RelatedTo_Id	String	False	Unique identifier of the related parent entity, such as a lead or account.
RelatedTo_Name	String	True	Name of the related parent entity.
Description	String	False	Detailed notes or description for the activity.
DueDate	Date	False	Scheduled due date for the activity.
Status	String	False	Current status of the activity, such as Completed or Deferred.
Priority	String	False	Priority level of the activity, such as High, Normal, or Low.
ClosedTime	Datetime	True	Timestamp indicating when the activity was marked as closed.
Repeat_Id	String	False	Unique identifier for the associated recurrence rule, if any.
Repeat_Name	String	True	Name or label of the recurrence rule applied to the activity.
Tag	String	False	Tags associated with the activity for classification or search.
Locked	Bool	True	Indicates whether the activity is locked for editing.
LastActivityTime	Datetime	False	Timestamp of the most recent update related to the activity.
Location	String	False	Physical or virtual location where the activity is scheduled to occur.
Allday	Bool	False	Indicates whether the activity spans the entire 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, separated by commas.
Check-InTime	Datetime	True	Timestamp when the check-in for the activity occurred.
Check-InBy_Id	String	False	Unique identifier of the user who performed the check-in.
Check-InBy_Name	String	True	Full name of the user who performed the check-in.
Check-InComment	String	True	Comment entered at the time of check-in.
Check-InSub-Locality	String	True	Sub-locality where the check-in occurred.
Check-InCity	String	True	City where the check-in occurred.
Check-InState	String	True	State or province where the check-in occurred.
Check-InCountry	String	True	Country where the check-in occurred.
Latitude	Double	True	Latitude of the check-in location.
Longitude	Double	True	Longitude of the check-in location.
ZipCode	String	True	Postal or ZIP code for the check-in location.
Check-InAddress	String	True	Full address where the check-in took place.
CheckedInStatus	String	True	Current check-in status for the activity.
CallType	String	False	Type of call, such as Incoming or Outgoing.
CallPurpose	String	False	Purpose of the call, such as Follow-up or Demo.
CallStartTime	Datetime	False	Timestamp when the call started.
CallDuration	String	False	Duration of the call in formatted text.
CallDuration(inseconds)	Int	False	Duration of the call measured in seconds.
CallResult	String	False	Outcome of the call, such as No answer or Completed.
CTIEntry	Bool	False	Indicates whether the call was logged via CTI integration.
Reminder	String	False	Reminder setting for the activity, such as 15 minutes before.
CallStatus	String	False	Current status of the call, such as Held or Scheduled.
CallAgenda	String	False	Agenda or notes describing the purpose of the call.
CallerID	String	True	Caller identifier information displayed during the call.
DialledNumber	String	True	Phone number that was dialed.
VoiceRecording	String	False	Link or reference to the call's voice recording, if available.

Pseudo-Columns

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