Reference

Endpoint Update Issue Comment

Name

update_comment

Description

No description available

Related Tables

Comments

Parameters

Parameter	Required	Options
Name: IssueIdOrKey Label: IssueId Or Key	YES
Name: CommentId Label: Comment Id	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Description
Id	`DT_WSTR`	`nvarchar(20)`	20
Created	`DT_DBTIMESTAMP`	`datetime`
Updated	`DT_DBTIMESTAMP`	`datetime`
Self	`DT_WSTR`	`nvarchar(150)`	150
BodyType	`DT_WSTR`	`nvarchar(50)`	50
BodyContent	`DT_NTEXT`	`nvarchar(MAX)`
BodyContentText	`DT_NTEXT`	`nvarchar(MAX)`		Join formatted text blocks using space separator (new lines will be lost)
BodyVersion	`DT_NUMERIC`	`decimal(18,5)`
AuthorSelf	`DT_WSTR`	`nvarchar(150)`	150
AuthorAccountId	`DT_WSTR`	`nvarchar(100)`	100
AuthorEmailAddress	`DT_WSTR`	`nvarchar(100)`	100
AuthorAvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500
AuthorAvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500
AuthorAvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500
AuthorAvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500
AuthorDisplayName	`DT_WSTR`	`nvarchar(100)`	100
AuthorActive	`DT_BOOL`	`bit`
AuthorTimeZone	`DT_WSTR`	`nvarchar(100)`	100
AuthorAccountType	`DT_WSTR`	`nvarchar(50)`	50
UpdateAuthorSelf	`DT_WSTR`	`nvarchar(150)`	150
UpdateAuthorAccountId	`DT_WSTR`	`nvarchar(50)`	50
UpdateAuthorEmailAddress	`DT_WSTR`	`nvarchar(100)`	100
UpdateAuthorAvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500
UpdateAuthorAvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500
UpdateAuthorAvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500
UpdateAuthorAvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500
UpdateAuthorDisplayName	`DT_WSTR`	`nvarchar(100)`	100
UpdateAuthorActive	`DT_BOOL`	`bit`
UpdateAuthorTimeZone	`DT_WSTR`	`nvarchar(44)`	44
UpdateAuthorAccountType	`DT_WSTR`	`nvarchar(36)`	36
jsdPublic	`DT_BOOL`	`bit`

If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_WSTR`	`nvarchar(4000)`	4000
IssueId	`DT_WSTR`	`nvarchar(4000)`	4000
Body	`DT_NTEXT`	`nvarchar(MAX)`
BodyFormatted	`DT_NTEXT`	`nvarchar(MAX)`

Required columns that you need to supply are bolded.

Examples

SSIS

Use Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the Comments table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update issue comment:

API Destination - Jira

Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details

Jira

Comments

Update

Required Parameters
IssueId Or Key	Fill-in the parameter...
Comment Id	Fill-in the parameter...

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update an exising Comment (Plain Text Body)

This example updates an exising comment for a given Issue Id and Comment Id. You can use Issue Key or Id as an input value.

UPDATE Comments
 SET Body='Updated at <<FUN_NOW>>'
WHERE Id=10004
WITH(IssueIdOrKey='CS-2')

update_comment endpoint belongs to Comments table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Update an exising Comment (Plain Text Body)

This example updates an exising comment for a given Issue Id and Comment Id. You can use Issue Key or Id as an input value.

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Comments
 SET Body=''Updated at <<FUN_NOW>>''
WHERE Id=10004
WITH(IssueIdOrKey=''CS-2'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

update_comment endpoint belongs to Comments table(s), and can therefore be used via those table(s).