Click here to Skip to main content
14,330,663 members
Rate this:
Please Sign up or sign in to vote.
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100