Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.