如何使用WIQL从RESTful API获取数据，但它似乎不起作用

Question

有几天我都不知道代码有什么问题。。你们能看看我做错了什么吗？组织名称和项目名称在代码中输入正确。

这是PowerShell ISE上显示的错误消息：

调用RestMethod：无法发送具有此动词类型的内容正文。在\项目\开发任务。ps1:47字符：17$响应=调用RestMethod-Uri$url-headers$headers-方法Get…~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~CategoryInfo:NotSpecified:（：）[Invoke RestMethod]，ProtocolViolationException FullyQualifiedErrorId:System。网ProtocolViolationException，微软。PowerShell。命令。InvokeRestMet hodCommand

$collectionuri = $Env:SYSTEM_TEAMFOUNDATIONCOLLECTIONURI
$token = $Env:SYSTEM_ACCESSTOKEN # need to configure build to allow passing OAuth tokens

$basicAuth = "{0}:{1}" -f '', 'token~~fdsafdsa'
$basicAuth = [System.Text.Encoding]::UTF8.GetBytes(":$($basicAuth)")
$basicAuth = [System.Convert]::ToBase64String($basicAuth)
$headers = @{Authorization=("Basic {0}"-f $basicAuth)}

$WorkItemType = 'Recently updated'

$url = $collectionuri + 'https://dev.azure.com/{OrganizationName}/{ProjectName}/_apis/wit/queries/test/wiql?api-version=5.0'

$WIQL_query = "select [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.IterationPath] from WorkItems where [System.TeamProject] = @project and [System.Id] in (@recentProjectActivity) and not [System.State] in ('Closed', 'Inactive', 'Completed') and [System.IterationPath] Under 'Sprint number two' order by [System.ChangedDate] desc"
$body = @{ query = $WIQL_query }
$bodyJson=@($body) | ConvertTo-Json

$response = Invoke-RestMethod -Uri $url -headers $headers -Method Get -ContentType "application/json" -Body $bodyJson

$workitems = $response.workItems
Write-Host "Found" $workitems.Count "work items of type:" $WorkItemType

Answer 1

您只需要将-Method（在Invoke-RestMethod中）从Get更改为Post。

您尝试使用Work Item Query Language获取Work Items，在这个Rest API中，您需要在正文中传递WIQL，因此-method应该是Post。

请参阅此处的文档。