Search Table
https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/search
This endpoint performs full text search in a particular table.
Expected parameters
Name | Description | In | Required | Schema |
---|---|---|---|---|
db_branch_name | The DBBranchName matches the pattern `{db_name}:{branch_name}`. | path | ✅ | string |
table_name | The Table name | path | ✅ | string |
Free Text Search in a Table
POSThttps://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/search
Run a free text search operation in a particular table. The endpoint accepts a `query` parameter that is used for the free text search and a set of structured filters (via the `filter` parameter) that are applied before the search. The `filter` parameter uses the same syntax as the [query endpoint](/docs/api-reference/db/db_branch_name/tables/table_name/query#filtering) with the following exceptions: * filters `$contains`, `$startsWith`, `$endsWith` don't work on columns of type `text` * filtering on columns of type `multiple` is currently unsupported