Forum Discussion
Solved
Dynamic data source (Jira) refresh
Hi there, I am trying to configure a report to automatically refresh that use Jira as it's source and getting the following message: The report I have created requires paramete...
The solution was:
= Json.Document(Web.Contents(#"Jira URL",[RelativePath = "/rest/api/2/search?jql=project%20%3D%20" & #"Project Key" & "%20AND%20resolved%20%3E%3D%20-52w%20AND%20issuetype%20not%20in%20(Epic)%20order%20by%20created%20DESC"]))
The solution was:
= Json.Document(Web.Contents(#"Jira URL",[RelativePath = "/rest/api/2/search?jql=project%20%3D%20" & #"Project Key" & "%20AND%20resolved%20%3E%3D%20-52w%20AND%20issuetype%20not%20in%20(Epic)%20order%20by%20created%20DESC"]))