ProductFields
Returns data about all product fields.
Table-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| Id | = |
For example, the following query is processed server-side:
SELECT * FROM ProductFields WHERE Id = 28
INSERT
Execute INSERT by specifying the Name and FieldType columns. You can also insert any columns that are not required.
For example:
INSERT INTO ProductFields (Name, FieldType) VALUES ('BangaloreCdataIndia123', 'address')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE ProductFields SET Name = 'My name just started here' WHERE Id = 28
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM ProductFields WHERE Id = 9040
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
ID of the Product Field. | |
| ActiveFlag | Boolean | True |
Whether the field is available in the add new product dialog in the Pipedrive web and mobile applications. | |
| AddTime | Datetime | True |
The date and time when the field was created. | |
| AddVisibleFlag | Boolean | True |
Whether the field is shown in the add new product dialog in the Pipedrive web and mobile applications. | |
| BulkEditAllowed | Boolean | True |
Whether the field can be edited in bulk operations. | |
| DetailsVisibleFlag | Boolean | True |
Whether the field is visible on the product detail view. | |
| EditFlag | Boolean | True |
Whether the field can be edited by the current user. | |
| FieldType | String | False |
Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to. | |
| FilteringAllowed | Boolean | True |
Whether the field can be used as a filter condition in product list views. | |
| ImportantFlag | Boolean | True |
Whether the field is marked as important and highlighted in the product detail view. | |
| IndexVisibleFlag | Boolean | True |
Whether the field is visible in the product list view. | |
| Key | String | True |
The unique machine-readable key that identifies the field within the Pipedrive API. | |
| LastUpdatedByUserId | String | True |
The ID of the user who last modified the field definition. | |
| MandatoryFlag | Boolean | True |
Whether the field is required when creating or updating a product. | |
| Name | String | False |
Name of the field. | |
| Options | String | False |
The list of selectable options available for enum or set type fields. | |
| OrderNr | Integer | True |
The display order number of the field relative to other fields in the product detail view. | |
| PicklistData | String | True |
The raw picklist data associated with the field, used internally to populate selectable option lists. | |
| SearchableFlag | Boolean | True |
Whether the field is included in global search results within Pipedrive. | |
| SortableFlag | Boolean | True |
Whether the product list view can be sorted by this field. | |
| UpdateTime | Datetime | True |
The date and time when the field definition was last modified. |