Notes
Returns all notes associated with deals, persons, organizations, and leads, including content, pinning state, and authorship details.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| UserId | = |
| LeadId | = |
| DealId | = |
| PersonId | = |
| OrgId | = |
| PinnedToLeadFlag | = |
| PinnedToDealFlag | = |
| PinnedToOrganizationFlag | = |
| PinnedToPersonFlag | = |
For example, the following query is processed server-side:
SELECT * FROM Notes WHERE Id = 9
INSERT
Execute INSERT by specifying the Content and PersonId columns. All columns that are not required are optional.
For example:
INSERT INTO Notes (ActiveFlag, Content, PersonId, AddTime) VALUES ('true', 'my notes', '8', '2021-12-31')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Notes SET Content = 'I am updating content' WHERE Id = 7
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM Notes WHERE Id = 5
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
ID of the note. | |
| ActiveFlag | Boolean | False |
Indicates whether the note is active. Setting this to false effectively archives the note. | |
| AddTime | Datetime | False |
Date and time when the note was created. | |
| Content | String | False |
HTML-formatted text body of the note. | |
| DealTitle | String | True |
Title of the deal this note is associated with. | |
| DealId | Integer | False |
The ID of the deal which notes to fetch. | |
| LastUpdateUserId | Integer | True |
Unique identifier of the user who last updated the note. | |
| LeadId | String | False |
The ID of the lead which notes to fetch. | |
| OrgId | Integer | False |
The ID of the organization which notes to fetch. | |
| OrganizationName | String | True |
Name of the organization this note is associated with. | |
| PersonName | String | True |
Name of the person this note is associated with. | |
| PersonId | Integer | False |
The ID of the person whose notes to fetch. | |
| PinnedToDealFlag | Boolean | False |
If set, then results are filtered by note to deal pinning state. The allowed values are 0, 1. | |
| PinnedToLeadFlag | Boolean | False |
If set, then results are filtered by note to lead pinning state. The allowed values are 0, 1. | |
| PinnedToOrganizationFlag | Boolean | False |
If set, then results are filtered by note to organization pinning state. The allowed values are 0, 1. | |
| PinnedToPersonFlag | Boolean | False |
If set, then results are filtered by note to person pinning state. The allowed values are 0, 1. | |
| UpdateTime | Datetime | True |
Date and time when the note was last updated. | |
| UserEmail | String | True |
Email address of the user who created the note. | |
| UserIconUrl | String | True |
URL of the profile icon for the user who created the note. | |
| UserIsYou | Boolean | True |
Indicates whether the note was created by the currently authenticated user. | |
| UserName | String | True |
Full name of the user who created the note. | |
| UserId | Integer | False |
The ID of the user whose notes to fetch. |