Heron

Heron End User Queries API

The EndUserQueries API from Heron — 1 operation(s) for enduserqueries.

Documentation GitHub OpenAPI

Operations 1

POST /api/end_user_queries/execute Execute saved queries #

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/heron:heron-enduserqueries-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

openapi: 3.2.0
info:
  contact:
    email: support@herondata.io
    name: Support
  title: Heron Data End User Queries API
  version: '2021-07-19'
servers:
- description: Production
  url: https://app.herondata.io
security:
- ApiKeyAuth:
  - key_XXX
tags:
- name: EndUserQueries
paths:
  /api/end_user_queries/execute:
    post:
      description: Execute saved SQL queries by name for a specific end user and return results
      requestBody:
        content:
          application/json:
            schema:
              properties:
                end_user_heron_id:
                  description: Heron ID of the end user
                  example: eu_abc123
                  type: string
                query_names:
                  description: List of saved query names to execute
                  example:
                  - monthly_revenue
                  - top_transactions
                  items:
                    type: string
                  type: array
              required:
              - query_names
              - end_user_heron_id
              type: object
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                additionalProperties:
                  items:
                    type: object
                  type: array
                example:
                  results:
                    monthly_revenue:
                      column_order:
                      - month
                      - revenue
                      records:
                      - month: 2024-01
                        revenue: 50000
                    top_transactions:
                      column_order:
                      - id
                      - amount
                      records:
                      - amount: 1000
                        id: 1
                type: object
          description: Successfully executed queries
      security:
      - ApiKeyAuth: []
      summary: Execute saved queries
      tags:
      - EndUserQueries
      x-hidden: true
      operationId: postApiEndUserQueriesExecute
      x-operation-id-source: derived
components:
  securitySchemes:
    ApiKeyAuth:
      in: header
      name: x-api-key
      type: apiKey
externalDocs:
  description: Read Tutorial
  url: https://docs.herondata.io/