EndPoint Create Worklog

Contents

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

Name

create_worklog

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
IssueIdOrKey	IssueIdOrKey	NO		Enter Issue ID or Key

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(50)`	50	False
IssueId	`DT_WSTR`	`nvarchar(50)`	50	False
Self	`DT_WSTR`	`nvarchar(150)`	150	False
AuthorSelf	`DT_WSTR`	`nvarchar(150)`	150	False
AuthorAccountId	`DT_WSTR`	`nvarchar(100)`	100	False
AuthorEmailAddress	`DT_WSTR`	`nvarchar(100)`	100	False
AuthorDisplayName	`DT_WSTR`	`nvarchar(200)`	200	False
AuthorIsActive	`DT_BOOL`	`bit`		False
AuthorTimeZone	`DT_WSTR`	`nvarchar(50)`	50	False
AuthorAccountType	`DT_WSTR`	`nvarchar(50)`	50	False
CommentFormatted	`DT_NTEXT`	`nvarchar(MAX)`		False
Comment	`DT_NTEXT`	`nvarchar(MAX)`		False	Join formatted text blocks using space separator (new lines will be lost)
UpdateAuthorSelf	`DT_WSTR`	`nvarchar(150)`	150	False
UpdateAuthorAccountId	`DT_WSTR`	`nvarchar(150)`	150	False
UpdateAuthorEmailAddress	`DT_WSTR`	`nvarchar(100)`	100	False
UpdateAuthorDisplayName	`DT_WSTR`	`nvarchar(50)`	50	False
UpdateAuthorActive	`DT_BOOL`	`bit`		False
UpdateAuthorTimeZone	`DT_WSTR`	`nvarchar(50)`	50	False
UpdateAuthorAccountType	`DT_WSTR`	`nvarchar(50)`	50	False
Created	`DT_DBTIMESTAMP`	`datetime`		False
Updated	`DT_DBTIMESTAMP`	`datetime`		False
Started	`DT_DBTIMESTAMP`	`datetime`		False
TimeSpent	`DT_WSTR`	`nvarchar(50)`	50	False
TimeSpentInSeconds	`DT_I8`	`bigint`		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
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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
VisibilityType	`DT_WSTR`	`nvarchar(4000)`	4000	False	Enter 'group' or 'role'
VisibilityValue	`DT_WSTR`	`nvarchar(4000)`	4000	False	The name of the group or role to which visibility of this item is restricted.
Comment	`DT_NTEXT`	`nvarchar(MAX)`		True
CommentFormatted	`DT_NTEXT`	`nvarchar(MAX)`		True
StartedAt	`DT_WSTR`	`nvarchar(100)`	100	False	Datetime with timezone
TimeSpent	`DT_WSTR`	`nvarchar(50)`	50	False	Defines a time spent in hours and minutes
TimeSpentInSeconds	`DT_I8`	`bigint`		False	Defines a time spent in seconds

Required columns that you need to supply are bolded.