Discover inactive projects via REST API

[luebbe]

Hi Folks,

for obvious reasons I'm trying to find inactive translation projects on our weblate instance in order to remove them.
To achieve this, I query the /api/projects/<project>/statistics/ endpoint which gives me a last_change date. As far as I can tell, this date is null when the project has seen no activity at all after being created and it contains a valid date, when there was any translation activity.

Unfortunately the null date doesn't allow me to determine how long this project already exists. Just that there is "no activity since creation", no matter if it was created a year or a day ago.
Unless this information is available somewhere via the REST API, it would be very helpful to have a created date for the project and for the components as well.

[nijel]

Currently, you cannot get it without looking at changes. You can guess by project ID, as that is assigned sequentially.

[luebbe]

Thanks for the info. That helps a little. Now I see the following when I list projects that haven't changed in the past 180 days:

This tells me that the first of the "never" changed projects is quite old and probably a good candidate for deletion, since it was created before the first project with a changed date. The last two are quite recent and should probably stay, the second one needs more context to determine whether it should stay or not.

Translated 0% for the "never" projects is a side effect of the json deserializer breaking on the null date.

[luebbe]

OK, now I also look at the changes. It slows everything down a bit, but that's ok and I get what I need.

Showing projects that have been created more than 180 days ago without any changes in the past 180 days:

Thanks again!

[nijel]

Actually, this is something what would be useful for more sites. I've made an alert to trigger if component doesn't receive updates for some time in 0ee59a7.