EndPoint Update Worklog

Name

update_worklog

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
IssueIdOrKey	IssueIdOrKey	NO
WorklogId	WorklogId	NO

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
Id	`DT_STR`	`varchar(50)`	50	`False`

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 Worklogs table using API Destination

This EndPoint belongs to Worklogs table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Jira

Worklogs

Update