PostHog · Schema

QueryResponseAlternative4

A/B TestingAnalyticsFeature FlagsOpen SourceProduct AnalyticsSession Recording

Properties

Name	Type	Description
columns	array
error	string	Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
hasMore	boolean
hogql	string	Generated HogQL query.
kind	string
limit	integer
modifiers	object	Modifiers used when performing the query
offset	integer
query_status	object	Query status indicates whether next to the provided data, a query is still running.
resolved_date_range	object	The date range used for the query
results	array
timings	array	Measured timings for different parts of the query generation process
types	array

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/QueryResponseAlternative4",
  "title": "QueryResponseAlternative4",
  "additionalProperties": false,
  "properties": {
    "columns": {
      "items": {},
      "title": "Columns",
      "type": "array"
    },
    "error": {
      "default": null,
      "description": "Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.",
      "title": "Error",
      "type": "string",
      "nullable": true
    },
    "hasMore": {
      "default": null,
      "title": "Hasmore",
      "type": "boolean",
      "nullable": true
    },
    "hogql": {
      "description": "Generated HogQL query.",
      "title": "Hogql",
      "type": "string"
    },
    "kind": {
      "default": "GroupsQuery",
      "title": "Kind",
      "type": "string",
      "enum": [
        "GroupsQuery"
      ]
    },
    "limit": {
      "title": "Limit",
      "type": "integer"
    },
    "modifiers": {
      "default": null,
      "description": "Modifiers used when performing the query",
      "allOf": [
        {
          "$ref": "#/components/schemas/HogQLQueryModifiers"
        }
      ],
      "nullable": true
    },
    "offset": {
      "title": "Offset",
      "type": "integer"
    },
    "query_status": {
      "default": null,
      "description": "Query status indicates whether next to the provided data, a query is still running.",
      "allOf": [
        {
          "$ref": "#/components/schemas/QueryStatus"
        }
      ],
      "nullable": true
    },
    "resolved_date_range": {
      "default": null,
      "description": "The date range used for the query",
      "allOf": [
        {
          "$ref": "#/components/schemas/ResolvedDateRangeResponse"
        }
      ],
      "nullable": true
    },
    "results": {
      "items": {
        "items": {},
        "type": "array"
      },
      "title": "Results",
      "type": "array"
    },
    "timings": {
      "default": null,
      "description": "Measured timings for different parts of the query generation process",
      "title": "Timings",
      "items": {
        "$ref": "#/components/schemas/QueryTiming"
      },
      "type": "array",
      "nullable": true
    },
    "types": {
      "items": {
        "type": "string"
      },
      "title": "Types",
      "type": "array"
    }
  },
  "required": [
    "columns",
    "hogql",
    "limit",
    "offset",
    "results",
    "types"
  ],
  "type": "object"
}