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

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

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

SELECT * FROM PersonFieldsOptions WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0'

INSERT

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

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

UPDATE

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

UPDATE PersonFieldsOptions 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 PersonFieldsOptions WHERE FieldCode = 'a1b2c3d4e5f6a7b8c9d0e1f2a3b4c5d6e7f8a9b0' AND Id = 1

Columns