Metadata API

The Metadata API is in beta and is subject to changes including access.

The Metadata API (Beta) enables you to interact with your Xano workspace schema and content programmatically. The Metadata API includes a comprehensive collection of API endpoints designed to add and modify database tables, schemas, and more.

The Metadata API is also used in some cases to facilitate an integration with Xano by providing the integration partner with your Metadata API access token.

Getting Started with the Metadata API

Generate an Access Token

An access token is required for any request you send to the Metadata API.

Before you proceed

Generating an access token requires giving it specific permissions regarding what it can access. Make sure to review available scopes before proceeding. Token Scopes Reference

1

Click in the lower-left corner and choose Instances

2

Click ⚙️ next to your instance and choose Metadata API from the panel that opens

3

Click

4

Click

5

Give your access token a name

Access tokens can have different scopes, or permissions, defined. Giving each access token a recognizable name is important for you to quickly recognize which access tokens are created for specific purposes.

6

Select the expiry for your access token

By default, Xano will revoke your Metadata API access token after 7 days, which means if you need to access the API again, you would have to generate a new token.

You can choose your own expiry duration; anything from 1 hour to never expire.

7

Define the scopes for your token

The scopes tell Xano what this token has access to. Each scope has 4 options:

C (Create) - Determines whether or not this token can create new data

R (Read) - Determines whether or not this token can read existing data

U (Update) - Determines whether or not this token can update existing data

D (Delete) - Determines whether or not this token can delete data.

Hint

You can hover over each permission to quickly add or remove all four types of scope.

Each scope has their own API endpoints associated with them. If you aren't sure which scopes you need for this token, use the reference below for additional information.

Scope
Description

Database

Access any of the content in your Xano database

Content

Access any content outside of the database or function stacks, such as branches, data sources, and realtime

Live Data Source

Access the data inside of your currently live data source

API Groups

Access API Groups and APIs

Functions

Access custom functions

Addons

Access addons

Task

Access background tasks

Files

Access file storage

Request History

Access request history

8

Once you've set up your token, click

You will be shown your new access token. Click the button to copy it to your clipboard.

Using your Access Token in Requests

The token should be sent as a header in the following format:

Authorization: Bearer your_token_here

Revoking an Access Token

When you access the metadata API panel, you can review all of your currently issued tokens and their scopes.

By choosing a token and clicking you can immediately revoke that token from use.


The Account API

The Account API allows you access to various settings and information about your Xano account.

Account API Endpoints

Account Information

Validate the Access Token and identify the account details.

get

Validate the Access Token and identify the account details. Authentication: required

Authorizations
Responses
200
Success!
application/json
get
GET /api:meta/auth/me HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
{
  "id": "text",
  "name": "text",
  "email": "text",
  "extras": "text"
}

browse instances

get

browse instances Authentication: required

Authorizations
Responses
200
Success!
application/json
get
GET /api:meta/instance HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
[
  {
    "name": "x1234-4567-8901",
    "display": "My Instance",
    "xano_domain": "x1234-4567-8901.n7.xano.com",
    "custom_domain": "text",
    "rate_limit": true,
    "meta_api": "https://x1234-4567-8901.n7.xano.com/api:meta",
    "meta_swagger": "https://x1234-4567-8901.n7.xano.com/apispec:meta?type=json"
  }
]

Instances

get instance

get

get instance Authentication: required

Authorizations
Path parameters
namestringRequired
Responses
200
Success!
application/json
get
GET /api:meta/instance/{name} HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
{
  "name": "x1234-4567-8901",
  "display": "My Instance",
  "xano_domain": "x1234-4567-8901.n7.xano.com",
  "custom_domain": "text",
  "rate_limit": true,
  "meta_api": "https://x1234-4567-8901.n7.xano.com/api:meta",
  "meta_swagger": "https://x1234-4567-8901.n7.xano.com/apispec:meta?type=json"
}

browse instances

get

browse instances Authentication: required

Authorizations
Responses
200
Success!
application/json
get
GET /api:meta/instance HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
[
  {
    "name": "x1234-4567-8901",
    "display": "My Instance",
    "xano_domain": "x1234-4567-8901.n7.xano.com",
    "custom_domain": "text",
    "rate_limit": true,
    "meta_api": "https://x1234-4567-8901.n7.xano.com/api:meta",
    "meta_swagger": "https://x1234-4567-8901.n7.xano.com/apispec:meta?type=json"
  }
]

Snippets

list snippets owned by the authenticated user

get

list snippets owned by the authenticated user Authentication: required

Authorizations
Query parameters
pageinteger · int64Optional
Responses
200
Success!
application/json
get
GET /api:meta/snippet HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "canonical": "kRG3t_-i",
      "created_at": "2023-03-23 23:32:56+0000",
      "updated_at": "2023-03-27 17:58:48+0000",
      "name": "Token Share Test",
      "review": "pending",
      "review_exception": "text",
      "install_access": "public",
      "install_access_description": "text",
      "featured": true,
      "verified": true
    }
  ]
}

update settings on the snippet

