{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Executes a SQL query scoped to the account in the request path. API Gateway preserves the account path, and SQL API requires it to match the signed JWT account, so an accountTag predicate or JSON scope is not required. Explicit account scope must match the path account. Any zone restrictions must belong to that account. Query parameters, time ranges, output formats, authorization, and responses follow the legacy query endpoint.","properties":{"path":{"type":"object","properties":{"account_id":{"type":"string","pattern":"^[a-f0-9]{32}$","examples":["0123456789abcdef0123456789abcdef"],"description":"Account that authorizes and scopes the request."}},"required":["account_id"],"additionalProperties":false},"query":{"type":"object","properties":{"query":{"type":"string","examples":["SELECT edgeResponseStatus FROM events.httpRequests WHERE datetime > '2026-01-01' LIMIT 10"],"description":"SQL query to execute. A trailing FORMAT selects JSON, JSONEachRow, TabSeparated, or TSV output on any dataset.\n"}},"required":["query"],"additionalProperties":false}},"required":["path","query"],"additionalProperties":false},"name":"Query analytics datasets","id":"cloudflare.sql-api-query-get-account-scoped","example":{"path":{"account_id":"0123456789abcdef0123456789abcdef"},"query":{"query":"SELECT edgeResponseStatus FROM events.httpRequests WHERE datetime > '2026-01-01' LIMIT 10"}},"maxRequests":1,"summary":false}}