Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Relative path and token authorization

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)

 

 

2 Replies