ODBC Driver for HubSpot

Build 25.0.9434

EngagementsTasks

Retrieves all task engagement records, allowing management of action items related to CRM records.

SELECT

When selecting Task Engagements, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =. 

SELECT * FROM EngagementsTasks WHERE ID = '11896356808'

INSERT


INSERT INTO EngagementsTasks ([Task title], [Task notes], [Task status], [Task type], [Activity date])
VALUES ('Test Task Title', 'Body of the task', 'IN_PROGRESS', 'LINKED_IN_MESSAGE', current_timestamp())

UPDATE


UPDATE EngagementsTasks SET [Task notes] = 'Updated Task body test', [Task status] = 'COMPLETED' WHERE ID = '11896363224'

DELETE


DELETE FROM EngagementsTasks WHERE ID = '11896363224'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long True True

Unique identifier for the task engagement record in HubSpot.

Archived Bool True False

Indicates whether the task is archived and no longer active in workflows or CRM views.

CreatedAt Datetime True False

Timestamp of when the task engagement was first created in HubSpot.

UpdatedAt Datetime True False

Timestamp of the most recent update made to this task engagement.

Business units String False True

Business units associated with the task, used for segmentation and ownership management.

AtMentioned Owner Ids String False True

HubSpot owner IDs that were @mentioned in the body of the task.

Attached file IDs String False True

IDs of files attached to the task, used to provide supporting documents or context.

Notes _preview_ String True True

A plain text summary or preview of the notes field on the task.

HTML Body Preview String True True

HTML-formatted version of the task body for rendering in the HubSpot UI.

Body Preview Truncated Bool True True

Indicates whether the task body preview was truncated due to length constraints.

Calendar Event ID String True True

Identifier for the calendar event linked or synced with this task engagement.

Created by Decimal True True

ID of the user who originally created the task engagement.

Created by user ID Decimal True True

HubSpot user ID of the individual who created this task. Automatically set by the system.

Created at Datetime True True

The date and time when the task was created.

Source String False True

The origin of the task creation, such as a CRM action, API call, or external integration.

Source ID String False True

Unique identifier of the system, user, or tool that created this task.

Follow up action String False True

The suggested follow-up action to be taken after this task, such as a call or meeting.

GDPR deleted Bool True True

Indicates whether the task content was removed in compliance with a GDPR deletion request.

Last modified at Datetime True True

The most recent timestamp when any property of the task was updated.

Merged object IDs String True True

A list of engagement object IDs that have been merged into this task. Managed by HubSpot.

Last modified by Decimal True True

User ID of the person who last updated the task engagement.

MS Teams message ID String True True

Identifier for the Microsoft Teams message that resulted in the task being created.

Associated Companies Decimal True True

The number of companies associated with this task for tracking or reporting.

Associated Contacts Decimal True True

The number of contacts linked to this task for context and relationship tracking.

Associated Deals Decimal True True

The number of deals tied to this task engagement.

Associated Queue Objects Decimal True True

Count of all objects associated with this task that support queue-based workflows.

Associated Tickets Decimal True True

The number of support tickets associated with the task for customer service follow-up.

Record ID Decimal True True

System-generated unique ID for this specific task record in HubSpot.

Product name String False True

The product or service referenced in or related to this task, if applicable.

Queue String False True

The name of the queues that this task is a part of. Useful for task assignment and workflow organization.

Read Only Object Bool True True

Indicates whether the task engagement is read-only and cannot be modified.

Task repeat status String True True

Specifies whether the task is set to repeat, and its current repeat state.

Scheduled tasks String True True

Details on any recurring tasks or schedules linked to this task engagement.

Notes String False True

Full content entered in the notes field of the task, often used for reminders or context.

Completed at Datetime True True

Timestamp of when the task was marked as completed.

Contact Time Zone String True True

Time zone of the associated contact, useful for scheduling and reminder purposes.

For Object Type String False True

Specifies the HubSpot object type (such as contact or deal) that this task is associated with.

Task is all day Bool False True

Indicates whether the task is due all day or at a specific time on the due date.

Last contacted Datetime True True

The most recent interaction (email, call, or meeting) logged for the associated contact.

Last engagement Datetime True True

The last time any sales activity was recorded for the associated contact.

Priority String False True

The importance level of the task (such as High, Medium, or Low).

Task probability to complete Decimal True True

Numerical probability that the task will be completed, based on predictive modeling or rules.

Relative Task Reminders String False True

Dates when reminders are triggered relative to the due date, such as one day before.

Reminder String False True

Specific dates or times when the user will receive reminders for the task.

Interval String True True

Frequency for repeating tasks (such as daily, weekly, or monthly).

Send Default Reminder Bool False True

Specifies whether HubSpot should automatically send a reminder when the task is due.

Sequence Enrollment Is Active Bool True True

Indicates whether the sequence enrollment that created the task is still active.

Sequence step enrollment Id String True True

The identifier of the specific step in a sequence that generated this task.

Sequence step number Decimal True True

The position of this task within its enrollment sequence.

Task Status String False True

The current state of the task (such as Not Started, In Progress, or Completed).

Task Title String False True

The subject or headline of the task, often shown in task lists or notifications.

Task template id Decimal True True

Identifier of the template from which this task was created, if any.

Task Type String False True

The type or category of the task (such as Follow-up, Email, or Call).

Due date Datetime False True

Date and time the task is due to be completed.

Unique creation key String True True

A unique string used to ensure idempotent creation of task records via API.

Unique ID String False True

System-generated unique identifier for this specific task engagement.

Updated by user ID Decimal True True

HubSpot user ID of the person who last modified the task.

User IDs of all notification followers String True True

List of user IDs following this task to receive notifications on updates or completions.

User IDs of all notification unfollowers String True True

List of user IDs who opted out of notifications for this task.

User IDs of all owners String True True

User IDs of all owners assigned to this task, including default and custom owner fields.

Owner Assigned Date Datetime True True

Timestamp when ownership of the task was most recently assigned.

Assigned to String False True

HubSpot or Salesforce user assigned to this task. Can be set manually or via automation.

HubSpot Team String True True

The team associated with the current owner of the task. Used for access control and reporting.

All owner ids String True True

All values of properties that reference owners, both default and custom.

All team ids String True True

All team IDs tied to this task's owner properties, for default and custom teams.

All accessible team ids String True True

All team IDs with access to this task, including those inherited from team hierarchy.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434