Extract Release Start Date (Fix Version Start Date)

[Kesarwani.Anurag]

We are using the REST API and Alteryx to extract data from Jira.

We are looking for a column which contains the info of Release Start Date (Fix Version Start Date). We have found Fix Version Name and Release Date (Release End Date)

Please help us to locate the Release Start Date (Fix Version Start Date) in the extracts.

[Andy Heinzer · Accepted solution]

Hi,

I see you are looking to find the start date of a version or release from Jira Software via the REST API.  This is something you can get back if you call the endpoint GET /rest/api/2/project/{projectIdOrKey}/versions.  This call returns all the versions that exist in the project queried.   For each version, it's possible there is a startDate value that represents the date that version / release was started.

Note: This is an optional field.  I usually don't find that admins fill this specific field out.  I suppose it's because the release date tends to be far more important than the actual start date in most cases.  Hence if Jira doesn't have a value for this field on that version, then the REST API won't even return the field in the json output for those version entries.  You can see from my example one here:

{"self":"https://[example].atlassian.net/rest/api/2/project/SCRUM/version?maxResults=50&startAt=0","maxResults":50,"startAt":0,
"total":3,"isLast":true,"values":[
{"self":"https://[example].atlassian.net/rest/api/2/version/10000","id":"10000","name":"Version 1.0","archived":false,"released":true,"startDate":"2017-05-01","releaseDate":"2017-07-17","userStartDate":"30/Apr/17","userReleaseDate":"16/Jul/17","projectId":10000},
{"self":"https://[example].atlassian.net/rest/api/2/version/10001","id":"10001","name":"Version 2.0","archived":false,"released":false,"releaseDate":"2017-07-31","overdue":true,"userReleaseDate":"30/Jul/17","projectId":10000},
{"self":"https://[example].atlassian.net/rest/api/2/version/10002","id":"10002","name":"Version 3.0","archived":false,"released":false,"projectId":10000
}]}

I only have 3 versions in this SCRUM project and only 'Version 1.0' has a start date.  The other versions do not have this startDate defined at all.   You can see the Version 1.0 start date value in REST is "startDate":"2017-05-01"

I hope this helps.

Andy