JDBC Driver for Zendesk

Build 22.0.8462

Attachments

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 driver.
SELECT * FROM Attachments

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462