fix: status code from OK to NOT_FOUND

[kairoaraujo]

Description

This PR fixes the status code from OK (200) to NOT_FOUND (404) when the resource is not available or not in expected state when requested.

Fixes: #647

Types of changes

• [x] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [x] Breaking change (fix or feature that would cause existing functionality not to work as expected)

Additional requirements

• [x] Tests have been added for the bug fix or new feature
• [ ] Docs have been added for the bug fix or new feature

Code of Conduct

By submitting this PR, you agree to follow our Code of Conduct.

• [x] I agree to follow this project's Code of Conduct

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 99.10%. Comparing base (25928b7) to head (dcd02f4). Report is 92 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #651 +/- ## ========================================== + Coverage 98.97% 99.10% +0.12% ========================================== Files 14 14 Lines 588 667 +79 ========================================== + Hits 582 661 +79 Misses 6 6 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.