Response status is 422: Invalid Filter

APIs
1

After executing the following request:

https://app.nocodb.com/api/v2/tables/mrg9it4je9v0yn6/records?where=%28userid%2C%20eq%2C%201%29&limit=25&shuffle=0&offset=0

I am receiving a 422 response with the message:

{
  "error": "INVALID_FILTER",
  "message": "Filter '(userid, eq, 1)' is invalid"
}

Screenshot 2024-07-23 at 11.20.13 PM
Screenshot 2024-07-23 at 11.20.13 PM2128×720 70 KB

If I remove the WHERE clause then the request runs fine and returns everything in the table. Can somebody spot the issue here? Thanks!

2

From the error message it’s clear that there is an extra whitespace before eq(equality operator) while parsing the codition it will include the whitespace and fail. So remove the whitespace and try.

So after removing whitespace the url will be:

https://app.nocodb.com/api/v2/tables/mrg9it4je9v0yn6/records?where=%28userid%2Ceq%2C1%29&limit=25&shuffle=0&offset=0

Let me know if you are still facing issue with the above url, Thank you.

3

ahh yes, didn’t think white space would be considered but I guess this is always interpreted as a string. Thanks!

1 Like