Help Center> Data Lake Insight> API Reference> SQL Template-related APIs> Deleting a SQL template
Updated on 2023-11-27 GMT+08:00
View PDF

Deleting a SQL template

Function

This API is used to delete SQL templates in batches.

URI

  • URI format

    POST /v1.0/{project_id}/sqls-deletion

  • Parameter description
    Table 1 URI parameter

    Parameter

    Mandatory

    Type

    Description

    project_id

    Yes

    String

    Project ID, which is used for resource isolation. For details about how to obtain its value, see Obtaining a Project ID.

Request

Table 2 Parameters

Parameter

Mandatory

Type

Description

sql_ids

Yes

Array<String>

IDs of SQL templates you want to delete.

Response

Table 3 Parameters

Parameter

Type

Description

is_success

Boolean

Whether the request is successful.

message

String

System prompt. If execution succeeds, the message may be left blank. If the execution fails, the value will be the cause of the failure.

Example Request

Delete the SQL template whose ID is 27b79c50-4ac6-4050-8b81-8f0dbd7be184.

{
    "sql_ids": ["27b79c50-4ac6-4050-8b81-8f0dbd7be184"]
}

Example Response

{
  "is_success": true,
  "message": ""
}

Status Codes

Status Code

Description

200

OK

Error Codes

For details, see Error Codes.