Updates a dataset that is based on a custom SQL statement.
Try it now
Test
RAM authorization
Request syntax
POST HTTP/1.1Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| CubeId |
string |
Yes |
The ID of the dataset. |
7c7223ae-****-3c744528014b |
| CustomSql |
string |
Yes |
The custom SQL statement. |
select * from sdsd |
| WorkspaceId |
string |
Yes |
The ID of the workspace. |
95296e95-ca89-4c7d-8af9-dedf0ad0**** |
| UserId |
string |
Yes |
The ID of the Quick BI user. The user must have permissions to create datasets. This ID is not your Alibaba Cloud account ID. Call the QueryUserInfoByAccount operation to obtain the user ID. |
95296e95-ca89-4c7d-8af9-dedf0ad0**** |
| DsId |
string |
Yes |
The ID of the data source. |
7AAB95D-*****-****-*4FC0C976 |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
Schema of Response |
||
| RequestId |
string |
The request ID. |
617277******************ABA47E31 |
| Result |
boolean |
The result of the request. Valid values:
|
true |
| Success |
boolean |
Indicates whether the request was successful. Valid values:
|
true |
Examples
Success response
JSON format
{
"RequestId": "617277******************ABA47E31",
"Result": true,
"Success": true
}Error codes
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | Internal.System.Error | An internal system error occurred. | |
| 400 | Invalid.User.Organization | The user is not in your organization. | |
| 400 | User.NotIn.Workspace | The user is not a member of the group workspace. | |
| 400 | Workspace.NotIn.Organization | The workspace is not owned by the organization. | |
| 400 | Datasource.NotFound.Error | The specified data source does not exist: %s. | |
| 400 | Invalid.Param.Error | The parameter is invalid. | |
| 400 | Cube.Not.Exist | The Cube does not exist. | |
| 400 | CubeSchema.Not.Exist | The cube schema does not exist. | |
| 400 | Cube.DuplicatedName.Error | The dataset name already exists. Modify the name before saving. | |
| 400 | Directory.NotExist.Error | The directory does not exist. | |
| 400 | Xengnie.TaskExecute.Error | Fail to execute task %s. | |
| 400 | Datasource.Sql.ExecuteFailed | Failed to execute the SQL statement in the data source. |
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.