Updates

Fetches a collection of updates, including user comments, status changes, and other activity logs.

Table-Specific Information

SELECT

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

Id supports the '=','IN' comparison operators.
ItemId supports the '=','IN' comparison operators.
BoardId supports the '=','IN' comparison operators.
BoardUpdatesOnly supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM Updates WHERE Id = '173981152'
  SELECT * FROM Updates WHERE Id IN ('173981152','173981153')
  SELECT * FROM Updates WHERE ItemId = '1388002886'
  SELECT * FROM Updates WHERE ItemId IN ('1388002886','123923141')
  SELECT * FROM Updates WHERE BoardId = '1388002765'
  SELECT * FROM Updates WHERE BoardUpdatesOnly = true

INSERT

The following columns can be used to create a new record:

Body, CreatedAt, ItemId

The following pseudo-columns can be used to create a new record:

ParentId, MentionsList (references UpdateMention), UseAppInfo

UpdateMention Temporary Table Columns


Column Name	Type	Description
Id	115tring	The unique identifier of the board, project, team, or user to mention.
Type	115tring	The type of entity to mention.

DELETE

You can delete entries by specifying the following column:

DELETE FROM Updates WHERE Id = '2553512994'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the update, ensuring each update can be individually referenced and tracked in the database.
Body	String	True		The HTML-formatted content of the update, which may include various HTML tags for styling and media embedding.
CreatedAt	Datetime	True		The timestamp when the update was first created, providing the exact date and time of its creation.
CreatorId	String	True	Users.Id	The unique identifier of the user who created the update, enabling tracking of authorship and accountability.
ItemId	String	True		The unique identifier for the item associated with the update, linking it to the corresponding item in the database.
PinnedToTopItemIds	String	True		A comma-separated list of item IDs where the update is pinned, ensuring visibility by keeping it at the top of the list.
TextBody	String	True		The plain-text content of the update, providing the core message without any HTML formatting.
UpdatedAt	Datetime	True		The timestamp when the update was last modified, tracking any subsequent changes after the original creation.
EditedAt	Datetime	True		The date the update's body was last edited.
AssetsIds	String	True	Assets.Id	A comma-separated list of unique identifiers for the files or assets attached to the update, such as images or documents.
Replies	String	True		A list of replies associated with the update, typically stored as a comma-separated list of reply IDs or user responses.
Reactions	String	True		A data field that tracks user reactions to the update, which can include likes, emojis, or other forms of engagement.
BoardId	String	True		The unique identifier for the board to which the update belongs, allowing for filtering updates by specific boards or categories.

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
ParentId	String	The unique identifier of the parent update, used for creating threaded discussions or replies related to the original update.
MentionsList	String	The user, team, or board to mention in an update.
BoardUpdatesOnly	Bool	Whether to only include board-level updates.
UseAppInfo	Bool	Whether to use the app's details as the creator of the update.

SSIS Components for Monday