Updates

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

Table-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.

Id supports the '=','IN' comparison operators.
BoardId supports the '=' comparison operator.
ItemId 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 BoardId = '1388002765'

INSERT

The following inputs can be used in INSERT statements:

Body, ItemId, ParentId

INSERT INTO Updates (ItemId,Body,ParentId) VALUES ('5525287847','This is a new reply.','2553498004')

DELETE

You can delete entries by specifying the Id.

DELETE FROM Updates WHERE Id = '2553512994'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the update, ensuring each update can be individually referenced and tracked in the database.
Body	String	False		The HTML-formatted content of the update, which may include various HTML tags for styling and media embedding.
CreatedAt	Datetime	False		The timestamp when the update was first created, providing the exact date and time of its creation.
CreatorId	String	False	Users.Id	The unique identifier of the user who created the update, enabling tracking of authorship and accountability.
ItemId	String	False		The unique identifier for the item associated with the update, linking it to the corresponding item in the database.
PinnedToTopItemIds	String	False		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	False		The plain-text content of the update, providing the core message without any HTML formatting.
UpdatedAt	Datetime	False		The timestamp when the update was last modified, tracking any subsequent changes after the original creation.
AssetsIds	String	False	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	False		A list of replies associated with the update, typically stored as a comma-separated list of reply IDs or user responses.
Reactions	String	False		A data field that tracks user reactions to the update, which can include likes, emojis, or other forms of engagement.
BoardId	String	False		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.