GET
/search
searchPerform a filtered query against any table in the database.
Parameters
Name | In | Required | Description |
---|---|---|---|
table | query | Yes | The name of the table to search. |
fields | query | No | Comma-separated list of fields to return (e.g., `id,name,email`). |
where | query | No | JSON object representing WHERE conditions (e.g., `{"status":"active"}`). |
order_by | query | No | Column name to order by. |
order | query | No | Order direction (`asc` or `desc`). |
limit | query | No | Maximum number of results to return. |
offset | query | No | Number of records to skip (for pagination). |
Responses
Status | Description |
---|---|
200 | A list of records matching the query |
400 | Invalid input (e.g., missing `table`, bad `where` JSON) |