# NoteCommentsByNoteId ## Documentation The comments on one note. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Notes` - Primary Keys: `note_id, uuid` - Retrieve: True - Insert: True - Update: False - Delete: False ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `NoteCommentsByNoteId`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `note_id` | `int64` | ☑ | | The note id. | ## Columns of Table Function The columns of the table function `NoteCommentsByNoteId` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_flag` | `char` | | ☐ | Whether the note is active or deleted. | | `add_time` | `datetime` | | ☐ | The creation date and time of the note. | | `company_id` | `int64` | | ☐ | The ID of the company. | | `content` | `varchar2` | | ☐ | The content of the note in HTML format. | | `note_id` | `int64` | | ☑ | The note id the rows were read for. | | `object_id` | `varchar2` | | ☐ | The ID of the object that the comment is attached to, will be the id of the note. | | `object_type` | `varchar2` | | ☐ | The type of object that the comment is attached to, will be "note". | | `update_time` | `datetime` | | ☐ | The creation date and time of the note. | | `updater_id` | `int64` | | ☐ | The ID of the user who last updated the comment. | | `user_id` | `int64` | | ☐ | The ID of the user who created the comment. | | `uuid` | `varchar2` | | ☑ | The ID of the note. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `object_id` | [[Notes-Notes\|Notes.Notes]] | `id` | In words only: The note commented on, when object_type is 'note'. |