Optimize api for large datasets

**Problem**
When working with middleware, the error messages could be more descriptive.

**Suggestion**
Improve error handling and add detailed error messages.

**Context**
This would help with debugging and maintenance.

The issue does not identify any files, entry points, or tests. Start by locating the middleware and its current error-handling path, then determine which errors need more detail and how the expected messages should be verified. Done means the intended middleware errors are more descriptive and covered by tests.

Written by the indexing model from the issue text.