EndPoint Update Issue Comment
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
IssueIdOrKey | IssueId Or Key | YES | ||
CommentId | Comment Id | YES |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(20)
|
20 | False |
|
Created |
DT_DBTIMESTAMP
|
datetime
|
False |
||
Updated |
DT_DBTIMESTAMP
|
datetime
|
False |
||
Self |
DT_WSTR
|
nvarchar(150)
|
150 | False |
|
BodyType |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
BodyContent |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
BodyContentText |
DT_NTEXT
|
nvarchar(MAX)
|
False |
Join formatted text blocks using space separator (new lines will be lost) | |
BodyVersion |
DT_NUMERIC
|
decimal(18,5)
|
False |
||
AuthorSelf |
DT_WSTR
|
nvarchar(150)
|
150 | False |
|
AuthorAccountId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
AuthorEmailAddress |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
AuthorAvatarUrls48x48 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AuthorAvatarUrls24x24 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AuthorAvatarUrls16x16 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AuthorAvatarUrls32x32 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AuthorDisplayName |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
AuthorActive |
DT_BOOL
|
bit
|
False |
||
AuthorTimeZone |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
AuthorAccountType |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
UpdateAuthorSelf |
DT_WSTR
|
nvarchar(150)
|
150 | False |
|
UpdateAuthorAccountId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
UpdateAuthorEmailAddress |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
UpdateAuthorAvatarUrls48x48 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
UpdateAuthorAvatarUrls24x24 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
UpdateAuthorAvatarUrls16x16 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
UpdateAuthorAvatarUrls32x32 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
UpdateAuthorDisplayName |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
UpdateAuthorActive |
DT_BOOL
|
bit
|
False |
||
UpdateAuthorTimeZone |
DT_WSTR
|
nvarchar(44)
|
44 | False |
|
UpdateAuthorAccountType |
DT_WSTR
|
nvarchar(36)
|
36 | False |
|
jsdPublic |
DT_BOOL
|
bit
|
False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
IssueId |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
Body |
DT_NTEXT
|
nvarchar(MAX)
|
True |
||
BodyFormatted |
DT_NTEXT
|
nvarchar(MAX)
|
True |
Required columns that you need to supply are bolded.
Examples
SSIS
Use Jira Connector in API Source component to read data or in API Destination component to read/write data:
Update rows in Comments table using API Destination
This EndPoint belongs to Comments table, therefore you cannot work with it directly. Use this table and table-operation pair instead:
Jira
Comments
Update
