---
title: "Query rows from an OEP table"
method: GET
path: "/api/oep/tables/:schema/:table/rows"
tags: ["OEP (Open Energy Platform)"]
---

# Query rows from an OEP table

`GET /api/oep/tables/:schema/:table/rows`

## Request

- Base URL: `https://api.cernion.de`
- URL: `https://api.cernion.de/api/oep/tables/:schema/:table/rows`
- Auth: none declared

Returns up to 1000 rows from the specified OEP table. Supports optional server-side filtering via the `where` parameter (OEP filter syntax, e.g. `year=2030`) and result ordering. Row data is NOT cached — each call fetches live from OEP.

## Path parameters

- `schema` string, required
- `table` string, required

## Query parameters

- `limit` integer
- `offset` integer
- `where` string
- `orderby` string
- `token` string

## Response `200`

Successful response

- object

---

[API](https://skmtc.dev/cernion/apis/cernion-energy-tools-api.md) · [All operations](https://skmtc.dev/cernion/apis/cernion-energy-tools-api/llms.txt) · [OpenAPI document](https://skmtc.dev/cernion/apis/cernion-energy-tools-api/revisions/cdb94473b538?raw)