メインコンテンツへスキップ
POST
/
exec
Execute Procedure
curl --request POST \
  --url https://cloud.cdata.com/api/exec \
  --header 'Authorization: Basic <encoded-value>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "procedure": "<string>",
  "defaultCatalog": "<string>",
  "defaultSchema": "<string>",
  "parameters": {},
  "timeout": 150
}
'
{
  "results": [
    {
      "affectedRows": 123,
      "schema": [
        {
          "catalogName": "<string>",
          "columnLabel": "<string>",
          "columnName": "<string>",
          "dataType": 1,
          "dataTypeName": "<string>",
          "length": 123,
          "nullable": true,
          "ordinal": 123,
          "precision": 123,
          "scale": 123,
          "schemaName": "<string>",
          "tableName": "<string>"
        }
      ],
      "rows": [
        [
          "<unknown>"
        ]
      ]
    }
  ],
  "error": {
    "code": 0,
    "message": "<string>"
  }
}

Documentation Index

Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt

Use this file to discover all available pages before exploring further.

承認

Authorization
string
header
必須

Basic Authentication with username and password. Use your PAT as the password. You can get your PAT from Connect AI by selecting Settings > Access Tokens.

クエリパラメータ

workspace
string

If your query contains a workspace, the workspace name must be specified here.

ボディ

application/json
procedure
string
必須

The name of the stored procedure to execute. Must be a valid stored procedure name.

Minimum string length: 1
defaultCatalog
string | null
defaultSchema
string | null
parameters
object
timeout
integer<int32>
必須範囲: 1 <= x <= 300

レスポンス

200 - application/json

OK

results
object[] | null
error
object