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 |
If the column you are looking for is missing, consider customizing Jira Connector.
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

Read Changelog Details using API Destination
Jira
Read Changelog Details

ODBC application
Use these SQL queries in your ODBC application data source:
Read changelog details
SELECT * FROM get_changelog_details
WITH
(
"IssueIdOrKey" = 'abcd-1234-issueidorkey'
)
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Read changelog details
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_changelog_details
WITH
(
"IssueIdOrKey" = ''abcd-1234-issueidorkey''
)';
EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];