CustomActivities

Retrieves metadata about custom activities in the Email and Activities timeline for enhanced activity tracking.

Table-Specific Information

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

For example, the following queries are processed server side:

SELECT * FROM CustomActivities WHERE Id ='a91e9318-798a-44a6-80a4-49a14e23c015'
SELECT * FROM CustomActivities WHERE Color ='MEDIUM_TURQUOISE'

The following inputs can be used in INSERT statements:

Name, IconId, Color

INSERT INTO CustomActivities (Name, IconId, Color) values ('CActivity', 'CAMERA', 'MEDIUM_TURQUOISE')

You can delete entries by specifying the Id.

DELETE FROM CustomActivities WHERE Id='a91e9318-798a-44a6-80a4-49a14e23c015'


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the custom activity, used to reference and distinguish it from other activities in the system.
Type	String	False		The classification of the custom activity, indicating its role or category within the broader activity framework (for example, 'Workflow', 'Task').
Name	String	False		The human-readable name of the custom activity, displayed in user interfaces or reports to identify it.
IconId	String	False		An identifier corresponding to the icon representing the custom activity, used to visually distinguish it in the user interface. The allowed values are ASCENDING, CAMERA, CONFERENCE, FLAG, GIFT, HEADPHONES, HOMEKEYS, LOCATION, NOTEBOOK, PAPERPLANE, PLANE, PLIERS, TRIPOD, TWOFLAGS, UTENCILS.
Color	String	False		The color associated with the custom activity, typically used for visual categorization or to provide a thematic representation in the UI. The allowed values are BRINK_PINK, CELTIC_BLUE, CORNFLOWER_BLUE, DINGY_DUNGEON, GO_GREEN, GRAY, LIGHT_DEEP_PINK, LIGHT_HOT_PINK, MAYA_BLUE, MEDIUM_TURQUOISE, PARADISE_PINK, PHILIPPINE_GREEN, PHILIPPINE_YELLOW, SLATE_BLUE, VIVID_CERULEAN, YANKEES_BLUE, YELLOW_GREEN, YELLOW_ORANGE.