Skip to main content
POST
/
databases
/
{databaseId}
/
tables
/
{tableId}
/
records
/
search
Search Records
curl --request POST \
  --url https://tables-api.softr.io/api/v1/databases/{databaseId}/tables/{tableId}/records/search \
  --header 'Content-Type: application/json' \
  --header 'Softr-Api-Key: <api-key>' \
  --data '{
  "filter": {
    "operator": "AND",
    "leftSide": "<string>",
    "rightSide": "<string>",
    "lowerBound": "<string>",
    "upperBound": "<string>",
    "conditions": [
      {}
    ]
  },
  "sort": {},
  "paging": {
    "offset": 0,
    "limit": 10
  }
}'
{
  "data": [
    {
      "id": "<string>",
      "tableId": "<string>",
      "fields": {},
      "createdAt": "2023-11-07T05:31:56Z",
      "updatedAt": "2023-11-07T05:31:56Z"
    }
  ],
  "metadata": {
    "offset": 123,
    "limit": 123,
    "total": 123
  }
}

Authorizations

Softr-Api-Key
string
header
required

Path Parameters

databaseId
string
required
tableId
string
required

Body

application/json
filter
object

A condition for filtering records. Text-related conditions are case-insensitive.

sort
object

Sorting criteria (structure not fully specified in docs).

paging
object

Response

A paginated list of matching records.

data
object[]
metadata
object