How can I pull a list of project report including last used column without paid application

Shashank February 12, 2024

I need this last issue update column. I have tried with  /rest/api/2/project , but in this the last issue updated column is  not showing. Can anyone help me out

Screenshot Jira Project.png

1 answer

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2024

Hi @Shashank -- Welcome to the Atlassian Community!

Please try using the experimental expand=insight parameter to get that information: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/#api-rest-api-3-project-search-get

<yourJiraUrl>/rest/api/3/project/search?expand=insight

 

Kind regards,
Bill

Shashank February 12, 2024

Hi @Bill Sheboy  

Thankyou, 

Nope , the last issue updated column is not showing and only upto 50 projects are showing up. 

Can you please help. I need last issue updated column as to achieve the projects which are not in use for more than 3 to 4 months. And I need to pull out list of all projects. 

Someone please do help.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2024

That parameter worked when I tried it for Jira Cloud with my user as site admin.  Are you using Jira Cloud?

The default maxResults is 50 projects, and I believe that parameter can be increased up to 100.  After that point, paging must be used with the startAt parameter.  I recommend experimenting to increase the parameter for maxResults to learn if more can be returned.

 

If these suggestions do not help, please contact the Atlassian Support team here: https://support.atlassian.com/contact/#/

Shashank February 28, 2024

Yes I am using Jira cloud. Let me know if you find out if we can increase it to all projects and for me the last column is also not showing up.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2024

Please see my above comments, as this service function is experimental and has a limit on the number of records returned.

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