Find azure devops work item which contains title x

Like (1) Share

Report

Posted on 10 Sep 2024 22:47:59 by PJ-10092242-0 Microsoft Employee

Hello Team,

I am planning to automate some clean up task for my team where I will be querying the records from kusto table and for each record, i will check if there is work item with title that contains keyword and if that is not there , then will create the work item

I tried using azure devop GET API and sent body as , it through the error back as METHOD is not allowed

I tried to do post and flow just hangs with no error

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Expiscornovus 31,701 Most Valuable Professional on 11 Sep 2024 at 09:48:57

Like (0)

Report
Find azure devops work item which contains title x

Wiql queries are always with a POST request, not a GET request.

Wiql - Query By Wiql - REST API (Azure DevOps Work Item Tracking) | Microsoft Learn

Try something like the below

Method

POST

URI

@{variables('ProjectName')}/_apis/wit/wiql?api-version=7.1-preview.2

Body

{ "query": "SELECT [System.Id],[System.WorkItemType],[System.Title],[System.AssignedTo],[System.State],[System.Tags] FROM WorkItems WHERE [System.Title] CONTAINS 'Test'" }

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel