Returns all notes.

Select

The add-in will use 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 add-in.

• Id supports the '=' operator.
• UserId supports the '=' operator.
• LeadId supports the '=' operator.
• DealId supports the '=' operator.
• PersonId supports the '=' operator.
• OrgId supports the '=' operator.
• PinnedToLeadFlag supports the '=' operator.
• PinnedToDealFlag supports the '=' operator.
• PinnedToOrganizationFlag supports the '=' operator.
• PinnedToPersonFlag supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Notes WHERE Id = 9                  

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Notes (ActiveFlag, Content, PersonId, AddTime) VALUES ('true', 'this is frist notes', '8', '2021-12-31')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Notes SET Content = 'I am updating content' WHERE id = 7

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Notes WHERE Id = 5

Columns