SSIS Components for Zoho CRM

Build 25.0.9434

ActionsPerformed

Provides a detailed audit trail of user and system actions on CRM records for compliance and troubleshooting.

Table-Specific Information

Select

The component 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 component.

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.
ActionType String Specifies the type of action performed, such as view, click, or reply.
Actions String Details of the specific actions taken during the interaction.
TimeSpent String Duration of time spent performing the action.
ActionPerformedTime Datetime Date and time when the action was executed.
ParentID_Id String Identifier of the parent object where the action was logged.
ParentID_Name String Name of the parent object where the action was logged.
ChatAttachment_Id String Identifier of the chat attachment related to the action.
ChatAttachment_Name String Name of the chat attachment related 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 Fields used to detect duplicates during an upsert operation.
CustomViewId Long Custom view identifier used to filter this record when the useCOQL parameter is set to false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434