JDBC Driver for Zendesk

Build 20.0.7587

GroupMemberships

Create, delete, and query Group Memberships in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.
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.

Insert

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

Delete

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'

Columns

Name Type ReadOnly 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587