Returns article labels used to categorize and organize help center articles.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM ArticleLabels WHERE Id = '10552059820828'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756' AND Locale = 'en-us'

Insert

The ArticleId and Name columns are required to insert. All fields that are not readonly are optional. This operation is allowed for logged-in users with the "agents" role.

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

Delete

You must specify the Id of the article label to delete it. This operation is allowed for logged-in users with the "agents" role.

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		The Id automatically assigned to the label when it is created.
Name	String	False		The actual name of the label.
CreatedAt	Datetime	True		The date and time when the label was created.
UpdatedAt	Datetime	True		The date and time when the label was last updated.
Url	String	True		The API URL of the label.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
ArticleId	Long	The unique Id of the article associated with this label.
Locale	String	The locale the item is displayed in.