CData Python Connector for HubSpot

Build 25.0.9454

EngagementsTasks

Lists all task engagement records in HubSpot for managing CRM-related tasks.

SELECT

When selecting Task Engagements, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =. 

SELECT * FROM EngagementsTasks WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM EngagementsTasks WHERE Archived = TRUE;

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 False True

Unique identifier of the task engagement object.

Archived Bool True True

Indicates whether the task is archived in HubSpot.

CreatedAt Datetime True False

Timestamp when the task was initially created.

UpdatedAt Datetime True False

Timestamp of the most recent update to the task engagement.

Business units String False False

The business units assigned to this task engagement record.

AtMentioned Owner Ids String False False

User IDs of owners who were @mentioned in this task engagement.

Attached file IDs String False False

IDs of any files attached to this task engagement.

Notes _preview_ String True False

A plain-text preview of the notes field content in this task.

HTML Body Preview String True False

HTML representation of the task's engagement body preview.

Body Preview Truncated Bool True False

Indicates whether the previewed content was truncated.

Calendar Event ID String True False

The ID of the calendar event associated with this task, if synced.

Created by Decimal True False

The user ID of the individual who created this task engagement.

Created by user ID Decimal True False

The system-generated ID of the user who created the task.

Created at Datetime True False

The creation timestamp of this task engagement.

Source String False False

The system or integration that created the task.

Source ID String False False

A unique identifier from the source system that created the task.

Follow up action String False False

Specifies any follow-up action associated with this task.

GDPR deleted Bool True False

Indicates if the content of this engagement was deleted due to a GDPR request.

Last modified at Datetime True False

The last time any property of this task was modified.

Merged object IDs String True False

Object IDs that were merged into this task engagement. Set by HubSpot automatically.

Last modified by Decimal True False

User ID of the last person to update this task.

MS Teams message ID String True False

Microsoft Teams message ID linked to the creation of this task.

Associated Companies Decimal True False

Count of companies associated with this task.

Associated Contacts Decimal True False

Count of contacts associated with this task.

Associated Deals Decimal True False

Count of deals associated with this task.

Associated Queue Objects Decimal True False

Number of objects in queues that are associated with this task.

Associated Tickets Decimal True False

Count of tickets linked to this task.

Record ID Decimal True False

Unique record ID for this task, automatically set by HubSpot.

Product name String False False

The name of the product linked to this task engagement, if any.

Queue String False False

Name of the task queue this task belongs to.

Read Only Object Bool True False

Indicates whether this task record is read-only.

Task repeat status String True False

Specifies if this task is part of a repeating task series.

Scheduled tasks String True False

Information about scheduled occurrences of the task.

Notes String False False

Full content of the notes field for the task.

Completed at Datetime True False

Timestamp when the task was marked as completed.

Contact Time Zone String True False

Time zone of the contact associated with the task.

For Object Type String False False

Type of object this task is associated with, such as contact or deal.

Task is all day Bool False False

Indicates whether the task spans the entire day without a specific time.

Last contacted Datetime True False

Last contact activity timestamp linked to the task's associated contact.

Last engagement Datetime True False

Timestamp of the last sales activity with the contact associated with this task.

Priority String False False

Priority level assigned to the task, such as High or Low.

Task probability to complete Decimal True False

Estimated likelihood of task completion, expressed as a decimal.

Relative Task Reminders String False False

Reminder dates set relative to the due date of the task.

Reminder String False False

Specific dates on which task reminders will be triggered.

Interval String True False

Frequency interval used if the task is repeating.

Send Default Reminder Bool False False

Whether a default reminder is enabled for this task.

Sequence Enrollment Is Active Bool True False

Indicates whether the sequence enrollment linked to this task is currently active.

Sequence step enrollment Id String True False

ID of the sequence step that generated this task.

Sequence step number Decimal True False

The step number of this task within its sequence enrollment.

Task Status String False False

Current status of the task, such as 'Not Started' or 'Completed'.

Task Title String False False

The subject or title of the task.

Task template id Decimal True False

ID of the task template used to create this task.

Task Type String False False

Type of task, such as 'Call' or 'Follow-up'.

Due date Datetime False False

Scheduled due date and time of the task.

Unique creation key String True False

Unique key used to support idempotent creation via API.

Unique ID String False False

Globally unique identifier for the task engagement.

Updated by user ID Decimal True False

User ID of the individual who last updated the task.

User IDs of all notification followers String True False

IDs of users following this task for notifications.

User IDs of all notification unfollowers String True False

IDs of users who have opted out of notifications for this task.

User IDs of all owners String True False

IDs of all users assigned as owners of this task engagement.

Owner Assigned Date Datetime True False

Timestamp when the ownership of this task was assigned.

Assigned to String False False

User assigned to complete the task, manually or via automation.

HubSpot Team String True False

The team of the task's owner.

All owner ids String True False

All default and custom owner IDs linked to this task.

All team ids String True False

Team IDs linked to the owner properties of this task.

All accessible team ids String True False

Team IDs, including hierarchy, that have access to view or manage this task.

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