Returns the selectable options for enum and set type deal fields in the Pipedrive V2 API.

Table-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. The FieldCode is required to retrieve the options of a deal field.

For example, the following query is processed server-side:

SELECT * FROM DealFieldsOptions WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0'

INSERT

Execute INSERT by specifying the FieldCode and Label columns. The FieldCode identifies the enum or set deal field that the option is added to. For example:

INSERT INTO DealFieldsOptions (FieldCode, Label) VALUES ('a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0', 'Test label')

UPDATE

Execute UPDATE by specifying the FieldCode and Id in the WHERE clause. For example:

UPDATE DealFieldsOptions SET Label = 'Updated label' WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0' AND Id = 1

DELETE

Execute DELETE by specifying the FieldCode and Id in the WHERE clause. For example:

DELETE FROM DealFieldsOptions WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0' AND Id = 1

Columns