Fetches the activity log events associated with a specific board, detailing recent updates and actions.

View-Specific Information

SELECT

The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.

• BoardId supports the '=','IN' comparison operators.
• UserId supports the '=','IN' comparison operators.
• CreatedAt supports the '<','<=','>','>=' comparison operators.
• ColumnId supports the '=','IN' comparison operators.
• GroupId supports the '=','IN' comparison operators.
• ItemId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM ActivityLogs WHERE BoardId IN ('2307103055', '2182296646')
SELECT * FROM ActivityLogs WHERE UserId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ColumnId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE GroupId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ItemId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE CreatedAt > '2022-02-17 05:12:04.419' AND CreatedAt < '2022-02-17 05:12:04.861'
SELECT * FROM ActivityLogs WHERE CreatedAt >= '2022-02-17 05:12:04.419' AND CreatedAt <= '2022-02-17 05:12:04.861'

Columns

Name	Type	References	Description
Id [KEY]	String		The unique identifier of the activity log event, used to track and retrieve specific log entries.
BoardId	String	Boards.id	The unique identifier of the board associated with the activity, providing context for the event.
AccountId	String		The unique identifier of the account that initiated the activity, useful for auditing and tracking purposes.
UserId	String	Users.Id	The unique identifier of the user who triggered the activity, enabling user-specific analysis and reporting.
CreatedAt	Datetime		The timestamp indicating when the activity event occurred, formatted in datetime.
Data	String		A serialized string representation of the item's column values at the time of the event.
Entity	String		Specifies the entity affected by the event, such as a 'pulse' (task) or 'board' (project).
Event	String		Describes the specific action that occurred, such as an Update, Delete, or Create operation.
ColumnId	String		The unique identifier of the column affected by the activity, used for filtering and analysis.
GroupId	String	Groups.Id	The unique identifier of the group within the board affected by the activity, used for context or filtering.
ItemId	String		The unique identifier of the item (task or object) within the board affected by the activity, used for detailed tracking and filtering.