API Overview

About REST APIs
Find Your Endpoint

Gateway (Secrets Proxy) Rest APIs

Overview
Gateway Authentication APIs
Gateway Biscuit APIs
Gateway Permission APIs
Gateway API Key APIs
Gateway SQL Proxy APIs
- Proxy Execute SQLpost
- Proxy Execute a content querypost

Security/Auth REST APIs

Authentication / Registration API
Wallet Authentication / Registration API
- Wallet Authentication Codepost
- Wallet Registration Codepost
Key Management API

SQL Operations REST APIs

Overview
SQL API
Encryption API
Tamperproof API
- Execute tamperproof queries (DQL)post

Resource Discovery REST APIs

Discovery API

GraphQL APIs

Overview
GraphQL API

Smart Contract Indexing REST APIs

Smart Contract Indexing API

Content REST APIs

App Config API
- Get app configget
Profile API
Tag API
- Get tagsget
- Get popular tagsget
Query API
Visual API
Dashboard API

Subscription REST APIs

Subscription API

User Activity REST APIs

Overview
Activity API

API Overview

About REST APIs
Find Your Endpoint

Gateway (Secrets Proxy) Rest APIs

Overview
Gateway Authentication APIs
Gateway Biscuit APIs
Gateway Permission APIs
Gateway API Key APIs
Gateway SQL Proxy APIs
- Proxy Execute SQLpost
- Proxy Execute a content querypost

Security/Auth REST APIs

Authentication / Registration API
Wallet Authentication / Registration API
- Wallet Authentication Codepost
- Wallet Registration Codepost
Key Management API

SQL Operations REST APIs

Overview
SQL API
Encryption API
Tamperproof API
- Execute tamperproof queries (DQL)post

Resource Discovery REST APIs

Discovery API

GraphQL APIs

Overview
GraphQL API

Smart Contract Indexing REST APIs

Smart Contract Indexing API

Content REST APIs

App Config API
- Get app configget
Profile API
Tag API
- Get tagsget
- Get popular tagsget
Query API
Visual API
Dashboard API

Subscription REST APIs

Subscription API

User Activity REST APIs

Overview
Activity API

Execute SQL

post https://api.spaceandtime.dev/v1/sql

Using this endpoint, you can execute any kind of SQL statement. If the validate flag is specified, the request will be validated against provided authorization inputs and referenced resource configuration. If validation fails for any reason, a 422 Unprocessable Entity will be returned with details about the original request and specifics on missing inputs. If the useEncryption flag is specified, data in DML statements will automatically be encrypted on the way in and results of queries will automatically be decrypted on the way out. Unlike the Proxy SQL API, this API is executed directly against the SxT Network and requires explicit configuration of authentication and authorization tokens.

URL Expired

The URL for this request expired after 30 days.

Body Params

sqlText

string

required

The raw SQL text to execute

biscuits

array of strings

The (optional) biscuits needed to authorize the request

biscuits

validate

boolean

Determines whether or not the request should be validated prior to execution

useEncryption

boolean

Determines whether or not to use encryption/decryption on the request

Headers

originApp

string

The origin application of the request. This header is used to tag requests in the query log

Responses

Response body

array of objects

object

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

resources

array of strings

The unique resource identifiers (e.g. SCHEMA_NAME.TABLE_NAME) referenced in the SQL text

resources

commandType

string

The type of the command specified in the SQL statement

DDL DML DQL

resourceType

string

The resource type (e.g. SCHEMA, TABLE, VIEW) referenced in the SQL text. Only provided for DDL statements

encrypted

boolean

If true, specifies that at least one the referenced resources is encrypted

requiredCapabilities

array of objects

Defines the list of capabilities required to authorize the provided SQL statement

requiredCapabilities

object

resourceId

string

The unique resource identifier (e.g. SCHEMA_NAME.TABLE_NAME)

operation

string

The SQL operation

Response body

object

type

string

URI reference that identifies the problem type

title

string

A short, human-readable summary of the problem type

detail

string

A human-readable explanation specific to this instance of the problem

instance

string

A URI reference that identifies the specific occurrence of the problem

Updated about 2 months ago

Overview

Configure Resources (DDL)

Did this page help you?

Language

Credentials

Bearer

JWT


xxxxxxxxxx
1
curl --request POST \
2
     --url https://api.spaceandtime.dev/v1/sql \
3
     --header 'accept: application/json' \
4
     --header 'content-type: application/json'

Click Try It! to start a request and see the response here! Or choose an example:

