EngagementsNotes
Retrieves note engagement records in HubSpot, used for logging internal or customer notes.
SELECT
When selecting Note Engagements, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operator is =.
SELECT * FROM EngagementsNotes WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'; SELECT * FROM EngagementsNotes WHERE Archived = TRUE;
INSERT
INSERT INTO EngagementsNotes ([Note body], [UpdatedAt], [Activity date]) VALUES ('Body of the note.', current_timestamp(), current_timestamp() )
UPDATE
UPDATE EngagementsNotes SET [Note body] = 'Updated body of the note.' WHERE ID = '11896226519'
DELETE
DELETE FROM EngagementsNotes WHERE ID = '11896226519'
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. | |
| 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. | |
| Body preview | String | True | False |
A truncated preview of the engagegement body. | |
| 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. | |
| 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. | |
| Note body | String | False | False |
The body of the note. | |
| 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. | |
| 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. |