TimelineItems

Get metadata about items in the Email and Activities timeline.

Table-Specific Information

SELECT

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

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

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

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

INSERT

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

Title, CustomActivityId, Content, Timestamp, ItemId

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

Summary, Location, Phone, Url, 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 following column:

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

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The timeline item's unique identifier.
Type	String	True		The timeline item's type.
Title	String	True		The title of the timeline item.
CustomActivityId	String	True		The external ID of the custom activity of the timeline item.
Content	String	True		The item content.
Timestamp	Datetime	True		The creation time of the event.
UserId	String	True		The unique identifier of the user who created the timeline item.
UserName	String	True		The name of the user who created the timeline item.
ItemId	String	True		The unique identifier of the item that the timeline item is on.
BoardId	String	True		The unique identifier of the board that the timeline item is on.
BoardName	String	True		The name of the board that the timeline item is on.
BoardWorkspaceId	String	True		The unique identifier of the workspace that the timeline item is on.
BoardWorkspaceName	String	True		The name of the workspace that the timeline item is on.

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	The item summary.
Location	String	Location field value.
Phone	String	Phone number field value.
Url	String	URL field value.
TimeRangeStartTimestamp	Datetime	The time range's start.
TimeRangeEndTimestamp	Datetime	The time range's end.