Extract "Hyperlink" from ADO Links using odata

[SamPatil]

Hi,

I have ADO item with Child, Related and Hyperlink link types. Using following odata I can pull child and related workitems but not able to extract Hyperlink. Appreciate any guidence for this issue.

https://analytics.dev.azure.com/{org}/{project}/_odata/v3.0-preview/WorkItems?

&$select=WorkItemId,Title,State,CreatedDate

&$filter=startswith(Area/AreaPath,'{path}')

&$expand=Links($select=TargetWorkItemId,LinkTypeName)

Thanks,

[JWolmanSymplr]

I have the same question here. I have an ADO work item with 8 links (related) and 1 hyperlink. The WorkItemsLinks only returns the 8 related links, not the hyperlink. How do you return the Hyperlink to the ADO work item?

[v-jingzhang]

Hi @SamPatil 

Maybe you can use Visual Studio Code to test OData queries in prior to using them in Power BI. Connect with data by using OData queries - Azure DevOps | Microsoft Docs

Try adding link type name to filter it. Link type reference 

filter=LinkTypeName eq 'Workitem Hyperlink'

Best Regards,
Community Support Team _ Jing