How to use secure method to connect to JIRA Rest API from Power BI

[Anonymous]

I am trying to connect to JIRA Rest API securely using Power BI but facing trouble while establishing connection to data Anonymously returning the error Expression.Error: Access to the resource is forbidden.

I am able to connect using Basic Authentication but got a notification from Atlassian prompting me to connect using secure Tokens. I am using the below function to get data. Any help would be greatly appreciated.

let
FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
let
contents = Web.Contents(#"URL (12)"&"rest/api/2/search",[Headers=[#"content-type"="application/json",Authorization="Bearer XXXXXXXXXXXX"],Query=[maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]]),

son = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
table meta [skipRows = skipRows + pageSize, total = 500]
in
FetchPage

Thanks,

Arjun

[v-juanli-msft]

Hi @Anonymous 

Please connect to your secure API like this article

let

     apiUrl = "https://xxxxxxx/api/info",

     options = [Headers =[#"Subscription-Key"="xxxxxxxxxxxxxxxxxxxxx"]],

     result = Web.Contents(apiUrl , options)

in

     result

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.