Click here to Skip to main content
15,749,184 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
For our day-to-day operations at the office we use Azure DevOps to keep track of the Scrum artifacts and the activities. Working in the UAT team, each member is assigned to a different scrum team and they show up on DevOps as such, but for reporting purposes, I have created a separate query to pull the entered bugs and hours burned for each individual separately. I pull that data, put it into excel and then send it out via email as a report to the management. Is there a way I can automate the whole process?
Ideally I would like this report pulled, visualized (I can try in C# to have this done in excel but I havent gotten that far) and then sent out to the management.
I am looking for some guidance as to where to start or what to look for?

What I have tried:

I can programmatically access Azure DevOps and create work items. I have been following this guide:
Use REST APIs to access Azure DevOps (formerly VSTS) | DotNetCurry[^]
I am running into the issue that this guide talks about creating a WIQL query, but since I am using the web version of DevOps I can't find the option to extract the WIQL for the created query. Any help would be greatly appreciated.
Updated 9-Oct-19 19:42pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900