HTTP Request to find work item by custom field in Azure DevOps

0
votes

Is there a way to find all work items, through an HTTP request, where the value of a custom field is equal to a given value?

I have a PowerAutomate flow that creates tickets when a new email is received in a specific email account. The issue that whenever someone replies to the thread that creates duplicate tickets. My idea to solve it was to create a new field called Email ID, set it during the creation of the ticket and then, at the beginning of the flow, check if there's a work item already with the same conversation ID.

I just couldn't find any action that allowed me to search for the work item in that way, except for maybe the HTTP Request.

1
apiazure-devopspower-automate
docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/… - Shayki Abramczyk

1 Answers

1
votes

You can use the following REST API:

POST https://dev.azure.com/{organization}/_apis/Contribution/dataProviders/query?api-version=5.1-preview.1

Here is an example of request body:

{
    "contributionIds": [
        "ms.vss-work-web.work-item-query-data-provider"
    ],
    "context": {
        "properties": {
            "wiql": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @project AND [Custom.EmailId] = '{email id}'",
            "sourcePage": {
                "routeValues": {
                    "project": "{project}"
                }
            }
        }
    }
}

In the response body, if there are work items in query result, the ids of work items will be present in data.ms.vss-work-web.work-item-query-data-provider.data.targetIds. And if there is no work item, the variable data.ms.vss-work-web.work-item-query-data-provider.data.targetIds is empty.