OrganizationFields

Returns data about all organization fields, including built-in and custom field definitions.

Table-Specific Information

SELECT

The provider uses the Pipedrive API to apply WHERE clause conditions with the supported column and operator listed below. It processes all other filters client-side within the provider.


Column	Supported Operators
Id	=

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

SELECT * FROM OrganizationFields WHERE Id = 2

INSERT

To insert data, specify values for the Name and FieldType columns. You can include additional, optional columns as needed. For example:

INSERT INTO OrganizationFields (Name, FieldType) VALUES ('Terex', 'text')

UPDATE

To update a record, include the Id in the WHERE clause and set new values for any editable (non-read-only) columns. For example:

UPDATE OrganizationFields SET Name = 'Terry' WHERE Id = 2

DELETE

To delete a record, specify the Id in the WHERE clause. For example:

DELETE FROM OrganizationFields WHERE Id = 2

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the organization field.
ActiveFlag	Boolean	True		Indicates whether the field is active and visible in the Pipedrive interface.
AddTime	Datetime	True		The date and time when the field was created.
AddVisibleFlag	Boolean	False		Whether the field is available in 'add new' modal or not. The default value is true.
BulkEditAllowed	Boolean	True		Indicates whether this field can be edited in bulk operations.
DetailsVisibleFlag	Boolean	True		Indicates whether the field is visible on the organization detail view.
EditFlag	Boolean	True		Indicates whether the field can be edited by users.
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		Indicates whether this field can be used as a filter criterion.
ImportantFlag	Boolean	True		Indicates whether this field is marked as important and prominently displayed.
IndexVisibleFlag	Boolean	True		Indicates whether the field is visible in the organizations list view.
Key [KEY]	String	True		The unique machine-readable key that identifies this field in API requests and responses.
LastUpdatedByUserId	String	True		The identifier of the user who last updated this field definition.
MandatoryFlag	Boolean	True		Indicates whether this field is required when creating or updating an organization.
Name	String	False		Name of the field.
Options	String	False		The selectable options for enum and set field types, returned as a JSON array.
OrderNr	Integer	True		The display order position of this field relative to other fields.
SearchableFlag	Boolean	True		Indicates whether this field is included in organization search results.
SortableFlag	Boolean	True		Indicates whether the organizations list can be sorted by this field.
UpdateTime	Datetime	True		The date and time when the field definition was last updated.