EndPoint Read Ticket Comments
Name
get_ticket_comments
Description
Returns comments for specified ticket ID. [API reference]
Parameters
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.