Cernion

Cernion Analytics API

The Analytics API from Cernion — 5 operation(s) for analytics.

GitHub OpenAPI

Operations 5

POST /api/in-memory-join/join Generic in-memory join across datasource and action outputs #
POST /api/in-memory-join/metering-spot-cost Join metering datasource with market spot prices and calculate costs #
POST /api/in-memory-join/procurement-vs-spot Compare procurement portfolio periods against Day-Ahead spot prices #
POST /api/in-memory-join/benchmark-compare Compare inhouse aggregate with external benchmark values #
POST /api/in-memory-join/compare-forecast-actual Compare inhouse actual generation with forecasted generation #

Specifications

⚙
OpenAPI
https://artifacts.apis.io/cernion-de/openapi/cernion-de-analytics-api-openapi.yml

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/cernion-de:cernion-de-analytics-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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

cernion-de-analytics-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Cernion Energy Tools Analytics API
  version: 0.99.22
  description: 'MicroService Agent System for Energy Markets - REST API with AI integration.


    CERNION_TOKEN: request at https://cernion.de/ or by email: dev@stromdao.com.


    For the public instance at https://api.cernion.de/, create your token at https://cernion.de/cet-token/.'
servers:
- url: https://api.cernion.de
  description: API Server
tags:
- name: Analytics
paths:
  /api/in-memory-join/join:
    post:
      summary: Generic in-memory join across datasource and action outputs
      tags:
      - Analytics
      operationId: in_memory_join_join
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - left
              - right
              - join
              properties:
                left:
                  type: object
                  example:
                    kind: datasource
                    sourceId: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                right:
                  type: object
                  example:
                    kind: action
                    action: energy-market.prices
                join:
                  type: object
                  example:
                    leftField: Zeit
                    rightField: timestamp
                    matchMode: hourly-time
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              basicJoin:
                summary: Join datasource rows with day-ahead market prices by hour
                value:
                  left:
                    kind: datasource
                    sourceId: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                    privacyContext: internal
                  right:
                    kind: action
                    action: energy-market.prices
                    params:
                      market: day-ahead
                      region: Deutschland
                      startDate: '2026-03-10'
                      endDate: '2026-03-10'
                    dataPath: data.prices
                  join:
                    leftField: Zeit
                    rightField: timestamp
                    matchMode: hourly-time
                    joinType: left
  /api/in-memory-join/metering-spot-cost:
    post:
      summary: Join metering datasource with market spot prices and calculate costs
      tags:
      - Analytics
      operationId: in_memory_join_meteringSpotCost
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - sourceId
              properties:
                sourceId:
                  type: string
                  example: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                date:
                  type: string
                  format: date
                  example: '2026-03-10'
                startDate:
                  type: string
                  format: date
                  example: '2026-03-10'
                endDate:
                  type: string
                  format: date
                  example: '2026-03-10'
                aggregateBy:
                  type: string
                  enum:
                  - interval
                  - hourly
                  - daily
                  default: hourly
                  example: hourly
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              hourlyCost:
                summary: Calculate hourly electricity cost from metering profile
                value:
                  sourceId: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                  date: '2026-03-10'
                  market: day-ahead
                  region: Deutschland
                  aggregateBy: hourly
  /api/in-memory-join/procurement-vs-spot:
    post:
      summary: Compare procurement portfolio periods against Day-Ahead spot prices
      tags:
      - Analytics
      operationId: in_memory_join_procurementVsSpot
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - sourceId
              properties:
                sourceId:
                  type: string
                  example: proc-source-1
                periodField:
                  type: string
                  example: Lieferperiode
                volumeField:
                  type: string
                  example: Menge_MWh
                priceField:
                  type: string
                  example: Preis_EUR_MWh
                region:
                  type: string
                  example: Deutschland
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              beschaffungsportfolio:
                summary: Compare procurement portfolio against Day-Ahead spot prices
                value:
                  sourceId: proc-source-1
                  periodField: Lieferperiode
                  volumeField: Menge_MWh
                  priceField: Preis_EUR_MWh
                  region: Deutschland
                  market: day-ahead
  /api/in-memory-join/benchmark-compare:
    post:
      summary: Compare inhouse aggregate with external benchmark values
      tags:
      - Analytics
      operationId: in_memory_join_benchmarkCompare
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - inhouseRows
              - benchmarkData
              - domain
              - aggregationField
              properties:
                inhouseRows:
                  type: array
                  items:
                    type: object
                  example:
                  - value: 12
                  - value: 18
                  - value: 15
                benchmarkData:
                  type: object
                  example:
                    data:
                    - value: '{"vnb":"Netzbetreiber A","score":14,"median":11}'
                domain:
                  type: string
                  example: ewk_connection_time
                aggregationField:
                  type: string
                  example: value
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              compareBenchmark:
                summary: Compare inhouse values against benchmark median
                value:
                  inhouseRows:
                  - value: 12
                  - value: 18
                  - value: 15
                  benchmarkData:
                    data:
                    - value: '{"vnb":"Netzbetreiber A","score":14,"median":11}'
                  domain: ewk_connection_time
                  aggregationField: value
  /api/in-memory-join/compare-forecast-actual:
    post:
      summary: Compare inhouse actual generation with forecasted generation
      tags:
      - Analytics
      operationId: in_memory_join_compareForecastActual
      parameters:
      - $ref: '#/components/parameters/TokenQuery'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - sourceId
              properties:
                sourceId:
                  type: string
                  example: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                date:
                  type: string
                  format: date
                  example: '2026-03-10'
                startDate:
                  type: string
                  format: date
                  example: '2026-03-10'
                endDate:
                  type: string
                  format: date
                  example: '2026-03-10'
                aggregateBy:
                  type: string
                  enum:
                  - interval
                  - hourly
                  - daily
                  default: hourly
                  example: hourly
                token:
                  type: string
                  description: Optional Cernion MCP token for this request. Overrides CERNION_TOKEN when provided.
            examples:
              compareHourly:
                summary: Compare actual inhouse generation with forecast on hourly basis
                value:
                  sourceId: fe55ec97-ada3-4272-9e2e-3f494a74f33a
                  date: '2026-03-10'
                  installationMastrNummer: SEE900000123456
                  aggregateBy: hourly
components:
  parameters:
    TokenQuery:
      name: token
      in: query
      required: false
      schema:
        type: string
      description: Optional Cernion MCP token as URL query parameter. If provided, it overrides CERNION_TOKEN for this request. Prefer Authorization Bearer header in production to reduce token exposure in URLs/logs.
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: X-API-Key
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: 'Optional Cernion MCP token. If not provided, falls back to CERNION_TOKEN from environment. Request token at https://cernion.de/ or by email: dev@stromdao.com.'