CreateTicketComment
Creates a new comment on the specified ticket.
Stored Procedure-Specific Information
Attach only one file with the comment:EXECUTE CreateTicketComment @Id='23', @Body='Comment text body.', @Public=true, @Attachments='C:/Example/profilephoto.png'
Attach all files within the first level of a directory (directories nested within the specified directory are ignored):
EXECUTE CreateTicketComment @Id='23', @Body='Comment text body.', @Public=true, @Attachments='C:/Example/MyDirectory/'
Attach a combination of multiple files and folders with the comment using a temp table:
INSERT INTO attach#TEMP (Attachments) VALUES ('C:/Example/MyDirectory/')
INSERT INTO attach#TEMP (Attachments) VALUES ('C:/Example/Desktop/data.csv')
EXECUTE CreateTicketComment @Id='23', @Body='Comment text body.', @Public=true, @Attachments=attach#TEMP
Input
| Name | Type | Required | Description |
| Id | String | True | The Id of the ticket on which to create the comment. |
| Body | String | True | The text body of the comment. |
| Public | String | False | Indicates whether the comment is public. Defaults to true. |
| Attachments | String | False | The attachment file path, or temp table of file paths, to include with the comment. |
| FileStream | String | False | The content as InputStream to be uploaded when Attachments is not specified. |
| FileName | String | False | The name of the file. Used only when FileStream is not empty. |
Result Set Columns
| Name | Type | Description |
| Success | String | Returns true if the comment is created successfully. |
| CommentId | String | The Id of the created comment. |