Jira Connector
Documentation
Version: 11
Documentation

EndPoint Read Changelog Details


Name

get_changelog_details

Description

Returns a paginated list of all changelogs and fields updated for an issue sorted by date, starting from the oldest. OAuth scopes required: read:issue-meta:jira, read:avatar:jira, read:issue.changelog:jira

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(200) 200 False
AuthorSelfURL DT_WSTR nvarchar(1000) 1000 False
AuthorAccountId DT_WSTR nvarchar(200) 200 False
AuthorEmailAddress DT_WSTR nvarchar(500) 500 False
AvatarUrls48x48 DT_WSTR nvarchar(1000) 1000 False
AvatarUrls24x24 DT_WSTR nvarchar(1000) 1000 False
AvatarUrls16x16 DT_WSTR nvarchar(1000) 1000 False
AvatarUrls32x32 DT_WSTR nvarchar(1000) 1000 False
AuthorDisplayName DT_WSTR nvarchar(1000) 1000 False
IsAuthorActive DT_BOOL bit False
AuthorTimeZone DT_WSTR nvarchar(200) 200 False
CreatedDateTime DT_DBTIMESTAMP datetime False
Field DT_WSTR nvarchar(255) 255 False
FieldId DT_WSTR nvarchar(255) 255 False
FieldType DT_WSTR nvarchar(255) 255 False
From DT_WSTR nvarchar(4000) 4000 False
FromString DT_WSTR nvarchar(4000) 4000 False
To DT_WSTR nvarchar(4000) 4000 False
ToString DT_WSTR nvarchar(4000) 4000 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Jira Connector in API Source component to read data or in API Destination component to read/write data:

Read Changelog Details using API Source

Jira
Read Changelog Details
SSIS API Source - Read from table or endpoint

Read Changelog Details using API Destination

Jira
Read Changelog Details
SSIS API Destination - Access table or endpoint