PostHog

PostHog insight_variables API

The insight_variables API from PostHog — 4 operation(s) for insight_variables.

GitHub OpenAPI

Operations 12

GET /api/environments/{environment_id}/insight_variables/ #
POST /api/environments/{environment_id}/insight_variables/ #
GET /api/environments/{environment_id}/insight_variables/{id}/ #
PUT /api/environments/{environment_id}/insight_variables/{id}/ #
PATCH /api/environments/{environment_id}/insight_variables/{id}/ #
DELETE /api/environments/{environment_id}/insight_variables/{id}/ #
GET /api/projects/{project_id}/insight_variables/ #
POST /api/projects/{project_id}/insight_variables/ #
GET /api/projects/{project_id}/insight_variables/{id}/ #
PUT /api/projects/{project_id}/insight_variables/{id}/ #
PATCH /api/projects/{project_id}/insight_variables/{id}/ #
DELETE /api/projects/{project_id}/insight_variables/{id}/ #

Documentation

📖
Documentation
https://posthog.com/docs/api
📖
GettingStarted
https://posthog.com/docs/api
📖
Authentication
https://posthog.com/docs/api#authentication

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/openapi/posthog-insight-variables-api-openapi.yml
⚙
AsyncAPI
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/asyncapi/posthog-webhooks-asyncapi.yml

Other Resources

🔗
GraphQL
https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/graphql/posthog-graphql.md

Work with this as data

Every API 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 apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • 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 API 
curl "https://apis.io/api/v1/apis/posthog-insight-variables-api"
All apis 
curl "https://apis.io/api/v1/apis?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.

OpenAPI Specification

posthog-insight-variables-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: PostHog actions Insight Variables API
  version: 1.0.0
  description: ''
servers:
- url: https://app.posthog.com/api
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: insight_variables
paths:
  /api/environments/{environment_id}/insight_variables/:
    get:
      operationId: environments_insight_variables_list
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedInsightVariableList'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    post:
      operationId: environments_insight_variables_create
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/InsightVariable'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '201':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/environments/{environment_id}/insight_variables/{id}/:
    get:
      operationId: environments_insight_variables_retrieve
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    put:
      operationId: environments_insight_variables_update
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/InsightVariable'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    patch:
      operationId: environments_insight_variables_partial_update
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      deprecated: true
      x-explicit-tags:
      - data_warehouse
    delete:
      operationId: environments_insight_variables_destroy
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '204':
          description: No response body
      deprecated: true
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/insight_variables/:
    get:
      operationId: insight_variables_list
      parameters:
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedInsightVariableList'
          description: ''
      x-explicit-tags:
      - data_warehouse
    post:
      operationId: insight_variables_create
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/InsightVariable'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '201':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      x-explicit-tags:
      - data_warehouse
  /api/projects/{project_id}/insight_variables/{id}/:
    get:
      operationId: insight_variables_retrieve
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      x-explicit-tags:
      - data_warehouse
    put:
      operationId: insight_variables_update
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/InsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/InsightVariable'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      x-explicit-tags:
      - data_warehouse
    patch:
      operationId: insight_variables_partial_update
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedInsightVariable'
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/InsightVariable'
          description: ''
      x-explicit-tags:
      - data_warehouse
    delete:
      operationId: insight_variables_destroy
      parameters:
      - in: path
        name: id
        schema:
          type: string
          format: uuid
        description: A UUID string identifying this insight variable.
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - insight_variables
      security:
      - PersonalAPIKeyAuth:
        - insight_variable:write
      responses:
        '204':
          description: No response body
      x-explicit-tags:
      - data_warehouse
