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

[Shashank]

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

[Bill Sheboy]

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]

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]

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]

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]

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