ActionsPerformed
Provides a detailed audit trail of user and system actions on CRM records for compliance and troubleshooting.
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 for the performed action. |
| Action_Type | String | Specifies the type of action performed, such as view, click, or reply. |
| Actions | String | Details of the specific actions taken during the interaction. |
| Time_Spent | Double | Duration of time spent performing the action. |
| Action_Performed_Time | Datetime | Date and time when the action was executed. |
| Parent_Id_Id | String | Identifier of the parent object where the action was logged. |
| Chat_Attachment_Id | String | Identifier of the chat attachment related to the action. |
| Visited_Page | String | Name or URL of the webpage which was visited when the action was recorded. |
| Id_CustomModule | Long | System-generated identifier for record tracking. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data 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. |