Query

Execute SQL query

Execute a SQL query against the project's analytics data. Only SELECT and WITH statements are allowed. LIMIT is capped at 1,000,000. Forbidden keywords: INSERT, UPDATE, DELETE, DROP, ALTER, TRUNCATE, CREATE, etc.

post/v0/query

Request

  • Base URL: https://api.formo.so
  • URL: https://api.formo.so/v0/query
  • Auth: HTTP bearer

Request body

querystring required

SQL query to execute

Response

Offset-paginated query results. The server doesn't own pagination here; LIMIT and OFFSET come from your SQL string and are echoed back. total is the row count before LIMIT was applied; has_more is true when there are additional rows beyond the current window.

dataobject[] required

Result rows.

totalinteger required

Total rows before LIMIT was applied.

limitinteger required

Applied LIMIT (parsed from your SQL; defaults to the server cap if absent).

offsetinteger required

Applied OFFSET (parsed from your SQL; 0 if absent).

has_moreboolean required

True when offset + data.length < total; i.e. there's another page to fetch by re-running with a higher OFFSET.

Changes

No recorded changes to this operation across all 1 revision of this API.