Hello,
I am using this API call in Power BI:
path = "rest/api/3/search?maxResults=100&jql=",
jql_query = "issueType=Bug&fields=project,created,assignee,status,priority,reporter,creator&expand=changelog",
fields_query = "project,created,assignee,status,priority,creator,reporter",
Source_new = Json.Document(
Web.Contents(host,
[
RelativePath=path,
Query=[issueType="bug", fields=fields_query, expand="changelog"]
]
)
)
I want to limit the bug records returned to only bugs created this year.
I think I can utilize startOfYear() somewhere in the query? I tried that but I think it doesn't work.
Anyone can give suggestions? Any help will be greatly appreciated! Thank you.