Forum Discussion
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=relations&api-version=6.0
I need the above url in Power query format so that it can refresh on PBI services which is like below.
let Source1 = (Id as text) =>
let
Source = VSTS.Contents("https://dev.azure.com/fabrikam/_apis/wit/workitems",
[
Query = [ids=Id]
]
),
#"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
#"Imported JSON"
in
Source1
The help I need is to add expand part from the above web API url in the Power query. I am new to using APIs.
Thanks in advance!!!
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.)
2 Replies
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 !!!
