GET
/
v1:adminExecute
{
  "results": [
    {
      "columnNames": [
        "<string>"
      ],
      "columnTypeNames": [
        "<string>"
      ],
      "rows": [
        {
          "values": [
            {
              "nullValue": "NULL_VALUE",
              "boolValue": true,
              "bytesValue": "<string>",
              "doubleValue": 123,
              "floatValue": 123,
              "int32Value": 123,
              "int64Value": "<string>",
              "stringValue": "<string>",
              "uint32Value": 123,
              "uint64Value": "<string>",
              "valueValue": "<any>",
              "timestampValue": {
                "googleTimestamp": "2023-11-07T05:31:56Z",
                "accuracy": 123
              },
              "timestampTzValue": {
                "googleTimestamp": "2023-11-07T05:31:56Z",
                "zone": "<string>",
                "offset": 123,
                "accuracy": 123
              }
            }
          ]
        }
      ],
      "rowsCount": "<string>",
      "masked": [
        true
      ],
      "sensitive": [
        true
      ],
      "error": "<string>",
      "latency": "<string>",
      "statement": "<string>",
      "postgresError": {
        "severity": "<string>",
        "code": "<string>",
        "message": "<string>",
        "detail": "<string>",
        "hint": "<string>",
        "position": 123,
        "internalPosition": 123,
        "internalQuery": "<string>",
        "where": "<string>",
        "schemaName": "<string>",
        "tableName": "<string>",
        "columnName": "<string>",
        "dataTypeName": "<string>",
        "constraintName": "<string>",
        "file": "<string>",
        "line": 123,
        "routine": "<string>"
      },
      "allowExport": true,
      "messages": [
        {
          "level": "LEVEL_UNSPECIFIED",
          "content": "<string>"
        }
      ]
    }
  ]
}

Query Parameters

​
name
string

The name is the instance name to execute the query against. Format: instances/{instance}/databases/{databaseName}

​
statement
string

The SQL statement to execute.

​
limit
integer

The maximum number of rows to return.

​
schema
string

The default schema to execute the statement. Equals to the current schema in Oracle and search path in Postgres.

​
container
string

Container is the container name to execute the query against, used for CosmosDB only.

Response

200
application/json

OK

The response is of type object.

GET
/
v1:adminExecute
{
  "results": [
    {
      "columnNames": [
        "<string>"
      ],
      "columnTypeNames": [
        "<string>"
      ],
      "rows": [
        {
          "values": [
            {
              "nullValue": "NULL_VALUE",
              "boolValue": true,
              "bytesValue": "<string>",
              "doubleValue": 123,
              "floatValue": 123,
              "int32Value": 123,
              "int64Value": "<string>",
              "stringValue": "<string>",
              "uint32Value": 123,
              "uint64Value": "<string>",
              "valueValue": "<any>",
              "timestampValue": {
                "googleTimestamp": "2023-11-07T05:31:56Z",
                "accuracy": 123
              },
              "timestampTzValue": {
                "googleTimestamp": "2023-11-07T05:31:56Z",
                "zone": "<string>",
                "offset": 123,
                "accuracy": 123
              }
            }
          ]
        }
      ],
      "rowsCount": "<string>",
      "masked": [
        true
      ],
      "sensitive": [
        true
      ],
      "error": "<string>",
      "latency": "<string>",
      "statement": "<string>",
      "postgresError": {
        "severity": "<string>",
        "code": "<string>",
        "message": "<string>",
        "detail": "<string>",
        "hint": "<string>",
        "position": 123,
        "internalPosition": 123,
        "internalQuery": "<string>",
        "where": "<string>",
        "schemaName": "<string>",
        "tableName": "<string>",
        "columnName": "<string>",
        "dataTypeName": "<string>",
        "constraintName": "<string>",
        "file": "<string>",
        "line": 123,
        "routine": "<string>"
      },
      "allowExport": true,
      "messages": [
        {
          "level": "LEVEL_UNSPECIFIED",
          "content": "<string>"
        }
      ]
    }
  ]
}

Query Parameters

​
name
string

The name is the instance name to execute the query against. Format: instances/{instance}/databases/{databaseName}

​
statement
string

The SQL statement to execute.

​
limit
integer

The maximum number of rows to return.

​
schema
string

The default schema to execute the statement. Equals to the current schema in Oracle and search path in Postgres.

​
container
string

Container is the container name to execute the query against, used for CosmosDB only.

Response

200
application/json

OK

The response is of type object.