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

[gggar]

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.

Anyone has experience with Jira API and can give suggestions? Any help will be greatly appreciated! Thank you.

[gggar · Accepted solution]

Hi @v-shex-msft thanks for the reply.

Anyway, I've solved the issue using:

createdDate>%3D'2020%2F01%2F01'

The date format need to be escaped apparently.

[v-shex-msft]

Hi @gggar,

Any logic date fields include in your data source to remark the created date? If that is the case, you can invoke that field with the operator in 'query' options to filter records based on date values.

Advanced search reference - JQL fields | Jira Software Cloud | Atlassian Support

Advanced search reference - JQL keywords | Jira Software Cloud | Atlassian Support
Regards,

Xiaoxin Sheng