Hi,
whenever a parent item is closed ,I am trying to fetch the work item children status and work hours. If any child item is not in done state, I will notify the parent item assignee to about closing the child task.
Steps I have taken,
1. Trigger : When work Item is closed.
2. Action : Send an Http request to Azure dev Ops.
Azure devops request
Here i am trying to fetch all the child item for Work ID: 115968 (Also tried Dynamic Field. ID) but it is failing at this step only with error : "Unable to parse Base64 encoded bytes. clientRequestId: d86b2ede-c91b-4031-beaf-ef2773b9fb79"
Then I storing this query in to variable and
3. Using action : Get Query Results.
4. Apply to each : Send an email if state is not closed.
Any help is appreciated to resolve this issue.
Thanks,
Hi @RK_RPA,
As far as I am aware Query by WIQL request are POST requests and not GET requests.
Can you try something like below?
{
"query": "SELECT [System.Id],[System.AssignedTo],[System.State],[System.Title],[System.Tags]
FROM workitemlinks
WHERE ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward')
AND ([Source].[System.Id] = '@{triggerOutputs()?['body/fields/System_Id']}')"
}
WarrenBelz
146,786
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional