CData Python Connector for HubSpot

Build 25.0.9454

EngagementsCalls

Retrieves all call engagement records in HubSpot, used for tracking customer communication.

SELECT

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

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

INSERT


INSERT INTO EngagementsCalls ([Call Title], [Call notes], [Call duration], [From Number], [To Number], [Recording URL], [Call status], [Activity date])
VALUES ('CallEngagement Title', 'CallEngagement Body', '60', '123-456-7890', '789-123-4560', 'https://www.cdata.com', 'CALLING_CRM_USER', current_timestamp() )

UPDATE


UPDATE EngagementsCalls SET [Call status] = 'COMPLETED' WHERE ID = '11896247257'

DELETE


DELETE FROM EngagementsCalls WHERE ID = '11896247257'

Columns

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

Unique ID for the call engagement record.

Archived Bool True True

Indicates whether the engagement is archived.

CreatedAt Datetime True False

Timestamp when the call engagement record was created.

UpdatedAt Datetime True False

Timestamp of the most recent update to the call engagement record.

Call and meeting type String False False

Specifies whether the engagement was a call, meeting, or another activity type.

Business units String False False

Business units this call engagement is associated with.

AtMentioned Owner Ids String False False

User IDs of owners who were mentioned in the call engagement.

Attached file IDs String False False

List of file IDs that were attached to this call engagement.

Call notes preview String True False

Preview snippet of the call notes.

HTML Body Preview String True False

HTML version of the call engagement's body preview.

Body Preview Truncated Bool True False

Indicates whether the body preview was truncated for length.

Integrating App ID Decimal False False

App ID of the integration that created the engagement, if applicable.

Authenticated recording files url provider String True False

URL that serves authenticated access to the call recording.

Call notes String False False

Full notes recorded for the call engagement.

Callee object id Decimal False False

Identifier of the object being called, such as a contact or company.

Callee object type String False False

Type of object being called (such as Contact, Company, or Deal).

Call direction String False False

Specifies whether the call was inbound or outbound.

Call outcome String False False

Result of the call, such as Connected, No Answer, or Left Voicemail.

Call duration Decimal False False

Duration of the call in milliseconds.

External Account ID String False False

External account identifier linked to the call engagement.

External ID String False False

External identifier for this call engagement from a third-party system.

From Number String False False

Phone number that initiated the call.

From Number Name String True False

Name associated with the phone number that initiated the call.

Transcript Available Bool False False

Indicates whether a transcript is available for the call.

Voicemail Available String True False

Indicates if the call has a voicemail recording.

Recording URL String False False

Link to the call audio recording.

Call Source String False False

Source of the call, such as VoIP, phone integration, or conferencing tool.

Call status String False False

Current status of the call, such as Scheduled, Completed, or Cancelled.

Call Title String False False

Title or subject of the call engagement.

To Number String False False

Phone number that received the call.

To Number Name String True False

Name associated with the recipient phone number.

Tracked terms String True False

Keywords or phrases tracked in the call transcript.

Call transcription id Decimal False False

Identifier for the call transcription associated with this engagement.

Video url String False False

Link to the video recording of the call, if available.

Unique Zoom Meeting ID String False False

Unique identifier for the Zoom meeting if the call was conducted through Zoom.

Calls Service Call ID Decimal True False

Unique ID assigned to this call by the HubSpot Calls Service.

Activity created by Decimal True False

User ID of the person who logged or created the call engagement.

Created by user ID Decimal True False

HubSpot user ID that created this record. This value is system-generated and read-only.

Create date Datetime True False

The date the call engagement was created in HubSpot.

Engagement Source String False False

The platform or integration source that created this call engagement.

Engagement Source ID String False False

Specific identifier from the platform or integration that created this call engagement.

Follow up action String False False

Recommended follow-up action associated with the call.

GDPR deleted Bool True False

Indicates whether the engagement's content was deleted due to a GDPR compliance request.

Last modified date Datetime True False

The most recent timestamp when any property of this call engagement was updated.

Merged object IDs String True False

List of object IDs that have been merged into this call engagement record.

Updated by Decimal True False

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

Record ID Decimal True False

Unique ID for the record, automatically assigned by HubSpot.

Product name String False False

Name of the product associated with the call, if applicable.

Queue Memberships String False False

List of queues that this call engagement is a part of.

Read Only Object Bool True False

Indicates whether the call engagement is read-only.

Activity date Datetime False False

Date when the call activity occurred.

Unique creation key String True False

Unique property used for idempotent creation to prevent duplicate call engagements.

Unique ID String False False

Unique identifier of the engagement for internal tracking.

Unknown Visitor Conversation Bool False False

Indicates whether the call involved an unidentified visitor.

Updated by user ID Decimal True False

User ID of the person who last modified the call engagement record.

User IDs of all notification followers String True False

User IDs of individuals who are following this call engagement for updates.

User IDs of all notification unfollowers String True False

User IDs of individuals who have opted out of following this call engagement.

User IDs of all owners String True False

User IDs of all owners assigned to this call engagement.

Owner Assigned Date Datetime True False

Timestamp when ownership of the call engagement was assigned.

Activity assigned to String False False

User or Salesforce user the call activity is assigned to, can be set manually or via workflows.

HubSpot Team String True False

Team associated with the owner of this call engagement.

All owner ids String True False

All owner reference property values associated with this call engagement.

All team ids String True False

Team IDs corresponding to owner properties of this call engagement.

All accessible team ids String True False

Team IDs, including hierarchical teams, that have access to this call engagement.

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