Hand-authored queries issue when using dynamic sources.

Hello everyone,

I came across this https://blog.crossjoin.co.uk/2018/12/10/credentials-data-privacy-settings-and-data-sources-in-power-query-power-bi/ when I was searching for solution to this issue. Tried a lot but couldn't solve it. So here I am 🙂

Chris modified his code from 

let
Source =
Json.Document(
Web.Contents(
"https://data.gov.uk/api/3/action/package_search?q=cows"
)
),
result = Source[result],
results = result[results],
results1 = results{0},
id = results1[id],
output =
Json.Document(
Web.Contents(
"https://data.gov.uk/api/3/action/package_show?id=" & id
)
)
in
output

to:

let
Source =
Json.Document(
Web.Contents(
"https://data.gov.uk/api/3/action/package_search?q=cows"
)
),
result = Source[result],
results = result[results],
results1 = results{0},
id = results1[id],
output =
Json.Document(
Web.Contents(
"https://data.gov.uk/api/3/action/package_show",
[Query=[#"id"=id]]
)
)
in
output

How would you do with this code snippet if using similiar solution?

(GROUPS as text)=>
let
    Source = Json.Document(Web.Contents("https://clock.service-now.com/api/now/table/sys_user_group/"&GROUPS&" -H Authorization: Bearer &""GetAccesstoken()""")),
    #"Converted to Table" = Table.FromRecords({Source}),
    #"Expanded result" = Table.ExpandRecordColumn(#"Converted to Table", "result", {"name"}, {"name"})
in
    #"Expanded result"

Have a great day,

LoScalzo