Forum Discussion
Solved
Web API expand relations in Power query (M)
I am querying for Azure DevOps data using web API and trying to expand related remote links. I know the web API url which is https://dev.azure.com/fabrikam/_apis/wit/workitems?ids=297&$expand...
Have you tried using a Query record of [ids=Id, #"$expand"="relations"] ?
(The #"..." syntax is M's way of escaping identifier names, which can be used to include characters that aren't normally allowed.)
Have you tried using a Query record of [ids=Id, #"$expand"="relations"] ?
(The #"..." syntax is M's way of escaping identifier names, which can be used to include characters that aren't normally allowed.)
Yes, that worked.
I was calling the expand outside the "[ ]", which was my mistake.
Thank you !!!