How do I automate a query pull/export in azure devops?

See more:

C#

automation

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.