Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

Need Help
Tips and Tricks

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.