メインコンテンツへスキップ
GET
/
procedures
List Procedures
curl --request GET \
  --url https://cloud.cdata.com/api/procedures \
  --header 'Authorization: Basic <encoded-value>'
{
  "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>"
  }
}

承認

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
catalogName
string

Restricts results to the specified catalog.

schemaName
string

Restricts results to the specified schema.

procedureName
string

Restricts results to the specified procedure.

レスポンス

200 - application/json

OK

results
object[] | null
error
object