Returns translations for help center categories, including title, body, locale, and status details.

Table-Specific Information

Select

The provider uses the Zendesk API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = operator.
• CategoryId supports the = operator.
• Locale supports the = operator.

For example, the following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM CategoryTranslations WHERE CategoryId = '30235858541586'

SELECT * FROM CategoryTranslations WHERE CategoryId = '30235858541586' and Locale = 'en-us'

Insert

The following columns are required to insert: Title, CategoryId, and Locale.

INSERT INTO CategoryTranslations (Title, CategoryId, Locale) VALUES ('General', '10101763925020', 'en-us')

Update

The following is an example of how to update the CategoryTranslations table:

UPDATE CategoryTranslations SET Title = 'Updated Title' WHERE Id = '23236975085596'

Delete

You must specify the Id of the category translation to delete it.

DELETE CategoryTranslations WHERE Id = '23787288298652'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id automatically assigned when the translation is created.
CreatedById	Long	True		The Id of the user who created the translation.
UpdatedById	Long	True		The Id of the user who last updated the translation.
CategoryId	Long	True	Categories.Id	The Id of the category that contains this translation.
Title	String	False		The title of the translation.
Body	String	False		HTML body of the translation. Empty by default.
Draft	Boolean	False		Indicates whether the translation is a draft. False by default.
HtmlUrl	String	True		The HTML URL of the translation in Help Center.
Locale	String	False		The locale of the translation.
Outdated	Boolean	False		Indicates whether the translation is outdated. False by default.
SourceType	String	True		The type of the item that contains this translation, such as article, section, or category.
Url	String	True		The API URL of the translation.
CreatedAt	Datetime	True		The date and time when the translation was created.
UpdatedAt	Datetime	True		The date and time when the translation was last updated.