EngagementsNotes
Retrieve the available Notes in HubSpot.
Select
When selecting Note Engagements, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.
SELECT * FROM EngagementsNotes WHERE ID = '11896226519'
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 | False |
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 | True |
The business units this record is assigned to. | |
| AtMentioned Owner Ids | String | False | True |
The owners that have been at_mentioned on the engagement | |
| Attached file IDs | String | False | True |
The IDs of the files that are attached to the engagement | |
| Body preview | String | True | True |
A truncated preview of the engagegement body | |
| HTML Body Preview | String | True | True |
The HTML representation of the engagement body preview | |
| Body Preview Truncated | Bool | True | True |
Indicates if the engagement body was truncated for the preview | |
| Activity created by | Decimal | True | True |
The user who created the engagement | |
| Created by user ID | Decimal | True | True |
The user that created this object. This value is automatically set by HubSpot and may not be modified. | |
| Create date | Datetime | True | True |
The date that an engagement was created | |
| Engagement Source | String | False | True |
The source that created this engagement | |
| Engagement Source ID | String | False | True |
The specific ID of the process that created this engagement | |
| Follow up action | String | False | True |
What action should be performed during follow up | |
| GDPR deleted | Bool | True | True |
Indicates the body of this engagement has been cleared because of a GDPR delete request | |
| Last modified date | Datetime | True | True |
The date any property on this engagement was modified | |
| Merged object IDs | String | True | True |
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 | True |
The user who last updated the engagement | |
| Note body | String | False | True |
The body of the note | |
| Record ID | Decimal | True | True |
The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | |
| Product name | String | False | True |
The name of the product associated with this engagement | |
| Queue Memberships | String | False | True |
The list of queues that contain this engagement | |
| Read Only Object | Bool | True | True |
Is the object read only | |
| Activity date | Datetime | False | True |
The date that an engagement occurred | |
| Unique creation key | String | True | True |
Unique property used for idempotent creates | |
| Unique ID | String | False | True |
The unique ID of the engagement | |
| Updated by user ID | Decimal | True | True |
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 | True |
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 | True |
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 | True |
The user IDs of all owners of this object | |
| Owner Assigned Date | Datetime | True | True |
The timestamp when an owner was assigned to this engagement | |
| Activity assigned to | String | False | True |
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 | True |
The team of the owner of an engagement. | |
| All owner ids | String | True | True |
The value of all owner referencing properties for this object_ both default and custom | |
| All team ids | String | True | True |
The team ids corresponding to all owner referencing properties for this object_ both default and custom | |
| All accessible team ids | String | True | True |
The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom |