QueryResult

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/cdata/main/json-schema/cdata-query-result-schema.json",
  "title": "QueryResult",
  "x-generated": "2026-10-04",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/cdata-metadata-api-openapi.yml#/components/schemas/QueryResult",
  "type": "object",
  "properties": {
    "results": {
      "type": [
        "array",
        "null"
      ],
      "items": {
        "$ref": "#/$defs/ResultSet"
      }
    },
    "error": {
      "$ref": "#/$defs/ErrorDetail"
    }
  },
  "additionalProperties": false,
  "$defs": {
    "ColumnInfo": {
      "type": "object",
      "properties": {
        "catalogName": {
          "type": [
            "string",
            "null"
          ],
          "description": "The name of the catalog containing the column."
        },
        "columnLabel": {
          "type": [
            "string",
            "null"
          ],
          "description": "The label of the column."
        },
        "columnName": {
          "type": [
            "string",
            "null"
          ],
          "description": "The name of the column."
        },
        "dataType": {
          "$ref": "#/$defs/DataType"
        },
        "dataTypeName": {
          "type": [
            "string",
            "null"
          ],
          "description": "The data type name of the column."
        },
        "length": {
          "type": "integer",
          "format": "int32",
          "description": "The length of the column."
        },
        "nullable": {
          "type": "boolean",
          "description": "Whether the column is nullable."
        },
        "ordinal": {
          "type": "integer",
          "format": "int32",
          "description": "The ordinal position of the column."
        },
        "precision": {
          "type": [
            "integer",
            "null"
          ],
          "format": "int32",
          "description": "The precision of the column."
        },
        "scale": {
          "type": [
            "integer",
            "null"
          ],
          "format": "int32",
          "description": "The scale of the column."
        },
        "schemaName": {
          "type": [
            "string",
            "null"
          ],
          "description": "The name of the schema containing the column."
        },
        "tableName": {
          "type": [
            "string",
            "null"
          ],
          "description": "The name of the table containing the column."
        }
      },
      "additionalProperties": false
    },
    "DataType": {
      "enum": [
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13,
        14,
        15,
        16,
        17,
        18
      ],
      "type": "integer",
      "description": "The parameter's [data type](/en/API/REST-API#data-types).",
      "format": "int32"
    },
    "ErrorCode": {
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13,
        14,
        15,
        16,
        17,
        18,
        19,
        20,
        21,
        22,
        23,
        24,
        25,
        26,
        27,
        28,
        29,
        30,
        31,
        32,
        33,
        34,
        35,
        36,
        37,
        38,
        39,
        40,
        41,
        42,
        43,
        44,
        45,
        46,
        47,
        48,
        49,
        50,
        51,
        52,
        53,
        54,
        55,
        56,
        57,
        58,
        59,
        60,
        61,
        62,
        63,
        64,
        65,
        66,
        67,
        68,
        69,
        70,
        71,
        72,
        73,
        74,
        75,
        76,
        77,
        78,
        79
      ],
      "type": "integer",
      "format": "int32"
    },
    "ErrorDetail": {
      "type": "object",
      "properties": {
        "code": {
          "$ref": "#/$defs/ErrorCode"
        },
        "message": {
          "type": [
            "string",
            "null"
          ],
          "description": "The error message."
        }
      },
      "additionalProperties": false
    },
    "ResultSet": {
      "type": "object",
      "properties": {
        "affectedRows": {
          "type": "integer",
          "format": "int32",
          "description": "The number of rows affected by the query, or -1 if not applicable."
        },
        "schema": {
          "type": [
            "array",
            "null"
          ],
          "items": {
            "$ref": "#/$defs/ColumnInfo"
          }
        },
        "rows": {
          "type": [
            "array",
            "null"
          ],
          "items": {
            "type": "array",
            "items": {}
          }
        }
      },
      "additionalProperties": false
    }
  }
}