Create Database Table
Create Database Table
Supports creating new database tables and their fields for the Agent via this API.
Request Method
POST
Endpoint
https://api-${endpoint}.gptbots.ai/v1/database/create-table
Authentication
For details, refer to the authentication method description in API Overview.
Request
Request Example
curl -X POST 'https://api-${endpoint}.gptbots.ai/v1/database/create-table' \
-H 'Authorization: Bearer ${API Key}' \
-H 'Content-Type: application/json' \
-d '{
"name": "test_api",
"description": "Test all database APIs",
"fields": [
{
"name": "id",
"description": "id",
"type": "TEXT",
"required": true,
"unique": true
},
{
"name": "boolean",
"description": "boolean",
"type": "BOOLEAN",
"required": true,
"unique": false
},
{
"name": "int",
"description": "int",
"type": "INT",
"required": true,
"unique": true
},
{
"name": "datetime",
"description": "datetime",
"type": "DATETIME",
"required": true,
"unique": false
},
{
"name": "float",
"description": "float",
"type": "FLOAT",
"required": false,
"unique": false
}
]
}'
curl -X POST 'https://api-${endpoint}.gptbots.ai/v1/database/create-table' \
-H 'Authorization: Bearer ${API Key}' \
-H 'Content-Type: application/json' \
-d '{
"name": "test_api",
"description": "Test all database APIs",
"fields": [
{
"name": "id",
"description": "id",
"type": "TEXT",
"required": true,
"unique": true
},
{
"name": "boolean",
"description": "boolean",
"type": "BOOLEAN",
"required": true,
"unique": false
},
{
"name": "int",
"description": "int",
"type": "INT",
"required": true,
"unique": true
},
{
"name": "datetime",
"description": "datetime",
"type": "DATETIME",
"required": true,
"unique": false
},
{
"name": "float",
"description": "float",
"type": "FLOAT",
"required": false,
"unique": false
}
]
}'
บล็อกโค้ดนี้ในหน้าต่างลอย
Request Headers
| Field | Type | Description |
|---|---|---|
| Authorization | Bearer ${API Key} | Use Authorization: Bearer ${API Key} for authentication. Get API key from API Key page. |
| Content-Type | application/json | Data type, set to application/json. |
Request Parameters
| Field | Type | Required | Description |
|---|---|---|---|
| name | string | Yes | Table name: 32 characters, a~z/numbers and underscores, starting with a letter. |
| description | string | Yes | Table description: 128 characters, to help LLM understand the data structure of the table. |
| fields | array | Yes | Array of table fields. |
| fields[].name | string | Yes | Field name: 32 characters, a~z/numbers and underscores. |
| fields[].description | string | Yes | Field description: 128 characters, to help LLM understand the data structure of the table. |
| fields[].type | string | Yes | Data type: TEXT/INT/FLOAT/DATETIME/BOOLEAN. |
| fields[].required | boolean | No | Required: true/false. |
| fields[].unique | boolean | No | Unique: true |