Create, update, delete, and query Organization Fields in Zendesk.
Table Specific Information
SelectThe following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM OrganizationFields SELECT * FROM OrganizationFields WHERE Id = '123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
The Type, Title, and Key fields are required to insert. The types of custom fields that can be created are the following: text (default when no Type is specified), textarea, checkbox, date, integer, decimal, and regex (when Type is regex, RegexpForValidation is required too). Allowed for admins.
INSERT INTO OrganizationFields(Type, Title, Key) VALUES('text', 'Support description', 'support_description')
You must specify the Id of the organization field to update. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.
UPDATE OrganizationFields SET Title='Updated title' WHERE Id='123'
You must specify the Id of the organizational field to delete it. Allowed for admins.
DELETE FROM OrganizationFields WHERE Id='123'
Automatically assigned upon creation.
A unique key that identifies this custom field. Required on create.This is used for updating the field and referencing in placeholders. After a field is created, you cannot change its key.
Type of the custom field: checkbox, date, decimal, dropdown, integer, regexp, text, or textarea. After a field is created, you cannot change its type.
The title of the custom field.
The dynamic content placeholder, if present, or the title value, if not.
User-defined description of this field s purpose.
The dynamic content placeholder, if present, or the description value, if not.
Ordering of the field relative to other fields.
If true, this field is available for use.
If true, only active and position values of this field can be changed.
Regular expression field only. The validation pattern for a field value to be deemed valid..
The time the ticket field was created.
The time of the last update of the ticket field.
Optional for custom field of type checkbox; not presented otherwise.
Required and presented for a custom field of type dropdown.
The URL for this resource.