This leverages the latest change in origin_visit_get and
origin_visit_status_get (paginated endpoints now) to iterate over visits and
The order iterated over is from most recent to oldest to try and resolve a snapshot targetting
a specific revision.
This algo got used recently in the deposit. It may serve again.
Related to T645