Show ticket attachments in Zendesk.

Table Specific Information

Select

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

SELECT * FROM Attachments WHERE TicketId = '123'
 
SELECT * FROM Attachments WHERE AttachmentId = '123' 

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name	Type	References	Description
AttachmentId [KEY]	Long		Automatically assigned when the ticket is created.
TicketId	Integer	Tickets.Id	The id of the ticket the comment belongs to.
CommentId	Long	TicketComments.Id	The id of the comment the attachment belongs to.
FileName	String		The name of the form.
ContentUrl	String		A full URL where the attachment image file can be downloaded.
ContentType	String		The content type of the image.
Size	Integer		The size of the image file in bytes.
Inline	Boolean		If true, the attachment is excluded from the attachment list and the attachment's URL can be referenced within the comment of a ticket. Default is false.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
UpdatedAt	Datetime		The time of the attachment was updated.