JDBC Driver for Zendesk

Build 20.0.7587


Create, delete, and query Organization Memberships in Zendesk.

Table Specific Information


The following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM OrganizationMemberships

SELECT * FROM OrganizationMemberships WHERE Id = '123'

SELECT * FROM OrganizationMemberships WHERE UserId = '123'

SELECT * FROM OrganizationMemberships WHERE OrganizationId = '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 The UserId and OrganizationId fields are required to insert (assigns a user to a given organization). Allowed for agents.

INSERT INTO OrganizationMemberships(UserId, OrganizationId) VALUES('772', '881')


You must specify the Id of the membership to delete it. Allowed for admins.

DELETE FROM OrganizationMemberships WHERE Id='123'


Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned when the membership is created.

OrganizationId Long False

The ID of the organization associated with this user, in this membership.

UserId Long False

The ID of the user for whom this memberships belongs.

Default Boolean False

Denotes whether this is the default organization membership for the user. If false, returns null.

CreatedAt Datetime True

When this record was created.

UpdatedAt Datetime True

When this record last got updated.

Url String True

The url of this resource.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587