post

update settings on the snippet Authentication: required

Authorizations
Path parameters
canonicalstringRequired
Body
install_accessstring · enumRequiredPossible values:
install_access_descriptionstringRequired
Responses
200
Success!
application/json
post
POST /api:meta/snippet/{canonical} HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 63

{
  "install_access": "public",
  "install_access_description": "text"
}
{
  "canonical": "kRG3t_-i",
  "created_at": "2023-03-23 23:32:56+0000",
  "updated_at": "2023-03-27 17:58:48+0000",
  "name": "Token Share Test",
  "review": "pending",
  "review_exception": "text",
  "install_access": "public",
  "install_access_description": "text",
  "featured": true,
  "verified": true
}

get a specific snippet by ID

get

get a specific snippet by ID Authentication: required

Authorizations
Path parameters
canonicalstringRequired
Responses
200
Success!
application/json
get
GET /api:meta/snippet/{canonical} HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
{
  "canonical": "kRG3t_-i",
  "created_at": "2023-03-23 23:32:56+0000",
  "updated_at": "2023-03-27 17:58:48+0000",
  "name": "Token Share Test",
  "review": "pending",
  "review_exception": "text",
  "install_access": "public",
  "install_access_description": "text",
  "featured": true,
  "verified": true
}

creates a new install token on the snippet

post

creates a new install token on the snippet Authentication: required

Authorizations
Path parameters
canonicalstringRequired
Body
max_installsinteger · int64Required
Responses
200
Success!
application/json
post
POST /api:meta/snippet/{canonical}/token HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 18

{
  "max_installs": 1
}
{
  "created_at": "2023-05-09 21:31:20+0000",
  "updated_at": "2023-05-09 21:31:20+0000",
  "token": "OL3T4JYM",
  "max_installs": 23,
  "current_installs": 1
}

returns a list of tokens for a snippet

get

returns a list of tokens for a snippet Authentication: required

Authorizations
Path parameters
canonicalstringRequired
Responses
200
Success!
application/json
get
GET /api:meta/snippet/{canonical}/token HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
[
  {
    "created_at": "2023-05-09 21:31:20+0000",
    "updated_at": "2023-05-09 21:31:20+0000",
    "token": "OL3T4JYM",
    "max_installs": 23,
    "current_installs": 1
  }
]

updates a snippet token

post

updates a snippet token Authentication: required

Authorizations
Path parameters
canonicalstringRequired
tokenstringRequired
Body
max_installsinteger · int64Required
current_installsinteger · int64Required
Responses
200
Success!
application/json
post
POST /api:meta/snippet/{canonical}/token/{token} HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 39

{
  "max_installs": 1,
  "current_installs": 1
}
{
  "created_at": "2023-05-09 21:31:20+0000",
  "updated_at": "2023-05-09 21:31:20+0000",
  "token": "OL3T4JYM",
  "max_installs": 23,
  "current_installs": 1
}

deletes a snippet token

delete

deletes a snippet token Authentication: required

