Query WorkItems Between Builds and convert it into a excel file from on-prem Azure DevOps Server through Azure DevOps REST API
I want list of the workItems that is changed after build in excel file. So far I am here : $AzureDevOpsPAT = "**********************************" $fromBuildId = "161" $toBuildId = "176" $AzureDevOpsAuthenicationHeader = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(":$($AzureDevOpsPAT)")) } $uriAccount ="https://AzureDevOpsServerName/DefaultCollection/ProjectName/_apis/build/workitems?fromBuildId=$($fromBuildId)&toBuildId=$($toBuildId)&api-version=5.0"…