Hand-authored queries issue when using dynamic sources.

[LoScalzo]

Hello everyone,

I came across this https://blog.crossjoin.co.uk/2018/12/10/credentials-data-privacy-settings-and-data-sources-in-power-... 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

[Syndicate_Admin]

RelativePath, not Query.

[LoScalzo]

Hello Syndicate_Admin, 

Thank you for the link but I cannot use Query it will create a question mark. 

I need URL + Variable like this (www.microsoft.com/Variable with static url in Web.Content and then use something below to link it. 

[Syndicate_Admin]

Please read the documentation.  There are examples of how to use RelativePath and how to specify Headers.

Web.Contents - PowerQuery M | Microsoft Learn