Create a btree index on table columns

POST

workspace

{workspace_id}

table

{table_id}

index

btree

Create a btree index on table columns

curl --request POST \
  --url https://your-xano-instance.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/index/btree \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "fields": [
    {
      "name": "name",
      "op": "desc"
    }
  ]
}
'

{
  "id": "<string>"
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

workspace_id

integer<int64>

required

table_id

integer<int64>

required

Body

fields

object[]

required

Show child attributes

Response

Success!

string

Truncate a database table

Create a full-text search index on table columns

Create a btree index on table columns

curl --request POST \
  --url https://your-xano-instance.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/index/btree \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "fields": [
    {
      "name": "name",
      "op": "desc"
    }
  ]
}
'

{
  "id": "<string>"
}