I would like to generate a list of work items (User Stories, Defects, Tasks) that include the following for each:
|US35239||ScheduleState||Backlog||8/31/2017 8:08||11/27/2017 1:46|
|US35239||ScheduleState||Defined||11/27/2017 1:46||12/4/2017 5:20|
|US35239||ScheduleState||In-Progress||12/4/2017 5:20||12/11/2017 7:43|
|US35239||ScheduleState||Completed||12/11/2017 7:43||12/12/2017 8:08|
I have been unsucessful creating this through the Excel Add-In and I am getting lost quickly in the lookback API document as I couldn't find any relevant query examples there either.
I know this can be accomplished directly through agile central using the custom page "Cycle Time Data App" but I would rather not have to pull in that specific data out of Agile Central when everything else i need comes directly from the Ecxel Add In.
Any assistance would be greatly appreciated.