From the API to SQL can you pull the issues transition history ?

[Rita Carnes]

I would like to pull into a SQL database the transition history of issue keys.   I need to see the status and the date it was transitioned for reporting full lifecycle of issues.   

[Warren · Accepted solution]

Hi @Rita Carnes 

If you're using the API, the server documentation should help you. This doc will jump to the API call that you could use

/rest/api/2/issue/{issueIdOrKey}

If you then add a parameter of expand=changelog, so that the call looks like

/rest/api/2/issue/{issueIdOrKey}?expand=changelog

the changelog section will give you the full history

[Rita Carnes]

Thanks!  I ended up finding documentation on it as well.