QueryResult

Results from an Aladdin Data Cloud query execution

FinancialInvestment ManagementPortfolio AnalyticsRisk ManagementAsset ManagementBlackRockData Cloud

Properties

Name	Type	Description
queryId	string	Unique query execution identifier
status	string	Query execution status
rowCount	integer	Number of rows returned
columns	array	Column definitions
rows	array	Result rows as arrays

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/aladdin-studio/refs/heads/main/json-schema/aladdin-studio-data-cloud-query-result-schema.json",
  "title": "QueryResult",
  "description": "Results from an Aladdin Data Cloud query execution",
  "type": "object",
  "properties": {
    "queryId": {
      "type": "string",
      "description": "Unique query execution identifier",
      "example": "qry-a1b2c3d4"
    },
    "status": {
      "type": "string",
      "description": "Query execution status",
      "enum": [
        "completed",
        "running",
        "failed"
      ],
      "example": "completed"
    },
    "rowCount": {
      "type": "integer",
      "description": "Number of rows returned",
      "example": 100
    },
    "columns": {
      "type": "array",
      "description": "Column definitions",
      "items": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "example": "PORTFOLIO_ID"
          },
          "type": {
            "type": "string",
            "example": "VARCHAR"
          }
        }
      }
    },
    "rows": {
      "type": "array",
      "description": "Result rows as arrays",
      "items": {
        "type": "array",
        "items": {}
      }
    }
  }
}