ActivityFields
Returns all activity fields defined in the Pipedrive account, including both standard and custom field metadata.
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 ActivityFields
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the activity field. | |
| ActiveFlag | Boolean | Indicates whether the activity field is currently active. | |
| AddTime | Datetime | The date and time when the activity field was created. | |
| AddVisibleFlag | Boolean | Indicates whether the field is visible on the activity add form. | |
| BulkEditAllowed | Boolean | Indicates whether the field can be edited in bulk operations. | |
| DetailsVisibleFlag | Boolean | Indicates whether the field is visible on the activity detail view. | |
| 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, int, or date. | |
| FilteringAllowed | Boolean | Indicates whether the field can be used as a filter criterion. | |
| ImportantFlag | Boolean | Indicates whether the field is marked as important and given prominent placement. | |
| IndexVisibleFlag | Boolean | Indicates whether the field is visible in the activity list view. | |
| Key [KEY] | String | The internal API key used to reference this field in API requests. | |
| LastUpdatedByUserId | String | The identifier of the user who last modified this field definition. | |
| MandatoryFlag | Boolean | Indicates whether the field is required when creating or updating an activity. | |
| Name | String | The display name of the activity 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. | |
| OrderNr | Integer | The display order position of this field relative to other activity fields. | |
| SearchableFlag | Boolean | Indicates whether the field is included in search operations. | |
| SortableFlag | Boolean | Indicates whether the activity list can be sorted by this field. | |
| UpdateTime | Datetime | The date and time when the activity field definition was last updated. |