Skip to main content

Execute MySQL command

POST 
/v1/model/plugin/prod/mysqlCommand

Execute MySQL command, authentication only supports: Management Token, API Key

Request​

Body

required
    sqlTemplate stringrequired

    SQL statement (can carry parameters, parameters named {{ var }}), for example: select * from table_name where _id = {{ _id }}

    parameter object[]

    Query parameters, optional. If sqlTemplate carries parameters, this parameter needs to be passed

  • Array [
    • key string

    Parameter key, e.g., _id

    type string

    Parameter type, e.g., STRING, NUMBER, ARRAY, BOOLEAN, OBJECT

    value string

    Parameter value, e.g., o8L3N6y, 123, [1,2,3], true, {name: 'foo'}

  • ]
    • config object

    RunMysqlCommand configuration, optional, e.g., {"preparedStatements":true}

    timeout integer

    Possible values: <= 30

    Default value: 5

    Timeout setting 5s

    preparedStatements boolean

    Whether to enable prepared statements

    dbLinkName string

    Data connector Name configuration

Responses​

Success

Schema
    oneOf
    data object
    backendExecute string

    Backend Execution Time (ms)

    executeResultList array

    Execution Result List

    total integer

    Total Count

    requestId string

    Unique Request ID

Loading...