NoteComments

Returns comments associated with a specific note, and supports creating, updating, and deleting those comments.

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
NoteId	=
UUID	=

For example, the following query is processed server-side:

SELECT * FROM NoteComments WHERE NoteId = 14

INSERT

Execute INSERT by specifying the NoteId and Content columns. You can also insert any columns that are not required.

INSERT INTO NoteComments (NoteId, Content) VALUES (2, 'Test comment')

UPDATE

Execute UPDATE by specifying the NoteId and UUID in the WHERE clause. The columns that are not read-only can be updated. For example:

UPDATE NoteComments SET Content = 'Test' WHERE NoteId = 1 and UUID = '53e0c79fdacf083d9fe1f799fdc0a206'

DELETE

Execute DELETE by specifying the NoteId and UUID in the WHERE clause. For example:

DELETE FROM NoteComments WHERE NoteId = 1 and UUID = '53e0c79fdacf083d9fe1f799fdc0a206'

Columns


Name	Type	ReadOnly	References	Description
NoteId [KEY]	Integer	False		ID of the note.
UUID [KEY]	String	True		Comment Id.
ActiveFlag	Boolean	True		Indicates whether the comment is active and visible in the Pipedrive application.
AddTime	String	True		The date and time when the comment was created.
CompanyId	Integer	True		The ID of the company account this comment belongs to.
Content	String	False		Content of the comment.
ObjectId	String	True		The ID of the object this comment is attached to, such as a note or deal.
ObjectType	String	True		The type of object this comment is attached to, such as note or deal.
UpdateTime	String	True		The date and time when the comment was last updated.
UpdaterId	Integer	True		The ID of the user who last updated this comment.
UserId	Integer	True		The ID of the user who created this comment.