Enrollments
Retrieves workflows in which a contact is actively enrolled, aiding in workflow monitoring and automation analysis.
Table Specific Information
SELECT
When querying Enrollments, the Id of the contact enrolled in the workflow is required. For example:
SELECT * FROM Enrollments WHERE Id = 123456
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier of the contact enrolled in the workflow. | |
| WorkflowId [KEY] | Long | Unique identifier of the workflow associated with the enrollment. | |
| PortalId | String | HubSpot portal ID where the enrollment is registered. | |
| Name | String | Name or title of the workflow the contact is enrolled in. | |
| Description | String | Detailed description of the workflow. | |
| AllowContactToTriggerMultipleTimes | Bool | Indicates whether a contact is permitted to trigger the workflow multiple times. | |
| AllowEnrollmentFromMerge | Bool | Indicates whether merging contacts can trigger enrollment in the workflow. | |
| EnrollOnCriteriaUpdate | Bool | Specifies whether updates to enrollment criteria will trigger a re-enrollment. | |
| CanEnrollFromSalesforce | Bool | Indicates whether the workflow is accessible from the HubSpot embed within Salesforce. | |
| Listening | Bool | Determines if contacts are automatically unenrolled when they no longer meet the starting list criteria. | |
| Enabled | Bool | Boolean flag indicating whether the workflow enrollment is currently active. | |
| Author | String | Name of the user or account responsible for designing the workflow. | |
| AuthorUserId | Long | Unique user ID of the creator of the workflow. | |
| Type | String | Type or classification of the workflow. | |
| IsSegmentBased | Bool | Indicates whether the workflow is based on a specific segment of contacts. | |
| InsertedAt | Datetime | Timestamp showing when the contact was initially enrolled in the workflow. | |
| UpdatedAt | Datetime | Timestamp showing the last update or enrollment of the contact in the workflow. |