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 operator 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. |