I want to limit API rest/api/3/search response to only fields.created = current year

G July 2, 2021

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.

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events