Forum Discussion
Getting "Expression.Error: Access to the resource is forbidden." while invoking Jira dynamically
Hello group, I fighting with the bellow since a while now : I trying to create a dynamically a call to Jira REST API to get the status of an issue. I'm building the URL from the column I...
Thank you very much lbendlin for getting back to me so quickly. Much appreciated..
Unfortunatly it seem that using RelativePath doesn't solve my issue:
When I'm simply using WebContent all is fine
#"Added Custom1" = Table.AddColumn(#"Added Custom", "InvokeJiraStatus", each [External Ticket 1]&"/?fields=status"),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom1",{{"InvokeJiraStatus", type text}}),
#"Added Custom2" = Table.AddColumn(#"Changed Type1", "ResultingJiraStatus", each Web.Contents("https://jira.gemalto.com/rest/api/2/issue/",[RelativePath = [InvokeJiraStatus]]))
But When adding Json.Document in front, to parse Web.Content ,
= Table.AddColumn(#"Changed Type1", "ResultingJiraStatus", each Json.Document(Web.Contents("https://jira.gemalto.com/rest/api/2/issue/",[RelativePath = [InvokeJiraStatus]])))
same error, Expression.Error: Access to the resource is forbidden is raised
What am I doing wrong ?
lbendlin
Super User
Super UserYou should use the Query parameter instead of making the query part of the RelativePath