Executes an SQL data query script task.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
stream:StartSqlExecution |
none |
*All Resource
|
None | None |
Request syntax
POST /api/v2/namespaces/{namespace}/sql-execution HTTP/1.1
Path Parameters
|
Parameter |
Type |
Required |
Description |
Example |
| namespace |
string |
No |
The namespace name. |
default-namespace |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| workspace |
string |
Yes |
The workspace ID. |
a14bda1c4a**** |
| body | StartSqlExecutionBody |
No |
The request body, which contains the SQL content to execute and description information. |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response data. |
||
| requestId |
string |
The request ID. |
CBC799F0-AS7S-1D30-8A4F-882ED4DD**** |
| success |
boolean |
Indicates whether the business request is successful. |
True |
| httpCode |
integer |
The business status code, which is always 200. Use success to determine whether the business request is successful. |
200 |
| errorCode |
string |
The business error code. This parameter is not empty when success is false, and is empty when success is true. |
"" |
| errorMessage |
string |
The business error message. This parameter is not empty when success is false, and is empty when success is true. |
"" |
| data | StartSqlExecutionResult |
The complete SQL script information returned upon success. This parameter is valid when success is true. |
See the response example |
Examples
Success response
JSON format
{
"requestId": "CBC799F0-AS7S-1D30-8A4F-882ED4DD****",
"success": true,
"httpCode": 200,
"errorCode": "\"\"",
"errorMessage": "\"\"",
"data": {
"newlyCreated": false,
"sqlExecutionId": "",
"success": false
}
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.