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": {
    "condition": {
      "operator": "AND",
      "leftSide": "<string>",
      "rightSide": "<string>",
      "lowerBound": "<string>",
      "upperBound": "<string>",
      "conditions": "<array>"
    }
  },
  "sort": [
    {
      "sortingField": "<string>",
      "sortType": "ASC"
    }
  ],
  "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
sort
object[]
paging
object

Response

A paginated list of matching records.

data
object[]
metadata
object