EndPoint Create Issue Comment

Contents

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

Name

create_comment

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
IssueIdOrKey	IssueId Or Key	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
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.