TimelineItems

Provides metadata about items displayed in the Email and Activities timeline.

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.

For example, the following query is processed server side:

SELECT * FROM TimelineItems WHERE Id ='2b748808-9311-4f76-80de-49baac5609e1'

INSERT

The following inputs can be used in INSERT statements:

Title, CustomActivityId, ItemId, Summary, Content, Location, Phone, Url, Timestamp, TimeRangeStartTimestamp, TimeRangeEndTimestamp

INSERT INTO TimelineItems(ItemId, CustomActivityId, Location, Title, Summary, Content, Timestamp, TimeRangeStartTimestamp, TimeRangeEndTimestamp, phone, url) VALUES ( '7832826517', '8baadd0b-5b64-4ecb-a035-1f5824507f98', 'X', 'Migrated Timeline', 'Works summary', 'Test', '2024-06-06T18:00:30Z', '2024-04-06T15:00:30Z', '2024-05-06T19:00:30Z', '1234-5678', 'https://www.test.com');

DELETE

You can delete entries by specifying the Id.

DELETE FROM TimelineItems WHERE Id='2b748808-9311-4f76-80de-49baac5609e1'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the timeline item, used to reference and track this specific item across the system.
Type	String	False		Indicates the type of the timeline item, which helps categorize the item (for example task, event, milestone).
Title	String	False		The title or brief name of the timeline item, providing a summary of its purpose or content.
CustomActivityId	String	False		The external identifier associated with a custom activity related to the timeline item, useful for integrating with other systems or tools.
UserId	String	False		The unique identifier of the user who created the timeline item, linking it to a specific user in the system.
UserName	String	False		The name of the user who created the timeline item, providing context to identify the creator.
ItemId	String	False		The unique identifier of the item that this timeline item is associated with, typically used to link it to a broader project or task.
BoardId	String	False		The unique identifier of the board where the timeline item is placed, helping to associate the item with a specific project or team.
BoardName	String	False		The name of the board where the timeline item resides, providing more readable context about the item's location.
BoardWorkspaceId	String	False		The unique identifier of the workspace where the board resides, helping to categorize the board within a specific workspace or team.
BoardWorkspaceName	String	False		The name of the workspace associated with the board, offering a human-readable context of where the board is located.

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
Summary	String	A brief summary or overview of the timeline item, typically used to provide a high-level description of the item.
Content	String	The detailed content or description of the timeline item, which could include notes, tasks, or additional context about the item.
Location	String	The location associated with the timeline item, such as an address, region, or venue, providing geographic context.
Phone	String	The phone number associated with the timeline item, often used for contact purposes related to the item.
Url	String	A URL linked to the timeline item, such as a related document, website, or resource for further information.
Timestamp	Datetime	The creation time of the event associated with the timeline item, used to track when the item was created or modified.
TimeRangeStartTimestamp	Datetime	The starting timestamp for a time range associated with the timeline item, such as the beginning of a scheduled event or activity.
TimeRangeEndTimestamp	Datetime	The ending timestamp for a time range associated with the timeline item, marking the conclusion of a scheduled event or activity.