Attachments

Provides access to issue attachments in Jira. Supports querying, inserting, and deleting file attachments associated with issues.

Table-Specific Information

SELECT

The component uses the Jira API to process filters based on the Id, IssueId, IssueKey, ProjectId, ProjectName, and JQL columns. The component processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM Attachments WHERE Id = 10003;
SELECT * FROM Attachments WHERE IssueId = 123;
SELECT * FROM Attachments WHERE ProjectId = 10100;
SELECT * FROM Attachments WHERE JQL = 'created > 2018-01-07';

INSERT

Insert an attachment by specifying the IssueKey and either a FilePath or ContentEncoded content with a Name.

INSERT INTO Attachments (FilePath, IssueKey) VALUES ('C:/Users/User/Desktop/info.txt', 'SSFSF-1');
INSERT INTO Attachments (ContentEncoded, Name, IssueKey) VALUES ('U29tZSBjb250ZW50IGhlcmU=', 'Uploaded File', 'SSFSF-1');

DELETE

Delete an attachment by specifying the Id.

DELETE FROM Attachments WHERE Id = 10003;

Columns


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	Integer	False			Common	The unique numeric identifier of the attachment within the Jira system.
IssueId [KEY]	Integer	False	Issues.Id	=,!=,IN,NOT IN	Common	The internal identifier of the issue that the attachment is associated with.
IssueKey	String	False	Issues.Key	=,!=,IN,NOT IN	Common	The unique key that identifies the issue related to the attachment, such as 'JIRA-101'.
ProjectId	Integer	True	Projects.Id	=,IS,IS NOT,IN,NOT IN	Common	The numeric identifier of the project that contains the issue to which the attachment is linked.
ProjectName	String	True		=,IS,IS NOT,IN,NOT IN	Common	The name of the project that includes the issue where this attachment was added.
IssueCreatedDate	Datetime	True		=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp indicating when the issue associated with this attachment was originally created.
IssueUpdatedDate	Datetime	True		=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp of the most recent update to the issue related to this attachment.
Filename	String	False			Common	The original name of the uploaded file, including the file extension.
AuthorName	String	False			Server	The username of the user who uploaded the attachment.
AuthorDisplayName	String	False	Users.DisplayName		Common	The full display name of the user who uploaded the attachment, typically shown in the Jira UI.
Created	Datetime	True			Common	The date and time when the attachment was added to the issue.
Size	Integer	False			Common	The total file size of the attachment, in bytes.
MimeType	String	False			Common	The Multipurpose Internet Mail Extensions (MIME) type of the file, used to indicate the file format such as 'application/pdf' or 'image/jpeg'.
Content	String	False			Common	The direct Uniform Resource Identifier (URI) to access or download the full content of the attachment from Jira.
Thumbnail	String	False			Common	The URI to a smaller, thumbnail version of the attachment image if available. Typically used for previews.
AuthorAccountId	String	False	Users.AccountId		Cloud	The unique account ID of the user who uploaded the attachment. This ID is consistent across the Atlassian platform.
AuthorKey	String	False			Server	An internal Jira user key that uniquely identifies the user who added the attachment.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
JQL	String	A field for specifying a Jira Query Language (JQL) expression to filter attachments by issue context when querying.
FilePath	String	The absolute path to the file on the local machine to be uploaded as an attachment. This column can only be specified in an INSERT statement; it cannot be used in the WHERE clause of a SELECT statement.
ContentEncoded	String	The content of the file to upload, encoded in BASE64 format. Used in scenarios where direct file access is not possible. This column can only be specified in an INSERT statement; it cannot be used in the WHERE clause of a SELECT statement.
Name	String	The name to assign to the uploaded file, including its extension, which appears in the issue's attachment list. This column can only be specified in an INSERT statement; it cannot be used in the WHERE clause of a SELECT statement.