Dynamic MSI Installer download for sysadmin

[FamousFour]

Summary

While individual static URLs for the current version MSI installer are available, I wondered if you could add a dynamic URL on the website that always returns the latest stable version installer on the website similar to this from Mozilla:

https://download.mozilla.org/?product=Thunderbird-msi-latest-ssl&os=win64&lang=en-US
(The above always delivers the latest release version of Thunderbird ESR)

Examples

Something like:
https://keepassxc.org/download/dynamic?file=KeePassXC&platform=Win64&format=MSI&stream=stable

So whenever my patch manager calls this URL it get's a fresh MSI installer of the up-to-date version.

Context

I am a sysadmin covering a SMB with 20-30 systems deployed. I would like to use KeePassXC as a password manager and sharing platform for our internal network, however in order to keep the software up to date easily I have to be able to pull the 'latest' stable MSI installer automatically from a URL. This would be an enormous help for automated system admin.

[droidmonkey]

Our website is a static site so the best you'll get is a client side redirect which likely won't work in your situation. We could use .htaccess to do a url rewrite, but that isn't sustainable for us. Recommend you look into GitHub api to detect when a new release is posted and download it.

[phoerious]

https://github.com/keepassxreboot/keepassxc/releases/latest always points to the latest release. You then have to extract the MSI link from there or use the API.