Set-ADOWorkItem.ps1
|
function Set-ADOWorkItem { <# .Synopsis Sets work items from Azure DevOps .Description Sets work item from Azure DevOps or Team Foundation Server. .Example @{ 'Verb' ='Get' ;'Noun' = 'ADOWorkItem' } | Set-ADOWorkItem -Organization StartAutomating -Project PSDevOps -ID 4 .Example Set-ADOWorkItem -Organization StartAutomating -Project PSDevOps -Query "Select [System.ID] from WorkItems Where [System.State] = 'To Do' and [System.AssignedTo] = @Me" -InputObject @{ State = 'Doing' } .Link Invoke-ADORestAPI .Link https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/work%20items/get%20work%20item?view=azure-devops-rest-5.1 .Link https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query%20by%20wiql?view=azure-devops-rest-5.1 #> [CmdletBinding(DefaultParameterSetName='ByID',SupportsShouldProcess=$true)] param( # The InputObject [Parameter(ValueFromPipeline,ValueFromPipelineByPropertyName)] [PSObject] $InputObject, # The Organization [Parameter(Mandatory,ValueFromPipelineByPropertyName)] [Alias('Org')] [string] $Organization, # The Project [Parameter(Mandatory,ValueFromPipelineByPropertyName)] [string] $Project, # The Work Item ID [Parameter(Mandatory,ParameterSetName='ByID',ValueFromPipelineByPropertyName)] [string] $ID, # A query [Parameter(Mandatory,ParameterSetName='ByQuery',ValueFromPipelineByPropertyName)] [string] $Query, # The work item ParentID [Parameter(ValueFromPipelineByPropertyName)] [string] $ParentID, # The server. By default https://dev.azure.com/. # To use against TFS, provide the tfs server URL (e.g. http://tfsserver:8080/tfs). [Parameter(ValueFromPipelineByPropertyName)] [uri] $Server = "https://dev.azure.com/", # The api version. By default, 5.1. # If targeting TFS, this will need to change to match your server version. # See: https://docs.microsoft.com/en-us/azure/devops/integrate/concepts/rest-api-versioning?view=azure-devops [string] $ApiVersion = "5.1", # A Personal Access Token [Alias('PAT')] [string] $PersonalAccessToken, # Specifies a user account that has permission to send the request. The default is the current user. # Type a user name, such as User01 or Domain01\User01, or enter a PSCredential object, such as one generated by the Get-Credential cmdlet. [pscredential] [Management.Automation.CredentialAttribute()] $Credential, # Indicates that the cmdlet uses the credentials of the current user to send the web request. [Alias('UseDefaultCredential')] [switch] $UseDefaultCredentials, # Specifies that the cmdlet uses a proxy server for the request, rather than connecting directly to the Internet resource. Enter the URI of a network proxy server. [uri] $Proxy, # Specifies a user account that has permission to use the proxy server that is specified by the Proxy parameter. The default is the current user. # Type a user name, such as "User01" or "Domain01\User01", or enter a PSCredential object, such as one generated by the Get-Credential cmdlet. # This parameter is valid only when the Proxy parameter is also used in the command. You cannot use the ProxyCredential and ProxyUseDefaultCredentials parameters in the same command. [pscredential] [Management.Automation.CredentialAttribute()] $ProxyCredential, # Indicates that the cmdlet uses the credentials of the current user to access the proxy server that is specified by the Proxy parameter. # This parameter is valid only when the Proxy parameter is also used in the command. You cannot use the ProxyCredential and ProxyUseDefaultCredentials parameters in the same command. [switch] $ProxyUseDefaultCredentials ) begin { $invokeRestApi = [Management.Automation.CommandMetaData]$ExecutionContext.SessionState.InvokeCommand.GetCommand('Invoke-ADORestAPI', 'Function') #region Copy Invoke-ADORestAPI parameters $invokeParams = @{} + $PSBoundParameters foreach ($k in @($invokeParams.Keys)) { if (-not $invokeRestApi.Parameters.ContainsKey($k)) { $invokeParams.Remove($k) } } #endregion Copy Invoke-ADORestAPI parameters $fixField = { param($prop, $validFieldTable) $fieldName = if ($validFieldTable.Contains($prop.Name)) { $validFieldTable[$prop.Name].ReferenceName } else { $noSpacesPropName = $prop.Name -replace '\s', '' foreach ($v in $validFieldTable.Values) { if ($v.Name -replace '\s', '' -eq $noSpacesPropName -or $v.referenceName -eq $noSpacesPropName) { $v.referenceName break } } } if (-not $fieldName) { Write-Warning "Could not map $($prop.Name) to a field" return } @{ op = "add" path = '/fields/' + $fieldName value = $prop.Value } } #region Output Work Item $outWorkItem = { param([Parameter(ValueFromPipeline)]$restResponse) process { $out = $restResponse.fields if (-not $out.ID) { $out.psobject.properties.add([PSNoteProperty]::new('ID', $restResponse.ID)) } if (-not $out.Relations -and $restResponse.Relations) { $out.psobject.properties.add([PSNoteProperty]::new('Relations', $restResponse.Relations)) } if (-not $out.Organization -and $Organization) { $out.psobject.properties.add([PSNoteProperty]::new('Organization', $Organization)) } if (-not $out.Project -and $Project) { $out.psobject.properties.add([PSNoteProperty]::new('Project', $Project)) } $out.pstypenames.clear() # and we want them to by formattable, we we give them the following typenames $wiType = $out.'System.WorkItemType' if ($workItemType) { #* $Organization.$Project.$WorkItemType (If Output had WorkItemType). $out.pstypenames.add("$Organization.$Project.$wiType") } #* $Organization.$Project.WorkItem. $out.pstypenames.add("$Organization.$Project.WorkItem") if ($workItemType) { #* PSDevOps.$WorkItemType (if output had workItemType). $out.pstypenames.add("PSDevOps.$wiType") } $out.pstypenames.add("PSDevOps.WorkItem") #* PSDevOps.WorkItem # Decorating the object this way allows it to be generically formatted by the PSDevOps module $out # and specifically formatted for a given org/project/workitemtype. } } #endregion Output Work Item } process { if ($PSCmdlet.ParameterSetName -eq 'ByID') { $uriBase = "$Server".TrimEnd('/'), $Organization, $Project -join '/' $validFields = if ($script:ADOFieldCache.$uribase) { $script:ADOFieldCache.$uribase } else { Get-ADOField -Organization $Organization -Project $Project -Server $Server @invokeParams } $validFieldTable = $validFields | Group-Object ReferenceName -AsHashTable $uri = $uriBase, "_apis/wit/workitems", "${ID}?" -join '/' $uri += if ($ApiVersion) { "api-version=$ApiVersion" } if ($InputObject -is [Collections.IDictionary]) { $InputObject = [PSCustomObject]$InputObject } $patchOperations = @(foreach ($prop in $InputObject.psobject.properties) { if ($MyInvocation.MyCommand.Parameters.Keys -contains $prop.Name) { continue } & $fixField $prop $validFieldTable }) if ($ParentID) { $thisWorkItem = Invoke-ADORestAPI -Uri "$uri&`$expand=relations" @invokeParams $c = 0 $updates = @(foreach ($rel in $thisWorkItem.relations) { if ($rel.rel -eq 'System.LinkTypes.Hierarchy-Reverse') { @{ op = 'remove' path = "/relations/$c" } } $c++ }) if ($updates) { $patchOperations += $updates } $patchOperations += @{ op='add' path ='/relations/-' value = @{ rel = 'System.LinkTypes.Hierarchy-Reverse' url = $uriBase, '_apis/wit', $ParentID -join '/' } } } $invokeParams.Uri = $uri $invokeParams.Body = ConvertTo-Json $patchOperations -Depth 100 $invokeParams.Method = 'PATCH' $invokeParams.ContentType = 'application/json-patch+json' if (-not $PSCmdlet.ShouldProcess("Patch $uri with $($invokeParams.body)")) { return } $restResponse = Invoke-ADORestAPI @invokeParams if (-not $restResponse.fields) { return } # If the return value had no fields property, we're done. & $outWorkItem $restResponse } elseif ($PSCmdlet.ParameterSetName -eq 'ByQuery') { $uri = "$Server".TrimEnd('/'), $Organization, $Project, "_apis/wit/wiql?" -join '/' $uri += if ($ApiVersion) { "api-version=$ApiVersion" } $invokeParams.Method = "POST" $invokeParams.Body = ConvertTo-Json @{query=$Query} $invokeParams["Uri"] = $uri $queryResult = Invoke-ADORestAPI @invokeParams $c, $t, $progId = 0, $queryResult.workItems.count, [Random]::new().Next() $myParams = @{} + $PSBoundParameters $myParams.Remove('Query') foreach ($wi in $queryResult.workItems) { $c++ Write-Progress "Updating Work Items" " [$c of $t]" -PercentComplete ($c * 100 /$t) -Id $progId Set-ADOWorkItem @myParams -ID $wi.ID } Write-Progress "Updating Work Items" "Complete" -Completed -Id $progId } } } |