Groups
Create, update, delete, and query Groups in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM Groups WHERE Id = '123' SELECT * FROM Groups WHERE UserId = '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.
Insert
The Name field is required to insert. Allowed for admins.
INSERT INTO Groups (Name) VALUES ('My Group')
Update
You must specify the Id of the group to update it. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.
UPDATE Groups SET Name = 'Interesting Group' WHERE Id = '123'
Delete
You must specify the Id of the group to delete it. Note that you cannot delete the default group of the account. Allowed for admins.
DELETE FROM Groups WHERE Id = '123'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Automatically assigned when the ticket is created. | |
Name | String | False |
The name of the group. | |
CreatedAt | Datetime | True |
The time the group was created. | |
UpdatedAt | Datetime | True |
The time of the last update of the group. | |
Deleted | Boolean | True |
Deleted groups get marked as such. | |
Url | String | True |
The API url of this group. | |
UserId | Long | False |
The user id used to query groups |