# Formo Query API

**Canonical:** https://apis.io/apis/formo-so/formo-so-query-api/  
**Provider:** Formo — https://apis.io/providers/formo-so/  
**Base URL:** https://api.formo.so  
**Documentation:** https://docs.formo.so/api

Formo Query API is one of 8 APIs that [Formo](https://apis.io/providers/formo-so/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Query. The published artifact set on APIs.io includes an OpenAPI specification.

Execute SQL queries and call pre-built analytics endpoints (KPIs, top pages, lifecycle, retention, revenue). Requires the query:read scope.

## Operations (18)

| Method | Path | Summary |
|---|---|---|
| POST | `/v0/query` | Execute SQL query |
| GET | `/v0/kpis` | Get KPIs (sessions, pageviews, bounce rate, session duration) |
| GET | `/v0/top_pages` | Get top pages by sessions or visitors, optionally restricted to entry or exit… |
| GET | `/v0/top_sources` | Get top traffic sources (referrers / utm) |
| GET | `/v0/top_locations` | Get top countries |
| GET | `/v0/top_wallets` | Get top wallet types |
| GET | `/v0/top_chains` | Get top blockchain chains |
| GET | `/v0/top_events` | Get top events by frequency |
| GET | `/v0/revenue_by_metric` | Get revenue grouped by a chosen column |
| GET | `/v0/volume_by_metric` | Get transaction volume grouped by a chosen column |
| GET | `/v0/revenue_overview` | Get revenue and transaction volume time-series |
| GET | `/v0/revenue_timeseries` | Get per-event revenue and volume trend for a single wallet |
| GET | `/v0/event_timeseries` | Get event count time-series |
| GET | `/v0/lifecycle` | Get user lifecycle stages (New / Returning / Power user / At Risk / Churned /… |
| GET | `/v0/frequency` | Get visit-frequency distribution |
| GET | `/v0/retention` | Get user retention cohorts |
| GET | `/v0/funnel` | Get multi-step conversion funnel |
| GET | `/v0/flow` | Get session-scoped user-flow transitions (Sankey) |

## Machine-readable artifacts (1)

- **OpenAPI** — https://artifacts.apis.io/formo-so/openapi/formo-so-query-api-openapi.yml

## Other Formo APIs (7)

- [Formo Alerts API](https://apis.io/apis/formo-so/formo-so-alerts-api/)
- [Formo Boards API](https://apis.io/apis/formo-so/formo-so-boards-api/)
- [Formo Charts API](https://apis.io/apis/formo-so/formo-so-charts-api/)
- [Formo Contracts API](https://apis.io/apis/formo-so/formo-so-contracts-api/)
- [Formo Events API](https://apis.io/apis/formo-so/formo-so-events-api/)
- [Formo Profiles API](https://apis.io/apis/formo-so/formo-so-profiles-api/)
- [Formo Segments API](https://apis.io/apis/formo-so/formo-so-segments-api/)

## Tags

Query

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/formo-so/formo-so-query-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/formo-so/.