ActionsPerformed
Returns logs of actions performed on CRM records, including edits, deletions, and automation executions.
Table-Specific Information
Select
The provider 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 provider.
Note : ActionsPerformed cannot be queried until it is enabled from the UI.
SELECT * FROM ActionsPerformed
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier of the performed-action record. |
| ActionType | String | Category or type of the action performed, such as Note Added, Field Updated, or Call Logged. |
| Actions | String | Specific actions executed during the activity, represented as a comma-separated list with one space after each comma. |
| TimeSpent | String | Duration spent performing the action, typically recorded in minutes or descriptive time format. |
| ActionPerformedTime | Datetime | Timestamp indicating when the action occurred. |
| ParentID_Id | String | Unique Id of the parent CRM record (such as a deal, contact, or lead) to which the action is linked. |
| ParentID_Name | String | Display name of the parent record associated with the action. |
| ChatAttachment_Id | String | Unique Id of the chat attachment, if the action involved a conversation or file shared during a chat. |
| ChatAttachment_Name | String | Display name or filename of the chat attachment linked to the action. |
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 | Comma-separated field list used for duplicate detection during upsert operations. Insert one space after each comma. The REST API allows multiple fields while the BULK API supports only one. |
| CustomViewId | Long | Id of the custom view used to filter the record. This applies when the useCOQL parameter is set to false. |