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
}
}Search for records in the specified table based on filter, sort, and pagination criteria.
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
}
}Show child attributes
A condition for filtering records. Text-related conditions are case-insensitive.
Show child attributes
AND, OR, IS_EMPTY, IS_NOT_EMPTY, IS_BETWEEN, IS_NOT_BETWEEN, IS, IS_NOT, GREATER_THAN, GREATER_THAN_OR_EQUALS, LESS_THAN, LESS_THAN_OR_EQUALS, CONTAINS, DOES_NOT_CONTAIN, STARTS_WITH, DOES_NOT_START_WITH, ENDS_WITH, DOES_NOT_END_WITH, IS_ONE_OF, IS_NOT_ONE_OF, HAS_ALL_OF, HAS_NONE_OF The Field ID to apply the operator on.
The value to compare against. Can be a string, number, or an array for operators like IS_ONE_OF.
Lower bound for IS_BETWEEN operator.
Upper bound for IS_BETWEEN operator.
Used for AND/OR operators to nest conditions.
A paginated list of matching records.