JDBC Driver for Zendesk

Build 24.0.8963

ArticleLabels

Create, delete, and query Article Lables in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM ArticleLabels
SELECT * FROM ArticleLabels WHERE Id = '10552059820828'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756' AND Locale = 'en-us'

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 ArticleId and Name columns are required to insert. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Agents.

INSERT INTO ArticleLabels (ArticleId, Name) VALUES (10480909113756, 'Test')

Delete

You must specify the Id of the ArticleLabel to delete it. Allowed for Agents.

DELETE FROM ArticleLabels WHERE Id = '10552125680668'
DELETE FROM ArticleLabels WHERE Id = '13647939064221' AND ArticleId = '10480909113756'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the label is created.

Name String False

The actual name of the label.

CreatedAt Datetime True

The time at which the label was created.

UpdatedAt Datetime True

The time at which the label was last updated.

Url String True

The API url of this label.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ArticleId Long

The unique ID of the article.

Locale String

The locale the item is displayed in.

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