Forum Discussion

RevathyAnand's avatar
RevathyAnand
New Member
3 years ago

ADO Work items with direct links from OData Query

Hi All,

 

I am trying to fetch the Iteration Path of the Direct Child link work Item. I am able to get all the other fields like State, Title, Id. But Iteration is returning null. Please help me.

 

Though the query returns the right data for all the fileds except the Iteration which is loaded with null value.

 

 

 

 

 

 

 

let
   Source = OData.Feed("https://analytics.dev.azure.com/{name}/{name}/WorkItems?" & "$filter=WorkItemType eq 'Feature'" & "and State ne 'Removed'" & "and startswith(Area/AreaPath,
{areapath})" & "and Iteration/IterationPath eq {Iteration Path value}" & "&$select=WorkItemId,Title,WorkItemType,State,Priority,Severity,TagNames,AreaSK" & "&$expand=AssignedTo($select=UserName),Iteration($select=IterationPath),Area($select=AreaPath)," & "Links(" & "$filter=LinkTypeName eq 'Child'" & "and TargetWorkItem/WorkItemType eq 'User Story';" & "$select=LinkTypeName;" & "$expand=TargetWorkItem($select=WorkItemType,WorkItemId,Title,State,Iteration)" & ")", null, [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4])
in
    Source