TDV Adapter for Zendesk

Build 21.0.8137


Create, delete, and query Group Memberships in Zendesk.

Table Specific Information


The 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'


Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the ticket is created.

UserId Long False


The id of an agent.

GroupId Long False


The id of a group.

Default Boolean False

If true, tickets assigned directly to the agent will assume this membership's group.

CreatedAt Datetime True

The time the membership was created.

UpdatedAt Datetime True

The time of the last update of the membership.

Url String True

The API url of this record.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137