JDBC Driver for Zendesk

Build 24.0.8963

ManagementPermissionGroups

Create, Update, Delete and Query the Management Permission Groups in Zendesk. A management permission group defines which agents can create, update, archive, and publish articles. It consists of a set of privileges, each of which is mapped to a user segment. Agents receive whichever privileges are associated with the user segments they belong to.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM ManagementPermissionGroups
SELECT * FROM ManagementPermissionGroups WHERE Id = '19162149101585'

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 Name column is required to insert. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.

INSERT INTO ManagementPermissionGroups (Name, Edit) VALUES ('Test', '19162093613969, 19236810082193')

Update

You must specify the Id of the ManagementPermissionGroup to update. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.

UPDATE ManagementPermissionGroups SET Name = 'UpdatedName' WHERE Id = '19239392699537'

Delete

You must specify the Id of the ManagementPermissionGroup to delete it. Allowed for Help Center managers.

DELETE FROM ManagementPermissionGroups WHERE Id = '19239392699537'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the permission group is created.

BuiltIn Boolean True

Whether the permission group is built-in. Built-in permission groups cannot be modified.

Name String False

Permission group name.

Edit String False

The ids of user segments that have edit privileges. For insertion and updation provide these values separated by comma.

Publish String False

The ids of user segments that have publish privileges. For insertion and updation provide these values separated by comma.

CreatedAt Datetime True

When the permission group was created.

UpdatedAt Datetime True

When the permission group was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963