The below ability to set custom transaction progress could help in determining the transactions last status. Then using the Orchestrator native get-transaction to get the transaction progress would get you what you need. Have a similar need here and working on using these two solutions together.
Set Custom Transaction Process
Turns out you do not need to use the API interface for the progress status. This is native in get-transaction under the .progress element.