Authorizations
Path parameters
canonicalstringRequired
tokenstringRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/snippet/{canonical}/token/{token} HTTP/1.1
Host: app.xano.com
Authorization: Bearer JWT
Accept: */*
{}


The Instance API

The Instance API allows you to access data inside of your Xano instances, such as your database, files, and function stacks.

API Groups

get workspace API group

get

get workspace API group Authentication: required Required API Scope: Workspace Api: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Group Test",
  "description": "My API groups description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "canonical": "FRzyRdY0",
  "branch": "v1",
  "tag": [
    "text"
  ]
}

add workspace API group

post

add workspace API group Authentication: required Required API Scope: Workspace Api: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
branchstringOptional
namestringRequired
descriptionstringRequired
docsstringOptional
swaggerbooleanRequired
tagstring[] | nullableOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/apigroup HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 96

{
  "branch": "text",
  "name": "text",
  "description": "text",
  "docs": "text",
  "swagger": true,
  "tag": [
    "text"
  ]
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Group Test",
  "description": "My API groups description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "canonical": "FRzyRdY0",
  "branch": "v1",
  "tag": [
    "text"
  ]
}

delete workspace API group

delete

delete workspace API group Authentication: required Required API Scope: Workspace Api: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update workspace API group

put

update workspace API group Authentication: required Required API Scope: Workspace Api: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Body
namestringRequired
descriptionstringRequired
docsstringOptional
swaggerbooleanRequired
tagstring[] | nullableOptional
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 80

{
  "name": "text",
  "description": "text",
  "docs": "text",
  "swagger": true,
  "tag": [
    "text"
  ]
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Group Test",
  "description": "My API groups description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "canonical": "FRzyRdY0",
  "branch": "v1",
  "tag": [
    "text"
  ]
}

browse workspace API groups

get

browse workspace API groups Authentication: required Required API Scope: Workspace Api: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Query parameters
branchstringOptional
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/apigroup HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "id": 1,
      "created_at": "2023-04-19 21:01:32+0000",
      "updated_at": "2023-04-19 21:01:32+0000",
      "name": "API Group Test",
      "description": "My API groups description",
      "docs": "Documentation",
      "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
      "canonical": "FRzyRdY0",
      "branch": "v1",
      "tag": [
        "text"
      ]
    }
  ]
}

update workspace API group security settings

put

update workspace API group security settings Authentication: required Required API Scope: Workspace Api: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Body
guidstringRequired
canonicalstringRequired
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/security HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 34

{
  "guid": "text",
  "canonical": "text"
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Group Test",
  "description": "My API groups description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "canonical": "FRzyRdY0",
  "branch": "v1",
  "tag": [
    "text"
  ]
}

browse API's in an API group

get

browse API's in an API group Authentication: required Required API Scope: Workspace Api: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Query parameters
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "id": 1,
      "created_at": "2023-04-19 21:01:32+0000",
      "updated_at": "2023-04-19 21:01:32+0000",
      "name": "API Test",
      "description": "My APIs description",
      "docs": "Documentation",
      "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
      "cache": {
        "active": true,
        "ttl": 3600,
        "input": true,
        "auth": true,
        "datasource": true,
        "ip": true,
        "headers": [
          "text"
        ],
        "env": [
          "text"
        ]
      },
      "auth": {},
      "verb": "GET",
      "input": [
        {}
      ],
      "tag": [
        "text"
      ]
    }
  ]
}

APIs

get workspace API

get

get workspace API Authentication: required Required API Scope: Workspace Api: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
api_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api/{api_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Test",
  "description": "My APIs description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  },
  "auth": {},
  "verb": "GET",
  "input": [
    {}
  ],
  "tag": [
    "text"
  ]
}

delete workspace API

delete

delete workspace API Authentication: required Required API Scope: Workspace Api: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
api_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api/{api_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update workspace api

put

update workspace api Authentication: required Required API Scope: Workspace Api: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
api_idinteger · int64Required
Body
namestringRequired
descriptionstringRequired
docsstringOptional
verbstring · enumRequiredPossible values:
authobjectOptional
tagstring[] | nullableOptional
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api/{api_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 210

{
  "name": "text",
  "description": "text",
  "docs": "text",
  "verb": "GET",
  "auth": {},
  "tag": [
    "text"
  ],
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}
{}

add workspace API

post

add workspace API Authentication: required Required API Scope: Workspace Api: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
Body
namestringRequired
descriptionstringRequired
docsstringOptional
verbstring · enumRequiredPossible values:
tagstring[] | nullableOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 78

{
  "name": "text",
  "description": "text",
  "docs": "text",
  "verb": "GET",
  "tag": [
    "text"
  ]
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "API Test",
  "description": "My APIs description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  },
  "auth": {},
  "verb": "GET",
  "input": [
    {}
  ],
  "tag": [
    "text"
  ]
}

update workspace api security settings

put

update workspace api security settings Authentication: required Required API Scope: Workspace Api: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
apigroup_idinteger · int64Required
api_idinteger · int64Required
Body
guidstringRequired
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/apigroup/{apigroup_id}/api/{api_id}/security HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "guid": "text"
}
{}

Workspace

delete a workspace branch

delete

delete a workspace branch Authentication: required Required API Scope: Instance Workspace: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
branch_labelstringRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/branch/{branch_label} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

browse workspace branches

get

browse workspace branches Authentication: required Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/branch HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
[
  {
    "created_at": "2023-06-22 22:59:11+0000",
    "label": "v1",
    "live": true,
    "backup": "false"
  }
]

delete workspace data source

delete

delete workspace data source Authentication: required Required API Scope: Instance Workspace: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
labelstringRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/datasource/{label} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update workspace data source

put

update workspace data source Authentication: required Required API Scope: Instance Workspace: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
labelstringRequired
Body
colorstringOptionalDefault: #ebc346
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/datasource/{label} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 19

{
  "color": "#ebc346"
}
{
  "color": "#008000",
  "label": "live"
}

browse workspace data sources

get

browse workspace data sources Authentication: required Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/datasource HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
[
  {
    "color": "#008000",
    "label": "live"
  }
]

create workspace data source

post

create workspace data source Authentication: required Required API Scope: Instance Workspace: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
labelstringRequired
colorstringOptionalDefault: #ebc346
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/datasource HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 34

{
  "label": "text",
  "color": "#ebc346"
}
{
  "color": "#008000",
  "label": "live"
}

export the database table + branch schema

post

Leave the branch parameter empty to indicate the current live branch. password is optional. If provided, will encrypt the export and will be required when importing the file. Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
passwordstringOptional
branchstringOptional
Responses
200
Success!
application/json
Responseobject
post
POST /api:meta/workspace/{workspace_id}/export-schema HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 27

{
  "branch": "",
  "password": ""
}
{}

export the workspace and content

post

Leave the branch parameter empty to indicate the current live branch. password is optional. If provided, will encrypt the export and will be required when importing the file. Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
passwordstringOptional
branchstringOptional
Responses
200
Success!
application/json
Responseobject
post
POST /api:meta/workspace/{workspace_id}/export HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 27

{
  "branch": "",
  "password": ""
}
{}

browse workspaces

get

browse workspaces Authentication: required

Authorizations
Responses
200
Success!
application/json
get
GET /api:meta/workspace HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
[
  {
    "id": 1,
    "name": "My Workspace",
    "description": "My Workspace Description",
    "branch": "v1"
  }
]

browse workspace

get

browse workspace Authentication: required Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "id": 1,
  "name": "My Workspace",
  "description": "My Workspace Description",
  "branch": "v1"
}

Tables

update workspace table's autocomplete

put

update workspace table's autocomplete Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/autocomplete HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 32

{
  "autocomplete": [
    {
      "name": "id"
    }
  ]
}
{
  "id": "text",
  "autocomplete": "text"
}

delete table content rows in bulk

post

The request body should contain an array of row_ids, where each id identifies a row to be deleted. Required API Scope: Workspace Content: Delete

Authorizations
Path parameters
workspace_idstringRequired
table_idstringRequired
Header parameters
x-data-sourcestringOptionalDefault: live
Body
row_idsstring[]Optional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/bulk/delete HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "row_ids": [
    1
  ]
}
{
  "success": [
    "text"
  ],
  "success_total": 1,
  "error": [
    "text"
  ]
}

update table content in bulk

post

The request body should contain an array of items, where each item represents a row to be updated. For each row, provide the row_id and updates array that specifies the columns (path) to update and the new values (value). The example below is assuming that the table being modified has a column labeled name.

Required API Scope: Workspace Content: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/bulk/patch HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 55

{
  "items": [
    {
      "row_id": 1,
      "updates": {
        "name": "test name"
      }
    }
  ]
}
{
  "success": [
    "text"
  ],
  "success_total": 1
}

create new table content in bulk

post

Each table has unique schema, which means that the request body should be an array of objects with the schema relevant to the table being used. The example below is assuming that the table has a column labeled "name".

Required API Scope: Workspace Content: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
allow_id_fieldbooleanOptional
itemsobjectRequired
Responses
200
Success!
application/json
Responseinteger · int64[]
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/bulk HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 55

{
  "items": [
    {
      "name": "test name"
    }
  ],
  "allow_id_field": false
}
[
  1
]

delete table content rows matching search criteria

post

Provide search criteria to delete all matching rows. Required API Scope: Workspace Content: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
searchobjectOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/search/delete HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 13

{
  "search": []
}
{
  "success": [
    "text"
  ],
  "success_total": 1
}

patch table content rows matching search criteria

post

Provide search and update objects with path and new value to patch rows matching search criteria. Required API Scope: Workspace Content: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
searchobjectOptional
updatesobjectOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 58

{
  "search": [
    {
      "name": "test"
    }
  ],
  "updates": {
    "name": "new name"
  }
}
{
  "success": [
    "text"
  ],
  "success_total": 1
}

search table content with support for complex filtering and sorting

post

search table content with support for complex filtering and sorting Authentication: required Required API Scope: Workspace Content: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
pageinteger · int64OptionalDefault: 1
per_pageinteger · int64OptionalDefault: 50
sortobjectOptional
searchobjectOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content/search HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 57

{
  "page": 1,
  "per_page": 50,
  "sort": {
    "id": "desc"
  },
  "search": []
}
{
  "items": {},
  "itemsReceived": 1,
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "offset": 1,
  "perPage": 1,
  "itemsTotal": 1,
  "pageTotal": 1
}

delete table content

delete

delete table content Authentication: required Required API Scope: Workspace Content: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
content_idstringRequired
Header parameters
x-data-sourcestringOptionalDefault: live
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/table/{table_id}/content/{content_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

get table content

get

get table content Authentication: required Required API Scope: Workspace Content: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
content_idstringRequired
Header parameters
x-data-sourcestringOptionalDefault: live
Responses
200
Success!
application/json
Responseobject
get
GET /api:meta/workspace/{workspace_id}/table/{table_id}/content/{content_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update existing table content

put

Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used. The example below is assuming that the table has a column labeled "name".

Required API Scope: Workspace Content: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
content_idstringRequired
Header parameters
x-data-sourcestringOptionalDefault: live
Body
objectOptionalExample: {"name":"test name"}
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/content/{content_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 20

{
  "name": "test name"
}
{}

browse table content

get

browse table content Authentication: required Required API Scope: Workspace Content: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Query parameters
pageinteger · int64Optional
per_pageinteger · int64Optional
Header parameters
x-data-sourcestringOptionalDefault: live
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/table/{table_id}/content HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "items": {},
  "itemsReceived": 1,
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "offset": 1,
  "perPage": 1,
  "itemsTotal": 1,
  "pageTotal": 1
}

create new table content

post

Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used. The example below is assuming that the table has a column labeled "name".

Required API Scope: Workspace Content: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
objectOptionalExample: {"name":"test name"}
Responses
200
Success!
application/json
Responseobject
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/content HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 20

{
  "name": "test name"
}
{}

create a btree table index

post

create a btree table index Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/index/btree HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 40

{
  "fields": [
    {
      "name": "name",
      "op": "desc"
    }
  ]
}
{
  "id": "text"
}

create a search table index

post

create a search table index Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
langstring · enumRequiredPossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/index/search HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 80

{
  "name": "search_label",
  "lang": "english",
  "fields": [
    {
      "name": "name",
      "priority": 1
    }
  ]
}
{
  "id": "text"
}

create a spatial table index

post

create a spatial table index Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/index/spatial HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 60

{
  "fields": [
    {
      "name": "location",
      "op": "gist_geometry_ops_2d"
    }
  ]
}
{
  "id": "text"
}

create a unique table index

post

create a unique table index Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/index/unique HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 40

{
  "fields": [
    {
      "name": "name",
      "op": "desc"
    }
  ]
}
{
  "id": "text"
}

create a vector table index

post

Options include vector_ip_ops (Inner Product), vector_cosine_ops (Cosine), vector_l1_ops (L1 Distance), vector_l2_ops (L2 Distance) Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/index/vector HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 49

{
  "fields": [
    {
      "name": "name",
      "op": "vector_ip_ops"
    }
  ]
}
{
  "id": "text"
}

delete table index

delete

delete table index Authentication: required Required API Scope: Workspace Database: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
index_idstringRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/table/{table_id}/index/{index_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

browse table indexes

get

browse table indexes Authentication: required Required API Scope: Workspace Database: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
get
GET /api:meta/workspace/{workspace_id}/table/{table_id}/index HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

replace all of the indexes of a workspace table

put

replace all of the indexes of a workspace table Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
indexobjectRequired
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/index HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 117

{
  "index": [
    {
      "type": "primary",
      "fields": [
        {
          "name": "id"
        }
      ]
    },
    {
      "type": "btree",
      "fields": [
        {
          "name": "created_at",
          "op": "desc"
        }
      ]
    }
  ]
}
{}

update workspace table's metadata

put

update workspace table's metadata Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestring | nullableOptional
descriptionstring | nullableOptional
tagstring[] | nullableOptional
authboolean | nullableOptional
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/meta HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 63

{
  "name": "text",
  "description": "text",
  "tag": [
    "text"
  ],
  "auth": true
}
{}

rename a column within the schema of a workspace table

post

rename a column within the schema of a workspace table Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
new_namestringRequired
old_namestringRequired
Responses
200
Success!
application/json
Responseobject
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/rename HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 47

{
  "new_name": "new_field",
  "old_name": "old_field"
}
{}

create attachment schema within a workspace table

post

create attachment schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/attachment HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 21

{
  "name": "attachment"
}
{
  "name": "text"
}

create audio schema within a workspace table

post

create audio schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/audio HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "audio"
}
{
  "name": "text"
}

create bool schema within a workspace table

post

create bool schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultbooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/bool HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 35

{
  "name": "finished",
  "default": false
}
{
  "name": "text"
}

create date schema within a workspace table

post

create date schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/date HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 23

{
  "name": "completed_at"
}
{
  "name": "text"
}

create decimal schema within a workspace table

post

create decimal schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultnumberOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/decimal HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 30

{
  "name": "score",
  "default": 100
}
{
  "name": "text"
}

create email schema within a workspace table

post

create email schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultstringOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/email HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "email"
}
{
  "name": "text"
}

create enum schema within a workspace table

post

create enum schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultstringOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
valuesstring[]Optional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/enum HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 67

{
  "name": "status",
  "values": [
    "To Do",
    "In Progress",
    "Done",
    "Pending"
  ]
}
{
  "name": "text"
}

create geo_linestring schema within a workspace table

post

create geo_linestring schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_linestring HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "name": "line"
}
{
  "name": "text"
}

create geo_multilinestring schema within a workspace table

post

create geo_multilinestring schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_multilinestring HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "lines"
}
{
  "name": "text"
}

create geo_multipoint schema within a workspace table

post

create geo_multipoint schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_multipoint HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 17

{
  "name": "points"
}
{
  "name": "text"
}

create geo_multipolygon schema within a workspace table

post

create geo_multipolygon schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_multipolygon HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 19

{
  "name": "polygons"
}
{
  "name": "text"
}

create geo_point schema within a workspace table

post

create geo_point schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_point HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "point"
}
{
  "name": "text"
}

create geo_polygon schema within a workspace table

post

create geo_polygon schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
sensitivebooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/geo_polygon HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 18

{
  "name": "polygon"
}
{
  "name": "text"
}

create image schema within a workspace table

post

create image schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/image HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "image"
}
{
  "name": "text"
}

create int schema within a workspace table

post

create int schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultinteger · int64Optional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/int HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 30

{
  "name": "score",
  "default": 100
}
{
  "name": "text"
}

create json schema within a workspace table

post

create json schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/json HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "name": "data"
}
{
  "name": "text"
}

create object schema within a workspace table

post

create object schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
childrenobjectOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/object HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 89

{
  "name": "group",
  "children": [
    {
      "name": "name",
      "type": "text"
    },
    {
      "name": "score",
      "type": "int"
    }
  ]
}
{
  "name": "text"
}

create password reference schema within a workspace table

post

create password reference schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/password HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 88

{
  "name": "password",
  "filters": {
    "min": 8,
    "max": 64,
    "minAlpha": 1,
    "minDigit": 1,
    "minSymbol": 1
  }
}
{
  "name": "text"
}

create table reference schema within a workspace table

post

create table reference schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
tableref_idinteger · int64Required
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/tablerefuuid HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 36

{
  "name": "user_id",
  "tableref_id": 101
}
{
  "name": "text"
}

create table reference schema within a workspace table

post

create table reference schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
tableref_idinteger · int64Required
nullablebooleanOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/tableref HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 36

{
  "name": "user_id",
  "tableref_id": 101
}
{
  "name": "text"
}

create text schema within a workspace table

post

create text schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultstringOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
formatstring · enumOptionalPossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/text HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 49

{
  "name": "name",
  "filters": {
    "trim": true,
    "max": 100
  }
}
{
  "name": "text"
}

create timestamp schema within a workspace table

post

create timestamp schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/timestamp HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 23

{
  "name": "completed_at"
}
{
  "name": "text"
}

create uuid schema within a workspace table

post

create uuid schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultinteger · int64Optional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/uuid HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 18

{
  "name": "user_id"
}
{
  "name": "text"
}

create vector schema within a workspace table

post

create vector schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptional
defaultstringOptional
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/vector HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 35

{
  "name": "name",
  "vector": {
    "size": 3
  }
}
{
  "name": "text"
}

create video schema within a workspace table

post

create video schema within a workspace table Authentication: required Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
nullablebooleanOptionalDefault: true
requiredbooleanOptional
accessstring · enumOptionalDefault: publicPossible values:
sensitivebooleanOptional
stylestring · enumOptionalDefault: singlePossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table/{table_id}/schema/type/video HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 16

{
  "name": "video"
}
{
  "name": "text"
}

delete a specific schema element within workspace table

delete

delete a specific schema element within workspace table Authentication: required Required API Scope: Workspace Database: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
schema_namestringRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/table/{table_id}/schema/{schema_name} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

get a specific schema element within workspace table

get

get a specific schema element within workspace table Authentication: required Required API Scope: Workspace Database: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
schema_namestringRequired
Responses
200
Success!
application/json
Responseobject
get
GET /api:meta/workspace/{workspace_id}/table/{table_id}/schema/{schema_name} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

browse workspace table's schema

get

browse workspace table's schema Authentication: required Required API Scope: Workspace Database: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
get
GET /api:meta/workspace/{workspace_id}/table/{table_id}/schema HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

replace the entire schema of a workspace table

put

replace the entire schema of a workspace table Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
schemaobjectRequired
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/schema HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 458

{
  "schema": [
    {
      "name": "id",
      "type": "int",
      "description": "",
      "nullable": false,
      "default": "",
      "required": true,
      "access": "public",
      "sensitive": false,
      "style": "single"
    },
    {
      "name": "created_at",
      "type": "timestamp",
      "description": "",
      "nullable": false,
      "default": "",
      "required": true,
      "access": "public",
      "sensitive": false,
      "style": "single"
    },
    {
      "name": "name",
      "type": "text",
      "description": "",
      "nullable": false,
      "default": "",
      "required": true,
      "access": "public",
      "sensitive": false,
      "style": "single"
    }
  ]
}
{}

update workspace table's security settings

put

update workspace table's security settings Authentication: required Required API Scope: Workspace Database: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Body
guidstring | nullableOptional
Responses
200
Success!
application/json
Responseobject
put
PUT /api:meta/workspace/{workspace_id}/table/{table_id}/security HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "guid": "text"
}
{}

truncate table's content and optionally reset the primary key

delete

truncate table's content and optionally reset the primary key Authentication: required Required API Scope: Workspace Content: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Header parameters
x-data-sourcestringOptionalDefault: live
Body
resetbooleanRequired
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/table/{table_id}/truncate HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 14

{
  "reset": true
}
{}

delete workspace table and all of its content

delete

delete workspace table and all of its content Authentication: required Required API Scope: Workspace Database: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/table/{table_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

get workspace table

get

get workspace table Authentication: required Required API Scope: Workspace Database: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
table_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/table/{table_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
[
  {
    "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": [
      "text"
    ]
  }
]

browse workspace tables

get

browse workspace tables Authentication: required Required API Scope: Workspace Database: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Query parameters
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/table HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
[
  {
    "curPage": 1,
    "nextPage": 1,
    "prevPage": 1,
    "items": [
      {
        "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": [
          "text"
        ]
      }
    ]
  }
]

create workspace table

post

This endpoint can create a complete table in a single API request, as long as all values below are fully fleshed out. If you want to create the table in multiple steps, then just fill out the name field as shown in the example. Required API Scope: Workspace Database: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
namestringRequired
descriptionstringOptional
docsstringOptional
authbooleanOptional
guidstring | nullableOptional
schemaobject | nullableOptional
indexobject | nullableOptional
tagstring[] | nullableOptional
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/table HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 129

{
  "name": "new table 123",
  "description": "",
  "docs": "",
  "auth": null,
  "guid": null,
  "schema": null,
  "index": null,
  "autocomplete": [],
  "tag": []
}
{
  "id": "text"
}

Functions

get workspace function

get

get workspace function Authentication: required Required API Scope: Workspace Function: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
function_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/function/{function_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Function Test",
  "description": "My functions description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "branch": "v1",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}

add workspace function

post

add workspace function Authentication: required Required API Scope: Workspace Function: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
branchstringOptional
descriptionstringRequired
docsstringOptional
namestringRequired
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/function HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 66

{
  "branch": "text",
  "description": "text",
  "docs": "text",
  "name": "text"
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Function Test",
  "description": "My functions description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "branch": "v1",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}

delete workspace function

delete

delete workspace function Authentication: required Required API Scope: Workspace Function: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
function_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/function/{function_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update workspace function

put

update workspace function Authentication: required Required API Scope: Workspace Function: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
function_idinteger · int64Required
Body
namestringRequired
descriptionstringRequired
docsstringOptional
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/function/{function_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 172

{
  "name": "text",
  "description": "text",
  "docs": "text",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Function Test",
  "description": "My functions description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "branch": "v1",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}

browse workspace functions

get

browse workspace functions Authentication: required Required API Scope: Workspace Function: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Query parameters
branchstringOptional
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/function HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "id": 1,
      "created_at": "2023-04-19 21:01:32+0000",
      "updated_at": "2023-04-19 21:01:32+0000",
      "name": "Function Test",
      "description": "My functions description",
      "docs": "Documentation",
      "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
      "branch": "v1",
      "cache": {
        "active": true,
        "ttl": 3600,
        "input": true,
        "auth": true,
        "datasource": true,
        "ip": true,
        "headers": [
          "text"
        ],
        "env": [
          "text"
        ]
      }
    }
  ]
}

update workspace function security settings

put

update workspace function security settings Authentication: required Required API Scope: Workspace Function: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
function_idinteger · int64Required
Body
guidstringRequired
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/function/{function_id}/security HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "guid": "text"
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Function Test",
  "description": "My functions description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "branch": "v1",
  "cache": {
    "active": true,
    "ttl": 3600,
    "input": true,
    "auth": true,
    "datasource": true,
    "ip": true,
    "headers": [
      "text"
    ],
    "env": [
      "text"
    ]
  }
}

Tasks

get workspace task

get

get workspace task Authentication: required Required API Scope: Workspace Task: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
task_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/task/{task_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Task Test",
  "description": "My tasks description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "datasource": "test",
  "active": true,
  "branch": "v1"
}

add workspace task

post

add workspace task Authentication: required Required API Scope: Workspace Task: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
branchstringOptional
namestringRequired
descriptionstringRequired
docsstringOptional
datasourcestringRequired
activebooleanRequired
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/task HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 100

{
  "branch": "text",
  "name": "text",
  "description": "text",
  "docs": "text",
  "datasource": "text",
  "active": true
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Task Test",
  "description": "My tasks description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "datasource": "test",
  "active": true,
  "branch": "v1"
}

delete workspace task

delete

delete workspace task Authentication: required Required API Scope: Workspace Task: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
task_idinteger · int64Required
Responses
200
Success!
application/json
Responseobject
delete
DELETE /api:meta/workspace/{workspace_id}/task/{task_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{}

update workspace task

put

update workspace task Authentication: required Required API Scope: Workspace Task: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
task_idinteger · int64Required
Body
namestringRequired
descriptionstringRequired
docsstringOptional
datasourcestringRequired
activebooleanRequired
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/task/{task_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 84

{
  "name": "text",
  "description": "text",
  "docs": "text",
  "datasource": "text",
  "active": true
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Task Test",
  "description": "My tasks description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "datasource": "test",
  "active": true,
  "branch": "v1"
}

browse workspace tasks

get

browse workspace tasks Authentication: required Required API Scope: Workspace Task: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Query parameters
branchstringOptional
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/task HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "id": 1,
      "created_at": "2023-04-19 21:01:32+0000",
      "updated_at": "2023-04-19 21:01:32+0000",
      "name": "Task Test",
      "description": "My tasks description",
      "docs": "Documentation",
      "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
      "datasource": "test",
      "active": true,
      "branch": "v1"
    }
  ]
}

update workspace task security settings

put

update workspace task security settings Authentication: required Required API Scope: Workspace Task: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
task_idinteger · int64Required
Body
guidstringRequired
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/task/{task_id}/security HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "guid": "text"
}
{
  "id": 1,
  "created_at": "2023-04-19 21:01:32+0000",
  "updated_at": "2023-04-19 21:01:32+0000",
  "name": "Task Test",
  "description": "My tasks description",
  "docs": "Documentation",
  "guid": "YE1fwVhQ-enRlc6Sb42Gqru58-0",
  "datasource": "test",
  "active": true,
  "branch": "v1"
}

Files

list files within workspace

get

list files within workspace Authentication: required Required API Scope: Workspace File: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Query parameters
pageinteger · int64Optional
per_pageinteger · int64Optional
searchstringOptional
accessstring · enumOptionalPossible values:
sortstring · enumOptionalPossible values:
orderstring · enumOptionalPossible values:
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/file HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "curPage": 1,
  "nextPage": 1,
  "prevPage": 1,
  "items": [
    {
      "id": 10095,
      "created_at": "2023-04-19 21:01:32+0000",
      "name": "file_example_MP3_1MG.mp3",
      "size": 1087849,
      "type": "audio",
      "mime": "audio/mpeg",
      "access": "public",
      "path": "/vault/Ramtdv50/3TA6XKsmLe-2BigGnwxSb0v00sI/qSWtbg../file_example_MP3_1MG.mp3"
    }
  ]
}

upload file to workspace

post

upload file to workspace Authentication: required Required API Scope: Workspace File: Create

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
contentstring · binaryRequired
typestring · enumOptionalPossible values:
accessstring · enumOptionalDefault: publicPossible values:
Responses
200
Success!
application/json
post
POST /api:meta/workspace/{workspace_id}/file HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: multipart/form-data
Accept: */*
Content-Length: 53

