Returns groups, including name, membership, and status details.

Table-Specific Information

Select

The provider uses the Zendesk API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = operator.
• UserId supports the = operator.
• CreatedAt supports the =, >, <, >=, <= operators.
• UpdatedAt supports the =, >, <, >=, <= operators.

For example, the following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Groups WHERE Id = '123'

SELECT * FROM Groups WHERE UserId = '123'

SELECT * FROM Groups WHERE CreatedAt >= '2025-10-29T14:17:01.000'

SELECT * FROM Groups WHERE UpdatedAt >= '2025-10-29T14:17:01.000'

Insert

The Name column is required to insert. This operation is allowed for logged-in users with the "admin" role only.

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 are optional. This operation is allowed for logged-in users with the "admin" role only.

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. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM Groups WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the group 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		Indicates whether the group has been marked as deleted.
Url	String	True		The API URL of this group.
UserId	Long	False		The user id used to query groups.