application/json

Updated about 2 months ago

Overview

Configure Resources (DDL)

Did this page help you?

API Overview
About REST APIs
Find Your Endpoint

Gateway (Secrets Proxy) Rest APIs
Overview
Gateway Authentication APIs
API Key Loginpost
Convert sessionpost
Refresh sessionpost
Reset passwordpost
Add account for existing userpost
Loginpost
Registerpost
Gateway Biscuit APIs
Remove user biscuitdelete
Get user biscuit by nameget
Add user biscuitpost
Get all user biscuitsget
Get all biscuitsget
Gateway Permission APIs
Get resource permissionsget
Get user permissionsget
Remove permissionsdelete
Set resource permissionsput
Gateway API Key APIs
Delete an API keydelete
Create API keypost
Get all API keysget
Gateway SQL Proxy APIs
Proxy Execute a content querypost
Proxy Execute SQLpost

Security/Auth REST APIs
Authentication / Registration API
User Identifier Checkget
Validate tokenget
Logoutpost
Token Refreshpost
Token Requestpost
Registration Codepost
Authentication Codepost
Wallet Authentication / Registration API
Wallet Registration Codepost
Wallet Authentication Codepost
Key Management API
Get public key challengepost
Add key to keychainpost
Get current keychainget

SQL Operations REST APIs
Overview
SQL API
Execute a content querypost
Get materialized view last refresh timepost
Refresh a materialized viewpost
Query a view by idpost
Configure dataset encryptionpost
Execute queries (DQL)post
Modify data (DML)post
Configure Resources (DDL)post
Execute SQLpost
Encryption API
Configure dataset encryptionpost
Modify encrypted data (DML)post
Execute queries (DQL) on encrypted datapost
Tamperproof API
Execute tamperproof queries (DQL)post

Resource Discovery REST APIs
Discovery API
Get blockchain informationget
Get blockchain schemasget
Get blockchainsget
Get aggregate blockchain infoget
Get viewsget
Get foreign key referencesget
Get primary key referencesget
Get table relationshipsget
Get table primary keysget
Get table indexesget
Get table columnsget
Get tablesget
Get schemasget

GraphQL APIs
Overview
GraphQL API
Delete GraphQL schemadelete
Update GraphQL schemaput
Retrieve GraphQL schemaget
Create GraphQL schemapost
Discover GraphQL schemasget
Execute GraphQLpost

Smart Contract Indexing REST APIs
Smart Contract Indexing API
Get smart contract event transactionspost
Request contract removaldelete
Request contract indexingpost
Get contract infopost
Get tracked contract infopost
Get latest contract infopost
Get indexed smart contractsget
Get smart contract schemasget
Get subscription indexed contractsget
Get supported blockchainsget

Content REST APIs
App Config API
Get app configget
Profile API
Delete user profiledelete
Set user profileput
Get user profileget
Tag API
Get popular tagsget
Get tagsget
Query API
Dislike querypost
Like querypost
Get my liked queriesget
Retrieve popular queriesget
Get query by slugget
Fork querypost
Publish querypost
Convert query to materialized viewpost
Delete querydelete
Update queryput
Get query by idget
Create querypost
Discover queriesget
Visual API
Dislike visualpost
Like visualpost
Get my liked visualsget
Retrieve popular visualsget
Get visual by slugget
Fork visualpost
Publish visualpost
Delete visualdelete
Update visualput
Get visual by idget
Create visualpost
Discover visualsget
Dashboard API
Get dashboard visuals contentget
Disassociate dashboard visualsdelete
Associate dashboard visualsput
Get dashboard visualsget
Dislike dashboardpost
Like dashboardpost
Get my liked dashboardsget
Retrieve popular dashboardsget
Get dashboard by slugget
Fork dashboardpost
Publish dashboardpost
Delete dashboarddelete
Update dashboardput
Get dashboard by idget
Create dashboardpost
Discover dashboardsget

Subscription REST APIs
Subscription API
Get default free query countget
Get current subscription free query countget
Get subscription credit unit offeringsget
Set subscription usage configurationput
Get subscription usage configurationget
Get current subscription balanceget
Leave subscriptionpost
Remove a userpost
Set user rolepost
Join subscriptionpost
Create subscription invitepost
Set subscription nameput
Get subscription usersget
Get subscription informationget

User Activity REST APIs
Overview
Activity API
Get subscription payment historyget
Get subscription usage activityget
Get user usage activityget
Get historical query activityget
Get recent query activityget

