All cases
Discuss a project

Pipelines & Integration · Data API

Read access to warehouse reports through an API

Reporting data was available in BI, but other applications needed it too. A read-only REST gateway lets CRM, ERP and internal apps query approved warehouse tables without exchanging files.

RoleSole Data Engineer
IndustryAutomotive retail
ScopeRead-only data API
StackFastAPI · PostgreSQL · Docker
∞reports → endpoints (one config line each)
Livealways-fresh reads, never a stale export
1API key · read-only · governed

The problem

Other applications needed the reporting data

The reports lived only in BI. The CRM, the ERP and the operational apps couldn't reach the numbers — so people re-keyed data by hand or passed around CSV exports that were stale the moment they were made.

What I built

A read-only REST gateway in front of the warehouse

A FastAPI service sits in front of the analytics database. Any consumer — Creatio CRM, an ERP, an app — sends an authenticated HTTP request and gets data back as JSON. Reads go straight to the warehouse, so the answer is always current.

Every table is explicitly whitelisted, access needs an API key, and the whole surface is read-only — a system can consume the numbers, never change them.

Pipelines

refresh the warehouse
on schedule

Data warehouse

your analytical tables always current
live read

FastAPI gateway

schema · filter · count X-Api-Key · read-only
fresh JSON
CRM (Creatio)
ERP
Apps & bots

The API surface

Self-serve, discoverable, filterable

A consumer can list the available reports, inspect a schema, count rows and pull filtered data — all with one API key.

VIDI Analytics APIheader: X-Api-Key
GET/tableslist every report you can pull
GET/tables/{report}/schemacolumns & types
GET/tables/{report}/countrow count
GET/tables/{report}?col=gt:1000&limit=50the data, filtered & paged
GET/healthservice status

Always fresh

Data from the latest warehouse update

The API reads the warehouse when a request arrives. Applications get the data currently stored there; its freshness depends on the pipelines that update it.

Integrate anywhere

The same endpoint, consumed by any system

Inside the CRM

Creatio pulls a customer's RFM tier or funnel stage on the fly — agents see live analytics without leaving the CRM.

Into the ERP

Operational and finance systems read warehouse metrics directly, instead of waiting on a manual upload.

In-house apps

Portals, bots and internal tools call one endpoint and render live data — no database access handed out.

Built to be trusted

Access controls and query limits

  Secure by design

  • API-key auth — every request is authenticated; keys are issued per consumer.
  • Read-only & whitelisted — only approved tables are exposed, and nothing can be written.
  • Self-documenting — schema and count endpoints let consumers discover a report safely.
  • Dockerized & tested — packaged for deployment, with a test suite over auth, tables, filters and health.

The outcome

Reporting data available to business applications

Before

  • Analytics stuck inside BI dashboards
  • Stale CSV exports, re-keyed by hand
  • A custom export job per integration
  • No safe way to share warehouse data

After

  • Any report is a secure, live endpoint
  • Systems integrate in minutes, not weeks
  • Always-fresh data, one source of truth
  • Governed access — keys, read-only, whitelist

Stack & role

How it's built

Sole engineer — API design, auth, query layer, packaging and tests.

FastAPIPythonPostgreSQLDockerAPI-key authpytest

Want your reports available to every system?

We can give your applications controlled read access to warehouse data and document how to query it.

Discuss your project →