Jira Endpoint - get_worklogs - Read Worklogs | ZappySys | SSIS

EndPoint Read Worklogs

Contents

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

Name

get_worklogs

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

SearchBy

Search by

Option	Value
Project	Project
JQL	JQL
Key	Key

Project

Specify a project to search issues for

JQL

Use JQL to use an advanced mode of searching [Read more..]

Key

Issue Key(s) or Ids - Comma Separated (PRJA-10,PRJA-13)

Use comma separated IDs or Keys for Issues. 1000 ids max or JIRA internal limit for Payload.

CustomColumnsRegex

Enter regular expression for custom columns which you like to output. Use Pipe to type keys (internal names for columns). You can use Regex too (e.g. field_100\d+ )

Output Columns

Name	DataType	Length	Raw
IssueId	DT_WSTR	20	False
IssueKey	DT_WSTR	50	False
Id	DT_WSTR	20	False
Self	DT_WSTR	150	False
StartAt	DT_I4	0	False
MaxResults	DT_I4	0	False
Total	DT_I8	0	False
AuthorSelf	DT_WSTR	200	False
AuthorAccountId	DT_WSTR	150	False
AuthorEmailAddress	DT_WSTR	200	False
AuthorDisplayName	DT_WSTR	200	False
AuthorIsActive	DT_BOOL	0	False
AuthorTimeZone	DT_WSTR	100	False
AuthorAccountType	DT_WSTR	50	False
CommentFormatted	DT_NTEXT	0	False
Comment	DT_WSTR	4000	False
UpdateAuthorSelf	DT_WSTR	500	False
UpdateAuthorAccountId	DT_WSTR	200	False
UpdateAuthorEmailAddress	DT_WSTR	200	False
UpdateAuthorDisplayName	DT_WSTR	200	False
UpdateAuthorActive	DT_BOOL	0	False
UpdateAuthorTimeZone	DT_WSTR	80	False
UpdateAuthorAccountType	DT_WSTR	50	False
Created	DT_DBTIMESTAMP	0	False
Updated	DT_DBTIMESTAMP	0	False
Started	DT_DBTIMESTAMP	0	False
TimeSpent	DT_WSTR	50	False
TimeSpentInSeconds	DT_I8	0	False
AuthorAvatarUrls48x48	DT_WSTR	500	False
AuthorAvatarUrls24x24	DT_WSTR	500	False
AuthorAvatarUrls16x16	DT_WSTR	500	False
AuthorAvatarUrls32x32	DT_WSTR	500	False
UpdateAuthorAvatarUrls48x48	DT_WSTR	500	False
UpdateAuthorAvatarUrls24x24	DT_WSTR	500	False
UpdateAuthorAvatarUrls16x16	DT_WSTR	500	False
UpdateAuthorAvatarUrls32x32	DT_WSTR	500	False

Input Columns

Name	DataType	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.