API Overview
About REST APIs
Find Your Endpoint

Gateway (Secrets Proxy) Rest APIs
Overview
Gateway Authentication APIs
API Key Loginpost
Convert sessionpost
Refresh sessionpost
Reset passwordpost
Add account for existing userpost
Loginpost
Registerpost
Gateway Biscuit APIs
Remove user biscuitdelete
Get user biscuit by nameget
Add user biscuitpost
Get all user biscuitsget
Get all biscuitsget
Gateway Permission APIs
Get resource permissionsget
Get user permissionsget
Remove permissionsdelete
Set resource permissionsput
Gateway API Key APIs
Delete an API keydelete
Create API keypost
Get all API keysget
Gateway SQL Proxy APIs
Proxy Execute a content querypost
Proxy Execute SQLpost

Security/Auth REST APIs
Authentication / Registration API
User Identifier Checkget
Validate tokenget
Logoutpost
Token Refreshpost
Token Requestpost
Registration Codepost
Authentication Codepost
Wallet Authentication / Registration API
Wallet Registration Codepost
Wallet Authentication Codepost
Key Management API
Get public key challengepost
Add key to keychainpost
Get current keychainget

SQL Operations REST APIs
Overview
SQL API
Execute a content querypost
Get materialized view last refresh timepost
Refresh a materialized viewpost
Query a view by idpost
Configure dataset encryptionpost
Execute queries (DQL)post
Modify data (DML)post
Configure Resources (DDL)post
Execute SQLpost
Encryption API
Configure dataset encryptionpost
Modify encrypted data (DML)post
Execute queries (DQL) on encrypted datapost
Tamperproof API
Execute tamperproof queries (DQL)post

Resource Discovery REST APIs
Discovery API
Get blockchain informationget
Get blockchain schemasget
Get blockchainsget
Get aggregate blockchain infoget
Get viewsget
Get foreign key referencesget
Get primary key referencesget
Get table relationshipsget
Get table primary keysget
Get table indexesget
Get table columnsget
Get tablesget
Get schemasget

GraphQL APIs
Overview
GraphQL API
Delete GraphQL schemadelete
Update GraphQL schemaput
Retrieve GraphQL schemaget
Create GraphQL schemapost
Discover GraphQL schemasget
Execute GraphQLpost

Smart Contract Indexing REST APIs
Smart Contract Indexing API
Get smart contract event transactionspost
Request contract removaldelete
Request contract indexingpost
Get contract infopost
Get tracked contract infopost
Get latest contract infopost
Get indexed smart contractsget
Get smart contract schemasget
Get subscription indexed contractsget
Get supported blockchainsget

Content REST APIs
App Config API
Get app configget
Profile API
Delete user profiledelete
Set user profileput
Get user profileget
Tag API
Get popular tagsget
Get tagsget
Query API
Dislike querypost
Like querypost
Get my liked queriesget
Retrieve popular queriesget
Get query by slugget
Fork querypost
Publish querypost
Convert query to materialized viewpost
Delete querydelete
Update queryput
Get query by idget
Create querypost
Discover queriesget
Visual API
Dislike visualpost
Like visualpost
Get my liked visualsget
Retrieve popular visualsget
Get visual by slugget
Fork visualpost
Publish visualpost
Delete visualdelete
Update visualput
Get visual by idget
Create visualpost
Discover visualsget
Dashboard API
Get dashboard visuals contentget
Disassociate dashboard visualsdelete
Associate dashboard visualsput
Get dashboard visualsget
Dislike dashboardpost
Like dashboardpost
Get my liked dashboardsget
Retrieve popular dashboardsget
Get dashboard by slugget
Fork dashboardpost
Publish dashboardpost
Delete dashboarddelete
Update dashboardput
Get dashboard by idget
Create dashboardpost
Discover dashboardsget

Subscription REST APIs
Subscription API
Get default free query countget
Get current subscription free query countget
Get subscription credit unit offeringsget
Set subscription usage configurationput
Get subscription usage configurationget
Get current subscription balanceget
Leave subscriptionpost
Remove a userpost
Set user rolepost
Join subscriptionpost
Create subscription invitepost
Set subscription nameput
Get subscription usersget
Get subscription informationget

User Activity REST APIs
Overview
Activity API
Get subscription payment historyget
Get subscription usage activityget
Get user usage activityget
Get historical query activityget
Get recent query activityget

200OK

400Bad Request

401Unauthorized

403Forbidden

404Not Found

422Unprocessable Entity

503Service Unavailable