Reference

Endpoint Update Worklog

Name

update_worklog

Description

No description available

Related Tables

Worklogs

Parameters

Parameter Required Options
Name: IssueIdOrKey

Label: IssueIdOrKey
Name: WorklogId

Label: WorklogId

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(50) 50
IssueId DT_WSTR nvarchar(50) 50
Self DT_WSTR nvarchar(150) 150
AuthorSelf DT_WSTR nvarchar(150) 150
AuthorAccountId DT_WSTR nvarchar(100) 100
AuthorEmailAddress DT_WSTR nvarchar(100) 100
AuthorDisplayName DT_WSTR nvarchar(200) 200
AuthorIsActive DT_BOOL bit
AuthorTimeZone DT_WSTR nvarchar(50) 50
AuthorAccountType DT_WSTR nvarchar(50) 50
CommentFormatted DT_NTEXT nvarchar(MAX)
Comment DT_NTEXT nvarchar(MAX) Join formatted text blocks using space separator (new lines will be lost)
UpdateAuthorSelf DT_WSTR nvarchar(150) 150
UpdateAuthorAccountId DT_WSTR nvarchar(150) 150
UpdateAuthorEmailAddress DT_WSTR nvarchar(100) 100
UpdateAuthorDisplayName DT_WSTR nvarchar(50) 50
UpdateAuthorActive DT_BOOL bit
UpdateAuthorTimeZone DT_WSTR nvarchar(50) 50
UpdateAuthorAccountType DT_WSTR nvarchar(50) 50
Created DT_DBTIMESTAMP datetime
Updated DT_DBTIMESTAMP datetime
Started DT_DBTIMESTAMP datetime
TimeSpent DT_WSTR nvarchar(50) 50
TimeSpentInSeconds DT_I8 bigint
AuthorAvatarUrls48x48 DT_WSTR nvarchar(500) 500
AuthorAvatarUrls24x24 DT_WSTR nvarchar(500) 500
AuthorAvatarUrls16x16 DT_WSTR nvarchar(500) 500
AuthorAvatarUrls32x32 DT_WSTR nvarchar(500) 500
UpdateAuthorAvatarUrls48x48 DT_WSTR nvarchar(500) 500
UpdateAuthorAvatarUrls24x24 DT_WSTR nvarchar(500) 500
UpdateAuthorAvatarUrls16x16 DT_WSTR nvarchar(500) 500
UpdateAuthorAvatarUrls32x32 DT_WSTR nvarchar(500) 500
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
VisibilityType DT_WSTR nvarchar(4000) 4000 Enter 'group' or 'role'
VisibilityValue DT_WSTR nvarchar(4000) 4000 The name of the group or role to which visibility of this item is restricted.
Comment DT_NTEXT nvarchar(MAX)
CommentFormatted DT_NTEXT nvarchar(MAX)
StartedAt DT_WSTR nvarchar(100) 100 Datetime with timezone
TimeSpent DT_WSTR nvarchar(50) 50 Defines a time spent in hours and minutes
TimeSpentInSeconds DT_I8 bigint Defines a time spent in seconds
Id DT_STR varchar(50) 50
Required columns that you need to supply are bolded.

Examples

SSIS

Use Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the Worklogs table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update worklog:

API Destination - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
Worklogs
Update
Optional Parameters
IssueIdOrKey
WorklogId
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

UPDATE Worklog

Updates a worklog 

UPDATE Worklogs
SET TimeSpentInSeconds = 28800
   ,Comment='My Comment!'
   ,StartedAt='2020-01-23T16:20:30.123+0000'
WITH (IssueIdOrKey='MTK-1', WorklogId='123465', OUTPUT=1, ContinueOn404Error=0)

update_worklog endpoint belongs to Worklogs table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

UPDATE Worklog

Updates a worklog 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Worklogs
SET TimeSpentInSeconds = 28800
   ,Comment=''My Comment!''
   ,StartedAt=''2020-01-23T16:20:30.123+0000''
WITH (IssueIdOrKey=''MTK-1'', WorklogId=''123465'', OUTPUT=1, ContinueOn404Error=0)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

update_worklog endpoint belongs to Worklogs table(s), and can therefore be used via those table(s).