EngagementsCalls

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

SELECT

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

SELECT * FROM EngagementsCalls WHERE ID = '11896247257'

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	True		True	Unique identifier for the call engagement object.
Archived	Bool	True		False	Indicates whether the call engagement has been archived.
CreatedAt	Datetime	True		False	Timestamp when the call engagement was originally created.
UpdatedAt	Datetime	True		False	Timestamp when the call engagement was most recently updated.
Call and meeting type	String	False		True	Type of activity, such as a call or meeting, associated with the engagement.
Business units	String	False		True	Business units this call engagement is associated with.
AtMentioned Owner Ids	String	False		True	User IDs of owners who were mentioned in the call notes.
Attached file IDs	String	False		True	Identifiers of files attached to the call engagement.
Call notes preview	String	True		True	A shortened preview of the call notes content.
HTML Body Preview	String	True		True	HTML-formatted version of the call notes preview.
Body Preview Truncated	Bool	True		True	Indicates whether the call notes preview was truncated due to length.
Integrating App ID	Decimal	False		True	Unique ID of the third-party app that integrated or logged the call.
Authenticated recording files url provider	String	True		True	Endpoint that returns a secure URL to access the call's audio or video recording.
Call notes	String	False		True	Full written notes or transcription of the call content.
Callee object id	Decimal	False		True	Identifier of the object (such as a contact) who received the call.
Callee object type	String	False		True	Type of the object that received the call, such as contact or company.
Call direction	String	False		True	Direction of the call—whether it was inbound or outbound.
Call outcome	String	False		True	Result or outcome of the call, such as completed, no answer, or left voicemail.
Call duration	Decimal	False		True	Length of the call in milliseconds.
External Account ID	String	False		True	ID of the external system account related to the call, if applicable.
External ID	String	False		True	Unique ID from an external system referencing this call engagement.
From Number	String	False		True	Phone number used to initiate the call.
From Number Name	String	True		True	Label or contact name associated with the originating phone number.
Transcript Available	Bool	False		True	Indicates whether a transcript is available for this call.
Voicemail Available	String	True		True	Specifies whether a voicemail recording exists for this call.
Recording URL	String	False		True	Direct URL to the call's recorded audio file, if available.
Call Source	String	False		True	Platform or technology used to make the call, such as VoIP or video conferencing.
Call status	String	False		True	Current status of the call engagement, such as completed or in progress.
Call Title	String	False		True	Title or subject line associated with the call.
To Number	String	False		True	Phone number that was dialed for the call.
To Number Name	String	True		True	Name or label linked to the recipient's phone number.
Tracked terms	String	True		True	List of keywords or phrases tracked within the call transcript.
Call transcription id	Decimal	False		True	Unique ID referencing the transcription data for the call.
Video url	String	False		True	URL to access the video recording of the call, if applicable.
Unique Zoom Meeting ID	String	False		True	Unique identifier for the Zoom meeting if the call was made through Zoom.
Calls Service Call ID	Decimal	True		True	Global unique identifier for the call as assigned by HubSpot's Calls Service.
Activity created by	Decimal	True		True	User ID of the person who originally created the call engagement activity.
Created by user ID	Decimal	True		True	User ID that created this record. This value is set automatically by HubSpot and cannot be modified.
Create date	Datetime	True		True	The date the call engagement was created in the CRM timeline.
Engagement Source	String	False		True	System or integration source that created the call engagement.
Engagement Source ID	String	False		True	Unique identifier of the source process or integration that created the engagement.
Follow up action	String	False		True	Recommended follow-up action related to the call, such as 'Send email' or 'Schedule meeting'.
GDPR deleted	Bool	True		True	Indicates whether the call content was cleared due to a GDPR delete request.
Last modified date	Datetime	True		True	Timestamp of the most recent change made to the call engagement.
Merged object IDs	String	True		True	IDs of records that were merged into this call engagement. Automatically maintained by HubSpot.
Updated by	Decimal	True		True	User ID of the person who last updated the engagement record.
Record ID	Decimal	True		True	HubSpot-assigned unique identifier for the engagement record.
Product name	String	False		True	Name of the product discussed or referenced during the call, if applicable.
Queue Memberships	String	False		True	List of queues in which the call engagement is currently placed.
Read Only Object	Bool	True		True	Indicates whether the record is locked for editing and is read-only.
Activity date	Datetime	False		True	Date and time when the call engagement took place, as recorded in the timeline.
Unique creation key	String	True		True	Unique key used for idempotent creation of the call engagement to avoid duplicates.
Unique ID	String	False		True	Another unique identifier used to reference the engagement, separate from Record ID.
Unknown Visitor Conversation	Bool	False		True	Indicates whether the engagement was made with a visitor whose identity is not known.
Updated by user ID	Decimal	True		True	User ID of the person who most recently updated this engagement. Automatically set by HubSpot.
User IDs of all notification followers	String	True		True	User IDs of individuals who have opted to receive notifications for updates to this engagement.
User IDs of all notification unfollowers	String	True		True	User IDs of owners who have opted out of notifications for this engagement.
User IDs of all owners	String	True		True	User IDs of all owners assigned to this engagement, including default and custom owners.
Owner Assigned Date	Datetime	True		True	Date and time when ownership was last assigned to the engagement. Automatically set by HubSpot.
Activity assigned to	String	False		True	User ID of the person this engagement is currently assigned to. Can be a HubSpot user or a Salesforce integration user.
HubSpot Team	String	True		True	Team associated with the owner of this engagement. Automatically assigned by HubSpot.
All owner ids	String	True		True	List of all owner property IDs linked to the engagement, including custom owners.
All team ids	String	True		True	IDs of all teams associated with the engagement owners, based on ownership properties.
All accessible team ids	String	True		True	IDs of all teams, including those higher in the hierarchy, that have access to this engagement based on owner permissions.

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

Build 25.0.9454