README

Options to acquire Azure DevOps Work Item data

1. Azure DevOps REST API
2. Azure DevOps Python SDK
3. Azure DevOps CLI
4. Azure DevOps PowerShell
5. Azure DevOps Node.js SDK
6. Azure DevOps OData REST API

How to run the Python script

python main.py

How to compile the main.cs file

."C:\Program Files\Microsoft Visual Studio\2022\Enterprise\MSBuild\Current\Bin\Roslyn\csc.exe" .\main.cs

How to install the azure devops python sdk

Azure DevOps Python SDK

Run OData Query

1. Install the vscode-odata extension in VSCode
2. Modify and run main.odata

Run VSCode as Administrator

python -m ensurepip
python -m pip install --upgrade pip
python -m pip install azure-devops
python -m pip install --upgrade azure-devops
python -m pip install requests
python -m pip install dotenv

Resources

Azure DevOps Work Item REST API

Azure DevOps Work Item OData REST API

Azure DevOps Analytics Quick Reference

Azure DevOps Analytics Data Model

Grant Permissions to use Azure DevOps Analytics

Terraform Tutorial for Azure

Management Reports in Azure DevOps (Video)

Management Reports in Azure DevOps (GitHub repo)

Community Blogs

Vinicius Moura

Credits

Dot ENV. As I searched for a pacakge to read the .env file, I found this article and thought it was a good idea to use the approach. Simple. No need to install any package. Also, makes complete sense. Dusted