{
  "content": "binary",
  "type": "image",
  "access": "public"
}
{
  "id": 10095,
  "created_at": "2023-04-19 21:01:32+0000",
  "name": "file_example_MP3_1MG.mp3",
  "size": 1087849,
  "type": "audio",
  "mime": "audio/mpeg",
  "access": "public",
  "path": "/vault/Ramtdv50/3TA6XKsmLe-2BigGnwxSb0v00sI/qSWtbg../file_example_MP3_1MG.mp3"
}

delete file within workspace

delete

delete file within workspace Authentication: required Required API Scope: Workspace File: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
file_idinteger · int64Required
Responses
200
Success!
application/json
Responseany | nullableDefault: null
delete
DELETE /api:meta/workspace/{workspace_id}/file/{file_id} HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*

No content

bulk delete files within workspace

delete

bulk delete files within workspace Authentication: required Required API Scope: Workspace File: Delete

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
idsinteger · int64[]Required
Responses
200
Success!
application/json
Responseany | nullableDefault: null
delete
DELETE /api:meta/workspace/{workspace_id}/file/bulk_delete HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 11

{
  "ids": [
    1
  ]
}

No content

Realtime

get workspace realtime details

get

get workspace realtime details Authentication: required Required API Scope: Instance Workspace: Read

