Softr 'Search Records' API: 400 - Bad Request

Ask the community
1

Hi there,

I’m having a lot of trouble with Softr’s ‘Search Records’ API. I’m using the API playground to build the request and understand that it requires a filter object with filter.operator, filter.leftSide, and filter.rightSide.

The issue is that Softr keeps returning a 400 - Bad Request error, even when I’m using the dropdown options provided for filter.operator and a field ID that I’m certain is correct for filter.leftSide.

Has anyone else run into this problem? How did you manage to fix it?

Thanks in advance!

2

Can you share your request without auth headers ? we can check and see whats wrong

3

Hi @artur

Firstly, thanks for replying and your support.

I use this call: https://tables-api.softr.io/api/v1/databases/{databaseId}/tables/{tableId}/records/search

The request I make is:

{
“filter”: {
“operator”: “IS”,
“leftSide”: “LkwDQ”,
“rightSide”: 1234,
}

Thanks

Rhys

4

I believe the Softr documentation is wrong. I got this to work today by looking VERY CLOSELY at how a similar request is made (successfully) from a Softr “search” module in make.com.

As it turns out, the “conditions” key mentioned in the documentation should actually be “condition”.

For a practical example, try this as your request body:

{
  "filter": {
    "condition": {
      "operator": "IS",
      "leftSide": "LkwDQ",
      "rightSide": "1234"
    }
  },
  "paging": {
  "limit": 10
  }
}