JDBC Driver for Zendesk

Build 23.0.8839

Attributes

Create, Update, Delete and Query the Attributes in Zendesk. An attribute in Zendesk refers to a skill type. Skill types are categories of skills.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM Attributes
SELECT * FROM Attributes WHERE Id = 'd5e889c8-6364-11ee-8493-6361d728a3c9'

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 field is required to insert. Allowed for agents.

INSERT INTO Attributes (Name) VALUES ('Test')

Update

You must specify the Id of the Attribute to update. Allowed for admins.

UPDATE Attributes SET Name = 'CData' WHERE Id = 'd5e889c8-6364-11ee-8493-6361d728a3c9'

Delete

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

DELETE FROM Attributes WHERE Id = 'db70666a-6364-11ee-bfc8-7f3b952deb2c'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Automatically assigned when an attribute is created.

Name String False

The name of the attribute.

url String True

URL of the attribute.

CreatedAt Datetime True

When this record was created.

UpdatedAt Datetime True

When this record was last updated.

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