Relative path and token authorization

[Anonymous]

The query below is before authorization with token, but now our company passed to authorization with token:
= Table.AddColumn(#”Renamed Columns”, “Data”, each try Json.Document(Web.Contents(“https://issuetracking.com/rest/api/2/issue/”, [RelativePath= [key] & “?expand=changelog&maxResults=999”])) otherwise null)

Here is how we normally access with token:
= Json.Document(Web.Contents(“https://issuetracking.sdd.com/rest/api/2/search?jql=&maxResults=2000,[Headers=[Authorization=”Bearer NzQ4NzcwMjk2NTM5OsK58HIugv+tY3Y”]]))

But now I dont know how to access by token with also relative path. I tried this (double authorization) but data column is empty:

= Table.AddColumn(#”Renamed Columns”, “Data”, each try Json.Document(Web.Contents(“https://issuetracking.com/rest/api/2/issue/”,
[Headers=[Authorization=”Bearer NzQ4NzcwMjk2NTM5OsK58HIugv+tY3YCw”]],
RelativePath= [key] & “?expand=changelog&maxResults=999″)) otherwise null)

[Anonymous]

I have looked Chris Webb's page but I could not find the solution I wanted. I need a way to use authorization and relative path togather.

[Anonymous]

Hi @Anonymous ,

About relative path, you could kindly refer to

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.