components:
  schemas:
    InsightVariable:
      type: object
      properties:
        id:
          type: string
          format: uuid
          readOnly: true
          description: UUID of the SQL variable.
        name:
          type: string
          description: Human-readable name for the SQL variable.
          maxLength: 400
        type:
          allOf:
          - $ref: '#/components/schemas/InsightVariableTypeEnum'
          description: 'Variable type. Controls how the value is rendered and substituted in HogQL.


            * `String` - String

            * `Number` - Number

            * `Boolean` - Boolean

            * `List` - List

            * `Date` - Date'
        default_value:
          description: Default value used when a query references this variable.
        created_by:
          type:
          - integer
          - 'null'
          readOnly: true
          description: ID of the user who created the SQL variable.
        created_at:
          type: string
          format: date-time
          readOnly: true
          description: Timestamp when the SQL variable was created.
        code_name:
          type:
          - string
          - 'null'
          readOnly: true
          description: Generated code-safe name used in HogQL as {variables.code_name}. Derived from name.
        values:
          description: Allowed values for List variables. Null for other variable types.
      required:
      - code_name
      - created_at
      - created_by
      - id
      - name
      - type
    InsightVariableTypeEnum:
      enum:
      - String
      - Number
      - Boolean
      - List
      - Date
      type: string
      description: '* `String` - String

        * `Number` - Number

        * `Boolean` - Boolean

        * `List` - List

        * `Date` - Date'
    PaginatedInsightVariableList:
      type: object
      required:
      - count
      - results
      properties:
        count:
          type: integer
          example: 123
        next:
          type:
          - string
          - 'null'
          format: uri
          example: http://api.example.org/accounts/?page=4
        previous:
          type:
          - string
          - 'null'
          format: uri
          example: http://api.example.org/accounts/?page=2
        results:
          type: array
          items:
            $ref: '#/components/schemas/InsightVariable'
    PatchedInsightVariable:
      type: object
      properties:
        id:
          type: string
          format: uuid
          readOnly: true
          description: UUID of the SQL variable.
        name:
          type: string
          description: Human-readable name for the SQL variable.
          maxLength: 400
        type:
          allOf:
          - $ref: '#/components/schemas/InsightVariableTypeEnum'
          description: 'Variable type. Controls how the value is rendered and substituted in HogQL.


            * `String` - String

            * `Number` - Number

            * `Boolean` - Boolean

            * `List` - List

            * `Date` - Date'
        default_value:
          description: Default value used when a query references this variable.
        created_by:
          type:
          - integer
          - 'null'
          readOnly: true
          description: ID of the user who created the SQL variable.
        created_at:
          type: string
          format: date-time
          readOnly: true
          description: Timestamp when the SQL variable was created.
        code_name:
          type:
          - string
          - 'null'
          readOnly: true
          description: Generated code-safe name used in HogQL as {variables.code_name}. Derived from name.
        values:
          description: Allowed values for List variables. Null for other variable types.
  parameters:
    ProjectIdPath:
      in: path
      name: project_id
      required: true
      schema:
        type: string
      description: Project ID of the project you're trying to access. To find the ID of the project, make a call to /api/projects/.
    EnvironmentIdPath:
      in: path
      name: environment_id
      required: true
      schema:
        type: string
      description: Deprecated. Use /api/projects/{project_id}/ instead.
  securitySchemes:
    PersonalAPIKeyAuth:
      type: http
      scheme: bearer
x-tagGroups:
- name: All endpoints
  tags:
  - LLM Analytics
  - actions
  - activity_log
  - activity_logs
  - advanced_activity_logs
  - alerts
  - annotations
  - approval_policies
  - batch_exports
  - cdp
  - change_requests
  - code
  - code-invites
  - cohorts
  - comments
  - conversations
  - core
  - customer_analytics
  - customer_journeys
  - customer_profile_configs
  - dashboard_templates
  - dashboards
  - data_color_themes
  - data_modeling_jobs
  - data_warehouse
  - dataset_items
  - datasets
  - desktop_recordings
  - domains
  - early_access_feature
  - early_access_features
  - elements
  - endpoints
  - environments
  - error_tracking
  - evaluation_runs
  - evaluations
  - event_definitions
  - event_filter
  - event_schemas
  - events
  - experiment_holdouts
  - experiment_saved_metrics
  - experiments
  - exports
  - external_data_schemas
  - external_data_sources
  - feature_flags
  - file_system
  - file_system_shortcut
  - flag_value
  - groups
  - groups_types
  - health_issues
  - heatmap_screenshots
  - heatmaps
  - hog_flows
  - hog_function_templates
  - hog_functions
  - insight_variables
  - insights
  - integrations
  - invites
  - js-snippet
  - legal_documents
  - lineage
  - live_debugger_breakpoints
  - llm_analytics
  - llm_prompts
  - llm_skills
  - logs
  - managed_viewsets
  - max
  - max_tools
  - mcp_server_installations
  - mcp_servers
  - mcp_store
  - mcp_tools
  - members
  - notebooks
  - oauth_applications
  - object_media_previews
  - organizations
  - persisted_folder
  - persons
  - platform_features
  - plugin_configs
  - product_analytics
  - product_tours
  - project_secret_api_keys
  - projects
  - property_definitions
  - proxy_records
  - public_hog_function_templates
  - query
  - replay
  - reverse_proxy
  - role_external_references
  - roles
  - sandbox-environments
  - sandbox_environments
  - saved
  - schema_property_groups
  - sdk_doctor
  - session_group_summaries
  - session_recording_playlists
  - session_recordings
  - session_summaries
  - sessions
  - signals
  - subscriptions
  - surveys
  - taggers
  - task-automations
  - task-runs
  - task_automations
  - tasks
  - uploaded_media
  - user_home_settings
  - user_interviews
  - users
  - visual_review
  - warehouse_dag
  - warehouse_model_paths
  - warehouse_saved_queries
  - warehouse_saved_query_folders
  - warehouse_tables
  - warehouse_view_link
  - warehouse_view_links
  - web_analytics
  - web_experiments
  - web_vitals
  - welcome
  - workflows