Authorizations
Path parameters
workspace_idinteger · int64Required
Responses
200
Success!
application/json
get
GET /api:meta/workspace/{workspace_id}/realtime HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Accept: */*
{
  "enabled": true,
  "hash": "Dl3HlakmBZDhezv6yml7hliTM20",
  "channels": [
    {
      "anonymous_clients": true,
      "client_authenticated_messaging": true,
      "client_private_messaging": true,
      "client_private_messaging_authenticated_only": true,
      "client_public_messaging": true,
      "client_public_messaging_authenticated_only": true,
      "description": "text",
      "enabled": true,
      "id": 1,
      "pattern": "text",
      "presence": true,
      "wildcard": true
    }
  ]
}

update workspace realtime settings

put

update workspace realtime settings Authentication: required Required API Scope: Instance Workspace: Update

Authorizations
Path parameters
workspace_idinteger · int64Required
Body
enabledbooleanOptional
hashstringOptional
Responses
200
Success!
application/json
put
PUT /api:meta/workspace/{workspace_id}/realtime HTTP/1.1
Host: xxsw-1d5c-nopq.n7d.xano.io
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 376

{
  "enabled": true,
  "hash": "text",
  "channels": [
    {
      "anonymous_clients": true,
      "client_authenticated_messaging": true,
      "client_private_messaging": true,
      "client_private_messaging_authenticated_only": true,
      "client_public_messaging": true,
      "client_public_messaging_authenticated_only": true,
      "description": "text",
      "enabled": true,
      "history": 0,
      "id": 1,
      "pattern": "text",
      "presence": true,
      "wildcard": true
    }
  ]
}
{
  "enabled": true,
  "hash": "Dl3HlakmBZDhezv6yml7hliTM20",
  "channels": [
    {
      "anonymous_clients": true,
      "client_authenticated_messaging": true,
      "client_private_messaging": true,
      "client_private_messaging_authenticated_only": true,
      "client_public_messaging": true,
      "client_public_messaging_authenticated_only": true,
      "description": "text",
      "enabled": true,
      "id": 1,
      "pattern": "text",
      "presence": true,
      "wildcard": true
    }
  ]
}

The Metadata API is flexible regarding sending input values. You only need to send the values required to process your request. For example, if you are updating a schema and want to just update the name, then you only need to send the updated name and the other metadata of the schema will remain unchanged.

Last updated

Was this helpful?