Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Response
Success!
Account API
- GETGet authorized user
- GETBrowse instances
- POSTCreates a new install token on the snippet
- DELDeletes a snippet token
- GETGet a specific snippet by ID
- GETGet instance
- GETList snippets owned by the authenticated user
- GETReturns a list of tokens for a snippet
- POSTUpdate settings on the snippet
- POSTUpdates a snippet token
Instance API
- POSTCreate a new database table with optional schema definition
- GETRetrieve all tables in a workspace with optional filtering and pagination
- GETRetrieve detailed information for a specific table
- PUTUpdate table properties including name, description, tags, and authentication settings
- DELDelete a database table and all its data permanently
- GETRetrieve the complete schema definition for a database table
- PUTReplace the entire schema definition for a database table
- GETRetrieve details for a specific column in a table's schema
- POSTRename a column in a table's schema
- DELDelete a column from a table's schema. This action cannot be undone.
- GETRetrieve all indexes for a database table
- PUTReplace all indexes for a database table with new index configuration
- DELDelete a specific table index. This action cannot be undone.
- DELDelete all records from the table and optionally reset the primary key
- POSTCreate a boolean column with true/false values and optional default settings
- POSTCreate a btree index on table columns to optimize query performance
- POSTCreate a date column for storing calendar dates without time information
- POSTCreate a decimal column for precise numeric values with configurable min/max limits
- POSTCreate a full-text search index for table columns with language-specific optimization
- POSTCreate a geographic linestring column for storing connected coordinate paths
- POSTCreate a geographic multilinestring column for storing multiple coordinate paths
- POSTCreate a geographic multipoint column for storing collections of coordinate points
- POSTCreate a geographic multipolygon column for storing complex area boundaries
- POSTCreate a geographic point column for storing latitude/longitude coordinates
- POSTCreate a geographic polygon column for storing area boundaries and shapes
- POSTCreate a JSON column for storing structured data objects and arrays
- POSTCreate a password column with automatic hashing and complexity validation rules
- POSTCreate a spatial index on a table for optimized geometry operations
- POSTCreate a table reference column to establish relationships with other database tables
- POSTCreate a text column with formatting options and customizable validation rules
- POSTCreate a timestamp column for storing precise date and time values
- POSTCreate a unique index on table fields to enforce data uniqueness and improve query performance
- POSTCreate a UUID column for generating universally unique identifiers
- POSTCreate a UUID-based table reference column for relationships with UUID primary keys
- POSTCreate a vector column for storing multi-dimensional data used in AI and ML applications
- POSTCreate a vector index on a table column with support for Inner Product, Cosine, L1, and L2 distance operations
- POSTCreate a video file column for storing video uploads and media content
- POSTCreate an attachment column for file uploads in a database table
- POSTCreate an audio file column for storing audio uploads and media
- POSTCreate an email column with built-in email format validation
- POSTCreate an enum column with predefined value options for dropdown selections
- POSTCreate an image column for storing photo uploads and visual media
- POSTCreate an integer column for whole numbers with configurable min/max limits
- POSTCreate an object column with nested child fields for complex data structures
- POST
Retrieve detailed information for a specific table
Copy
Ask AI
curl --request GET \
--url https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id} \
--header 'Authorization: Bearer <token>'Copy
Ask AI
{
"id": 1,
"created_at": "2023-04-19 21:01:32+0000",
"updated_at": "2023-04-19 21:01:32+0000",
"name": "Test Database",
"description": "My test database description",
"docs": "Documentation",
"guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
"auth": true,
"tag": [
"example tag"
],
"xanoscript": {
"status": "ok",
"value": "<string>",
"message": "<string>"
}
}Retrieve detailed information for a specific table
Retrieve detailed information for a specific table
GET
/
workspace
/
{workspace_id}
/
table
/
{table_id}
Retrieve detailed information for a specific table
Copy
Ask AI
curl --request GET \
--url https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id} \
--header 'Authorization: Bearer <token>'Copy
Ask AI
{
"id": 1,
"created_at": "2023-04-19 21:01:32+0000",
"updated_at": "2023-04-19 21:01:32+0000",
"name": "Test Database",
"description": "My test database description",
"docs": "Documentation",
"guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
"auth": true,
"tag": [
"example tag"
],
"xanoscript": {
"status": "ok",
"value": "<string>",
"message": "<string>"
}
}Was this page helpful?
Retrieve all tables in a workspace with optional filtering and paginationUpdate table properties including name, description, tags, and authentication settings
⌘I
Assistant
Responses are generated using AI and may contain mistakes.