Roe AI · Schema

GetV1DatabaseQueryQueryidResultResponse

CompanyAIFraudDetectionAMLFinTechDataAnalytics

Properties

Name Type Description
worksheet_query_id string
status string
results array
error string
View JSON Schema on GitHub

JSON Schema

roe-ai-get-v1-database-query-queryid-result-response-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/roe-ai/json-schema/roe-ai-get-v1-database-query-queryid-result-response-schema.json",
  "title": "GetV1DatabaseQueryQueryidResultResponse",
  "x-generated": "2026-10-29",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/_ae-authored/roe-ai-openapi-generated.yml#/components/schemas/GetV1DatabaseQueryQueryidResultResponse",
  "type": "object",
  "properties": {
    "worksheet_query_id": {
      "type": "string"
    },
    "status": {
      "type": "string"
    },
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "query": {
            "type": "string"
          },
          "summary": {
            "type": "object",
            "properties": {
              "read_rows": {
                "type": "integer"
              },
              "read_bytes": {
                "type": "integer"
              },
              "written_rows": {
                "type": "integer"
              },
              "written_bytes": {
                "type": "integer"
              },
              "total_rows_to_read": {
                "type": "integer"
              },
              "result_rows": {
                "type": "integer"
              },
              "result_bytes": {
                "type": "integer"
              },
              "elapsed_ns": {
                "type": "integer"
              },
              "query_id": {
                "type": "string"
              }
            }
          },
          "row_count": {
            "type": "integer"
          },
          "column_names": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "column_types": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "result_rows": {
            "type": "array",
            "items": {
              "type": "array",
              "items": {
                "type": "string"
              }
            }
          },
          "start_timestamp": {
            "type": "integer"
          },
          "end_timestamp": {
            "type": "integer"
          },
          "query_id": {
            "type": "string"
          }
        }
      }
    },
    "error": {
      "type": "string"
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema 
curl "https://apis.io/api/v1/json-schemas/roe-ai-get-v1-database-query-queryid-result-response"
All schemas 
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.