Returns article translations, including title, body, locale, and draft 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.
• ArticleId 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 ArticleTranslations WHERE ArticleId = '19926606862236'

SELECT * FROM ArticleTranslations WHERE ArticleId = '22065790080156' and Locale = 'en-in'

Insert

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

INSERT INTO ArticleTranslations (Title, ArticleId, Locale) VALUES ('Test insert', '22065790080156', 'en-us')

Update

You must specify the Id of the article translation to update it.

UPDATE ArticleTranslations SET Title = 'Updated Title' WHERE Id = '19926592998556'

Delete

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

DELETE FROM ArticleTranslations WHERE Id = '22065790080924'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique identifier of the translation, automatically assigned when a 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.
ArticleId	Long	True	Articles.Id	The Id of the article associated with this translation.
Title	String	False		The title of the translation.
Body	String	False		The HTML body content of the translation. Empty by default.
Draft	Boolean	False		Indicates whether the translation is a draft. False by default.
HtmlUrl	String	True		The 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 has this translation. Can be 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.