Jira API to get the date of the last modification on project

[Marie NB]

Hello,

I work as Jira admin and I have more than 800 projects.

Unfortunately, all are not used. In the administration projects part I have a column "last issue updated". I need to extract this information with API JIRA in order to know which project to archieved or not and to be able to give datas.

I already use the the API to get all the projects and the projectLead :  Jira/rest/api/2/project?expand=lead

Can you help me to update my request in order to also have "last issue update" in my extract?

I use Jira server 7.13 and i also have Scriptrunner 5.4.45

thanks for your help.

[Aiden Marriott · Accepted solution]

Does look like it is returned by the API by default.  There is a suggestion here https://community.atlassian.com/t5/Jira-questions/how-to-get-last-issue-update-for-all-projects/qaq-p/1253839 to bring back the last updated issue from a project, but you would need to go through each project in turn.  If you find a neater solution please post!

[Marie NB]

Hello Aiden, 

Thanks for your answer. It's a step for a solution. 

I'm working on VBA in order to get the information on each project. 

I will add a comment if I find a neater solution. 

Thank you for your help. 

kind regards,

Marie