ActivityFields
Returns all activity fields defined in the Pipedrive account, including both standard and custom field metadata exposed through the Fields API v2.
View-Specific Information
SELECT
The connector uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| FieldCode | = |
For example, the following queries are processed server-side:
SELECT * FROM ActivityFields
SELECT * FROM ActivityFields WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0'
Columns
| Name | Type | References | Description |
| FieldCode [KEY] | String | The unique machine-readable code that identifies the field within the Pipedrive V2 API. | |
| FieldName | String | The display name of the activity field. | |
| Description | String | A human-readable description of the activity field. | |
| FieldType | String | The data type of the field, such as varchar, enum, set, or address. | |
| IsCustomField | Boolean | Indicates whether the field is a user-defined custom field rather than a standard Pipedrive field. | |
| IsOptionalResponseField | Boolean | Indicates whether the field is returned only when explicitly requested through the include_fields parameter. | |
| Options | String | A JSON aggregate containing the selectable options available for enum or set type fields, each with an id and label. | |
| Subfields | String | A JSON aggregate containing the subfields that make up a composite field, such as the parts of an address field. | |
| UiVisibilityAddVisibleFlag | Boolean | Indicates whether the field is shown in the add new activity field dialog. Returned via include_fields. | |
| UiVisibilityDetailsVisibleFlag | Boolean | Indicates whether the field is visible on the activity field detail view. Returned via include_fields. |