Returns translations for Help Center sections, including locale, title, body, 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.
• SectionId 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 SectionTranslations WHERE SectionId = 19327015862300

SELECT * FROM SectionTranslations WHERE SectionId = 19327015862300 AND Locale = 'en-us'

Insert

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

INSERT INTO SectionTranslations(Title, SectionId, Locale) VALUES('General', 19327015859356, 'en-in')

You can also optionally include the Body column:

INSERT INTO SectionTranslations(Title, SectionId, Locale, Body) VALUES('General', 19327015859356, 'en-in', 'Sample body data')

Update

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

UPDATE SectionTranslations SET Title = 'Updated Title by Id' WHERE Id = '17225617630108'

Delete

You must specify the Id of the section translation to delete.

DELETE FROM SectionTranslations WHERE Id = '19326991711516'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id automatically assigned to the translation upon creation.
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.
SectionId	Long	True	Sections.Id	The Id of the section that has this translation.
Title	String	False		The title of the translation.
Body	String	False		The 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 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, such as article, section, or category.
Url	String	True		The API URL of the translation.
CreatedAt	Datetime	True		The time at which the translation was created.
UpdatedAt	Datetime	True		The time at which the translation was last updated.