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 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 identifier of the object. | |
| Archived | Bool | True | True |
Whether the object is archived or not. | |
| CreatedAt | Datetime | True | False |
When the object was created. | |
| UpdatedAt | Datetime | True | False |
When the object was last updated. | |
| Call and meeting type | String | False | False |
The activity type of the engagement. | |
| Business units | String | False | False |
The business units this record is assigned to. | |
| AtMentioned Owner Ids | String | False | False |
The owners that have been at_mentioned on the engagement. | |
| Attached file IDs | String | False | False |
The IDs of the files that are attached to the engagement. | |
| Call notes preview | String | True | False |
A truncated preview of the call notes. | |
| HTML Body Preview | String | True | False |
The HTML representation of the engagement body preview. | |
| Body Preview Truncated | Bool | True | False |
Indicates whether the engagement body was truncated for the preview. | |
| Integrating App ID | Decimal | False | False |
The App ID associated with the integrating app. | |
| Authenticated recording files url provider | String | True | False |
URL which returns Authenticated audio_video URL of the recording. | |
| Call notes | String | False | False |
The body of the call. | |
| Callee object id | Decimal | False | False |
The id of the callee. | |
| Callee object type | String | False | False |
The type of callee. | |
| Call direction | String | False | False |
The direction of a call. | |
| Call outcome | String | False | False |
The outcome of the call. | |
| Call duration | Decimal | False | False |
The duration of the call_ in milliseconds. | |
| External Account ID | String | False | False |
External Account ID. | |
| External ID | String | False | False |
The external ID of the call. | |
| From Number | String | False | False |
The phone number of the person that initiated the call. | |
| From Number Name | String | True | False |
The name of the phone number that initiated the call. | |
| Transcript Available | Bool | False | False |
Flag to indicate if the call has an associated transcript. | |
| Voicemail Available | String | True | False |
Flag to indicate if the call has an associated voicemail. | |
| Recording URL | String | False | False |
The URL of the recorded call audio. | |
| Call Source | String | False | False |
The source of the call to differentiate VoIP vs Video Conferencing Apps. | |
| Call status | String | False | False |
The status of the call. | |
| Call Title | String | False | False |
The title of the call. | |
| To Number | String | False | False |
The phone number of the person that was called. | |
| To Number Name | String | True | False |
The name of the phone number that was called. | |
| Tracked terms | String | True | False |
A list of any tracked terms contained in the call transcript. | |
| Call transcription id | Decimal | False | False |
The id of the transcription. | |
| Video url | String | False | False |
Video URL of the recording. | |
| Unique Zoom Meeting ID | String | False | False |
The Zoom meeting unique identifier of the call. | |
| Calls Service Call ID | Decimal | True | False |
The Calls Service specific global unique identifier for a call. | |
| Activity created by | Decimal | True | False |
The user who created the engagement. | |
| Created by user ID | Decimal | True | False |
The user that created this object. This value is automatically set by HubSpot and may not be modified. | |
| Create date | Datetime | True | False |
The date that an engagement was created. | |
| Engagement Source | String | False | False |
The source that created this engagement. | |
| Engagement Source ID | String | False | False |
The specific ID of the process that created this engagement. | |
| Follow up action | String | False | False |
What action should be performed during follow up. | |
| GDPR deleted | Bool | True | False |
Indicates the body of this engagement has been cleared because of a GDPR delete request. | |
| Last modified date | Datetime | True | False |
The date any property on this engagement was modified. | |
| Merged object IDs | String | True | False |
The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. | |
| Updated by | Decimal | True | False |
The user who last updated the engagement. | |
| Record ID | Decimal | True | False |
The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | |
| Product name | String | False | False |
The name of the product associated with this engagement. | |
| Queue Memberships | String | False | False |
The list of queues that contain this engagement. | |
| Read Only Object | Bool | True | False |
Is the object read only. | |
| Activity date | Datetime | False | False |
The date that an engagement occurred. | |
| Unique creation key | String | True | False |
Unique property used for idempotent creates. | |
| Unique ID | String | False | False |
The unique ID of the engagement. | |
| Unknown Visitor Conversation | Bool | False | False |
Whether or not this communication was made with an unknown visitor. | |
| Updated by user ID | Decimal | True | False |
The user that last updated this object. This value is automatically set by HubSpot and may not be modified. | |
| User IDs of all notification followers | String | True | False |
The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications. | |
| User IDs of all notification unfollowers | String | True | False |
The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications. | |
| User IDs of all owners | String | True | False |
The user IDs of all owners of this object. | |
| Owner Assigned Date | Datetime | True | False |
The timestamp when an owner was assigned to this engagement. | |
| Activity assigned to | String | False | False |
The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows. | |
| HubSpot Team | String | True | False |
The team of the owner of an engagement. | |
| All owner ids | String | True | False |
The value of all owner referencing properties for this object_ both default and custom. | |
| All team ids | String | True | False |
The team ids corresponding to all owner referencing properties for this object_ both default and custom. | |
| All accessible team ids | String | True | False |
The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom. |