Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Read Ticket Comments


Name

get_ticket_comments

Description

Returns comments for specified ticket ID. [API reference]

Parameters

Parameter Label Required Options Description
ticket_id Ticket ID YES
sort_order Sort Order NO
Option Value
desc desc
asc asc
Sort order
include_inline_images Include inline images NO
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 Description
id DT_I8 bigint False
author_id DT_I8 bigint False
body DT_NTEXT nvarchar(MAX) False
plain_body DT_NTEXT nvarchar(MAX) False
html_body DT_NTEXT nvarchar(MAX) False
created_at DT_DBTIMESTAMP datetime False
attachments DT_WSTR nvarchar(4000) 4000 False
type DT_WSTR nvarchar(100) 100 False
public DT_BOOL bit False
attachments_1_id DT_I8 bigint False
attachments_2_id DT_I8 bigint False
attachments_3_id DT_I8 bigint False
attachments_4_id DT_I8 bigint False
attachments_5_id DT_I8 bigint False
attachments_1_file_name DT_WSTR nvarchar(255) 255 False
attachments_2_file_name DT_WSTR nvarchar(255) 255 False
attachments_3_file_name DT_WSTR nvarchar(255) 255 False
attachments_4_file_name DT_WSTR nvarchar(255) 255 False
attachments_5_file_name DT_WSTR nvarchar(255) 255 False
attachments_1_content_url DT_WSTR nvarchar(500) 500 False
attachments_2_content_url DT_WSTR nvarchar(500) 500 False
attachments_3_content_url DT_WSTR nvarchar(500) 500 False
attachments_4_content_url DT_WSTR nvarchar(500) 500 False
attachments_5_content_url DT_WSTR nvarchar(500) 500 False
via_channel DT_WSTR nvarchar(100) 100 False
via_source_rel DT_WSTR nvarchar(255) 255 False
via_source_from_address DT_WSTR nvarchar(500) 500 False
via_source_from_name DT_WSTR nvarchar(500) 500 False
via_source_from_original_recipients DT_WSTR nvarchar(2000) 2000 False
via_source_to_name DT_WSTR nvarchar(500) 500 False
via_source_to_address DT_WSTR nvarchar(500) 500 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
author_id DT_I8 bigint False
body DT_NTEXT nvarchar(MAX) False
Required columns that you need to supply are bolded.