NoteFields
Returns data about all note fields.
View-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.
For example, the following query is processed server-side:
SELECT * FROM NoteFields
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the note field. | |
| ActiveFlag | Boolean | Indicates whether the note field is currently active. | |
| BulkEditAllowed | Boolean | Indicates whether the field can be edited across multiple note records simultaneously. | |
| EditFlag | Boolean | Indicates whether the field can be edited by the current user. | |
| FieldType | String | The data type of the field, such as varchar, text, or date. | |
| Key | String | The internal API key used to reference this field in API requests. | |
| MandatoryFlag | Boolean | Indicates whether the field is required when creating or updating a note. | |
| Name | String | The display name of the note field as it appears in the Pipedrive interface. | |
| Options | String | The list of available options for enum or set field types, returned as an aggregate. |