Jira API - Need results of current year issues

[Syed Arif]

Jira API - Need results of current year issues - Am using the below API's in Power query to get the results of current year 2022 - but i also see it's giving me previous year isues.

Can some1 pls help

https://XXXX.com/jira/rest/api/2/search?jql=project in (xxx,xxx,xxx)&maxResults=2000&AND created >= startOfYear() 

https://XXXX.com/jira/rest/api/2/search?jql=project in (xxx,xxx,xxx)&maxResults=2000&createdDate>=\"2022/01/01\" and createdDate<=\"2022/12/31\"'"; 

[Renzo Arriagada · Accepted solution]

Hi @Syed Arif !

You have written wrongly your API calls

They should look like this:

• https://XXXX.com/jira/rest/api/2/search?jql=project in (xxx,xxx,xxx) AND created >= startOfYear()&maxResults=2000
• https://XXXX.com/jira/rest/api/2/search?jql=project in (xxx,xxx,xxx) AND createdDate>=\"2022/01/01\" and createdDate<=\"2022/12/31\"&maxResults=2000

Although I'm not sure if you're going to be able of setting the maxResults to 2000 due to limitations on the app itself to restrict expensive API calls that might disrupt the service.

The important thing to note on both calls is that you first must build your jql as one parameter and then you can add more parameters to the call using &

I hope this helps.

Kind regards,

Renzo from Servicerocket.

[Syed Arif]

Yes, This helps :) Thank you :)

[Syed Arif]

can you pls help me with search API request header 

and

exclude columns which has Null values ?