EndPoint Read Ticket Attachments

Name

get_ticket_attachments

Description

Returns attachments for the specified Ticket ID. [API reference]

Parameters

Parameter

Label

Required

Options

Description

ticket_id

Ticket ID

YES

sort_order

Sort Order

Option	Value
desc	desc
asc	asc

Sort order

include_inline_images

Include inline images

Option	Value
false	false
true	true

Default is false. When true, inline images are also listed as attachments in the response

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		`False`
file_name	`DT_WSTR`	`nvarchar(255)`	255	`False`
content_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
mapped_content_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
content_type	`DT_WSTR`	`nvarchar(255)`	255	`False`
size	`DT_I4`	`int`		`False`
width	`DT_I4`	`int`		`False`
height	`DT_I4`	`int`		`False`
inline	`DT_BOOL`	`bit`		`False`
deleted	`DT_BOOL`	`bit`		`False`
thumbnails	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
comment_id	`DT_I8`	`bigint`		`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Read Ticket Attachments using API Source

Zendesk

Read Ticket Attachments

SSIS API Source - Read from table or endpoint

Read Ticket Attachments using API Destination

Zendesk

Read Ticket Attachments

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get all attachment urls for a specific ticket

SELECT * FROM get_ticket_attachments
WITH(
	  ticket_id='104351'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get all attachment urls for a specific ticket

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_ticket_attachments
WITH(
	  ticket_id=''104351''
)';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_ZENDESK_IN_DATA_GATEWAY];