Update Table Data
最新の更新：
Update Table Data
This interface allows you to update the values of specific records in the Bot data table.
Request Method
POST
Endpoint
https://api.gptbots.ai/v1/database/update/record
Authentication
For details, refer to the API Overview for authentication methods.
Request
Request Example
curl -X POST https://api.gptbots.ai/v1/database/update/record \
-H 'Authorization: Bearer your_apikey' \
-H 'Content-Type: application/json' \
-d '{
"table_id": "673af861ed69656ac0895b07"
"record_id":"123456" //Choose either record_id or filter condition
"filter": {
"id": "789"
},
"updated_fields": {
"name": "99990",
"age": "30"
},
}'
curl -X POST https://api.gptbots.ai/v1/database/update/record \
-H 'Authorization: Bearer your_apikey' \
-H 'Content-Type: application/json' \
-d '{
"table_id": "673af861ed69656ac0895b07"
"record_id":"123456" //Choose either record_id or filter condition
"filter": {
"id": "789"
},
"updated_fields": {
"name": "99990",
"age": "30"
},
}'
このコードブロックは、フローティングウィンドウに表示されます
Request Headers
| Field | Type | Description |
|---|---|---|
| Authorization | Bearer ${token} | Use Authorization: Bearer ${token} for authentication. Obtain the token from the API key page. |
| Content-Type | application/json | Data type, set to application/json. |
Request Body
| Field | Type | Required | Description |
|---|---|---|---|
| table_id | string | Yes | Table ID. |
| record_id | string | No | Record ID or filter condition, choose one. Record ID is recommended. |
| filter | map | No | User-defined filter condition (e.g., custom unique primary key). |
| updated_fields | list | Yes | Set of data to be updated. |
Response
Response Example
{
"code": 0,
"message": "OK"
}
{
"code": 0,
"message": "OK"
}
このコードブロックは、フローティングウィンドウに表示されます
Success Response
| Field | Type | Description |
|---|---|---|
| code | int | Type code of the message. |
| message | string | Message description. |
| data | object | Response content, which includes the unique identifier of the data table. |
Failure Response
| Field | Type | Description |
|---|---|---|
| code | int | Error code. |
| message | string | Error details. |
Error Codes
| Code | Message |
|---|---|
| 40000 | Parameter error |
| 50000 | Internal system error |
| 403106 | Table not found |
| 403131 | No access to the data table |