EndPoint Update Issue Comment

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

update_comment

Description

No description available

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
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.