Xanoaudit logs
authentication
mcp server
addon
agent trigger
agent
api group / api
- GETGenerate OpenAPI specification for a specific API endpoint
- PUTUpdate API endpoint security settings
- GETRetrieve a specific API endpoint by ID
- PUTUpdate an API endpoint
- DELDelete an API endpoint permanently. This action cannot be undone
- GETRetrieve all API endpoints in a group
- POSTCreate a new API endpoint using XanoScript
api group
branch
workspace
- GETGenerate full workspace context
- POSTExport database table schemas and branch configuration as a file
- POSTExport complete workspace data and configuration as an archive
- POSTImport database schema into a new branch with optional deployment
- POSTReplace workspace content and configuration with imported archive
- GETRetrieve workspace-wide OpenAPI spec
- GETRetrieve detailed information about a specific workspace
- PUTUpdate an existing workspace
- DELDelete a workspace permanently
- GETRetrieve all accessible workspaces for the authenticated user
- POSTCreate a new workspace
workspace / datasource
file
function
request history
- POSTSearch function request history
- GETRetrieve API function request history
- POSTSearch middleware request history
- GETRetrieve middleware request history
- POSTSearch API request history
- GETRetrieve API request history
- POSTSearch task request history
- GETRetrieve task request history
- POSTSearch tool request history
- GETRetrieve tool request history
- POSTSearch trigger request history
- GETRetrieve trigger request history
mcp server trigger
middleware
realtime trigger
realtime
- GETRetrieve a realtime channel
- PUTUpdate realtime channel details using XanoScript
- DELDelete a realtime channel permanently. This action cannot be undone
- GETRetrieve all realtime channels
- POSTCreate a new realtime channel using XanoScript
- GETRetrieve real-time operational metrics and connection detailsdeprecated
- PUTUpdate real-time settings and connection configurationdeprecated
static host
table trigger
table
- PUTUpdate table autocomplete settingsdeprecated
- PUTUpdate table propertiesdeprecated
- PUTConfigure table security rules
- GETRetrieve detailed information for a specific table
- PUTUpdate a workspace table
- DELDelete a database table and all its data permanently
- GETRetrieve all tables in a workspace
- POSTCreate a new database table with optional schema definition
table / content
- POSTDelete multiple records by their IDs in a single operation
- POSTUpdate multiple records in a single batch operation
- POSTCreate multiple records in a single batch operation
- POSTDelete all records matching specified search criteria
- POSTUpdate all records matching specified search criteria
- POSTSearch table records
- GETRetrieve a specific record by ID
- PUTUpdate a specific record by ID
- DELDelete a specific record by ID
- GETRetrieve paginated records from a table
- POSTCreate a new record in the table
- DELTruncate a database table
table / index
- POSTCreate a btree index on table columns
- POSTCreate a full-text search index on table columns
- POSTCreate a spatial index on a table
- POSTCreate a unique index on table columns
- POSTCreate a vector index on a table column
- DELDelete a specific table index. This action cannot be undone.
- GETRetrieve all indexes for a database table
- PUTReplace all indexes for a database table
table / schema
table / schema / type
- POSTCreate an attachment column
- POSTCreate an audio column
- POSTCreate a boolean column
- POSTCreate a date column
- POSTCreate a decimal column
- POSTCreate an email column
- POSTCreate an enum column
- POSTCreate a geographic linestring column
- POSTCreate a geographic multilinestring column
- POSTCreate a geographic multipoint column
- POSTCreate a geographic multipolygon column
- POSTCreate a geographic point column
- POSTCreate a geographic polygon column
- POSTCreate an image column
- POSTCreate an integer column
- POSTCreate a JSON column
- POSTCreate an object column
- POSTCreate a password column
- POSTCreate a UUID-based table reference column
- POSTCreate a table reference column
- POSTCreate a text column
- POSTCreate a timestamp column
- POSTCreate a UUID column
- POSTCreate a vector column
- POSTCreate a video column
task
tool
workspace trigger
Truncate a database table
Delete all records from the table and optionally reset the primary key
Authentication: required
Required API Scope: Workspace Content: Delete
DELETE
/
workspace
/
{workspace_id}
/
table
/
{table_id}
/
truncate
Truncate a database table
Copy
curl --request DELETE \
--url https://your-xano-instance.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/truncate \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"reset": true
}'Copy
{}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
Body
application/jsonmultipart/form-data
Response
Success!
Was this page helpful?
Truncate a database table
Copy
curl --request DELETE \
--url https://your-xano-instance.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/truncate \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"reset": true
}'Copy
{}