Returns file attachments associated with help center articles, including file metadata and content 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.

This operation is allowed for logged-in users with the "agent" role, or end users who can view the associated article.

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

SELECT * FROM ArticleAttachments WHERE ArticleId = '18214155815057'

SELECT * FROM ArticleAttachments WHERE Id = '18470148791057'

SELECT * FROM ArticleAttachments WHERE Id = '18470148791057' AND Locale = 'en-us' AND ArticleId = '18214155815057'

Delete

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

DELETE FROM ArticleAttachments WHERE Id = '18460736594833'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id assigned to the article attachment when it is created.
ArticleId	Long	True	Articles.Id	The Id of the article associated with this attachment, if present.
Locale	String	True		The locale of the translation that the attachment belongs to. This value can only be set on inline attachments.
ContentType	String	True		The MIME content type of the attached file, such as image/png.
ContentUrl	String	True		The URL where the attachment file can be downloaded.
CreatedAt	Datetime	True		The date and time when the article attachment was created.
DisplayFileName	String	True		The display name of the attached file.
FileName	String	True		The file name.
Inline	Boolean	True		Indicates whether the attachment is inline. Inline attachments are image files directly embedded in the article body, and their URL can be referenced in the article HTML. If false, the attachment is listed in the attachments list. The default value is false.
RelativePath	String	True		The relative path of the attachment.
Size	Integer	True		The attachment file size in bytes.
UpdatedAt	Datetime	True		The date and time when the article attachment was last updated.
Url	String	True		The URL of the article attachment.
AttachmentsResponse	String	True		Content of the attachments.

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
Base64EncodedResponse	Boolean	Indicates whether the raw response is converted to Base64-encoded format. The default value is true.