All cases
Discuss a project

Pipelines & Integration · Data API

Every analytical report, available as a live API endpoint

My dashboards were great — but other systems couldn't use the numbers behind them. I built a secure REST gateway over the data warehouse, so any report becomes an always-fresh endpoint that Creatio CRM, an ERP or an in-house app can query directly. Whitelist a table, and it's instantly live.

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

Great analytics, trapped inside dashboards

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

The latest numbers — never a stale export

Because the gateway reads the warehouse live, there's nothing to go stale. The pipelines refresh the data; the API serves whatever's current. Consumers integrate once and always see today's reality.

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

Open enough to use, locked down enough to trust

  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

From trapped reports to a live data product

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?

I'll put a secure REST gateway over your warehouse — so any analysis becomes a live endpoint your CRM, ERP and apps can integrate with in minutes.

Book a strategy call →