Reference

Endpoint Delete Issue Comment

Name

delete_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
Response DT_NTEXT nvarchar(MAX)
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(4000) 4000
IssueId DT_WSTR nvarchar(4000) 4000
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 Source

API Source - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
Delete Issue Comment
Required Parameters
IssueId Or Key Fill-in the parameter...
Comment Id Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

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 delete 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
Delete
Required Parameters
IssueId Or Key Fill-in the parameter...
Comment Id Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete an exising Comment

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

DELETE FROM Comments WHERE Id=10004 WITH(IssueIdOrKey='CS-2')

delete_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:

Delete an exising Comment

This example deletes 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) = 'DELETE FROM Comments WHERE Id=10004 WITH(IssueIdOrKey=''CS-2'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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