DownloadAttachment
Downloads an attachment from Jira by specifying the attachment's unique ID.
Stored Procedure-Specific Information
To execute this procedure, enter:
EXEC DownloadAttachment AttachmentId='10001', FileLocation='C:\\downloads\\my_file.txt'
Input
| Name | Type | Required | Description |
| AttachmentId | String | True | The unique identifier of the Jira attachment to download. This ID is required to retrieve the correct file. |
| FileLocation | String | False | The local file system path where the downloaded attachment should be saved. This can be an absolute or relative path. |
| FileName | String | False | The name to assign to the downloaded file. If left blank, the file will retain its original name as it appears in Jira. |
| Overwrite | String | False | If set to 'true', any existing file at the target location will be overwritten. If 'false', the operation will fail if the file already exists. Default is 'false'. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the attachment was successfully downloaded. Returns 'true' if successful, or 'false' if an error occurred. |
| FileData | String | The contents of the downloaded file encoded in Base64 format. Only returned when FileLocation and FileStream are not provided. |