Getting "Expression.Error: Access to the resource is forbidden." while invoking Jira dynamically

[apoitou]

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'm getting from another system (Easyvista). 

Table.AddColumn(#"Added Custom", "InvokeJiraStatus", each "https://jira.gemalto.com/rest/api/2/issue/"&[External Ticket 1]&"/?fields=status"),

ANd I'm getting a Access to the resource is forbidden error 

whereas if I'm invoking directly the API (with hardcoded [External Ticket 1], like for instance :

Table.AddColumn(#"Added Custom", "InvokeJiraStatus", each "https://jira.gemalto.com/rest/api/2/issue/DISITMANUF-3/?fields=status")

I'm gettin no error.

Googled for  Expression.Error: Access to the resource is forbidden but mostly it is authetication issues with Sharepoint, or other sources, but this doesn't seems to be my case since hardcoded call works fine. 

Any help is welcome, thanks in advance, 

Alex

[apoitou]

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]

You should  use the Query parameter instead of making the query part of the RelativePath

[lbendlin]

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1