Create, delete, and query Group Memberships in Zendesk.
Table Specific Information
SelectThe following queries are processed server side while other filters are processed client side within the adapter.
SELECT * FROM GroupMemberships SELECT * FROM GroupMemberships WHERE Id = '123' SELECT * FROM GroupMemberships WHERE UserId = '123' SELECT * FROM GroupMemberships WHERE GroupId = '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 UserId and GroupId fields are required to insert (assigns an agent to a given group). Allowed for admins.
INSERT INTO GroupMemberships(UserId, GroupId) VALUES('72', '88')
You must specify the Id of the membership to delete it (immediately removes a user from a group and schedules a job to unassign all working tickets that are assigned to the given user and group combination). Allowed for admins.
DELETE FROM GroupMemberships WHERE Id='123'
Automatically assigned when the ticket is created.
The id of an agent.
The id of a group.
If true, tickets assigned directly to the agent will assume this membership's group.
The time the membership was created.
The time of the last update of the membership.
The API url of this record.