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 An...

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.