OrganizationFields
Returns data about all organization fields.
Select
The server uses the Pipedrive API to apply WHERE clause conditions with the supported columns and operators listed below. It processes all other filters client-side within the server.
- Id supports the '=' operator.
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 field. | |
| ActiveFlag | Boolean | True |
Indicates whether the field is currently active. | |
| AddTime | Datetime | True |
The time when the field was created. | |
| AddVisibleFlag | Boolean | False |
Indicates whether the field is shown in the 'Add New Organization' modal. The default value is true. | |
| BulkEditAllowed | Boolean | True |
Indicates whether the field supports bulk editing. | |
| DetailsVisibleFlag | Boolean | True |
Indicates whether the field is visible in the details view. | |
| EditFlag | Boolean | True |
Indicates whether the field can be edited. | |
| FieldType | String | False |
The type of field to create. 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 the field can be used in filters. | |
| ImportantFlag | Boolean | True |
Indicates whether the field is marked as important. | |
| IndexVisibleFlag | Boolean | True |
Indicates whether the field is visible in list views. | |
| Key | String | True |
The unique key identifier used to reference the field. | |
| LastUpdatedByUserId | String | True |
The user ID of the person who last updated the field. | |
| MandatoryFlag | Boolean | True |
Indicates whether the field is required when adding or updating records. | |
| Name | String | False |
The name of the custom field. | |
| Options | String | False |
The options available for the field. | |
| OrderNr | Integer | True |
The display order number of the field. | |
| SearchableFlag | Boolean | True |
Indicates whether the field is searchable. | |
| SortableFlag | Boolean | True |
Indicates whether the field can be used for sorting. | |
| UpdateTime | Datetime | True |
The time when the field was last updated. |