You should replace everything. The latch, cable and the lock actuator. Mine finally worked once I did that. Amazon has the parts. I will look them up.
I also recommend to inspect and replace the rear hatch lower weatherstripping. They get dry rotted and worn out. And that lets water into all of the internal parts which is a big problem. That’s an OEM part only.