🐛 Bug: API V2 "Offset is beyond the total number of records" error status code returned is 200 instead of 400

[woodmin]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

Set API Call offset > the total number of records.
API response body contains: {"message":"Offset is beyond the total number of records"}
Status returned is 200 (Success) instead of 400 (Bad request).

Desired Behavior

Status returned on "Offset is beyond the total number of records" should be 400 (Bad request).

Project Details

Node: v18.18.2
Arch: x64
Platform: linux
Docker: true
RootDB: pg
PackageVersion: 0.203.2
Database version : 16.1

Attachments

No response

[woodmin]

I have reported other API Error Message / Status mismatches before. Could it be also checked along in the code if any more errors (messages) are not set to be returned with 200 status? For example: Invalid URL Format, Missing Required Parameters, Request Size Too Large, etc.?