Query a Custom Timeseries Table

Fetches time-bucketed data from one of the caller's own custom Node-RED
tables. Same request/response contract as GET /timeseries/{table},
with three differences:

  • Bucketing/filtering always operates on inserted_at — the one
    column every custom table is guaranteed to have — regardless of any
    other timestamp column the flow author configured.
  • No company_id scoping is applied internally: the schema itself
    (named after the caller's own company_id) is the tenant boundary,
    so there's nothing else to filter by. There is no hierarchy
    inheritance — only the exact company that logged the data can query it.
  • The requested date range (created_at_gte/created_at_lte, or the
    default 7-day window) cannot exceed 6 months. Custom tables don't
    have the same operational guarantees (chunk sizing, retention,
    indexing) as core platform tables, so an unbounded range is a real
    scan-cost risk.

Not yet supported (tracked as a fast-follow): pivot_on,
pivot_values, pivot_top_n, percentile aggregations (pX, median),
and histogram. Requesting any of these returns 400.

Use GET /timeseries/custom/{table}/schema first to see which columns
exist and whether they're usable as a metric (numeric, aggregatable).

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

The name of the custom table, as returned by GET /timeseries/custom.

Query Params
string

A comma-separated list of numeric columns on which to perform aggregations.
Required unless aggregation is exclusively count.

string
Defaults to count

A comma-separated list of aggregation functions. Defaults to count.
Supported: count, sum, avg, min, max, stddev (or std), variance (or var).

string
Defaults to 1 day

The time bucket for the aggregation (e.g., 1 day, 1 hour). Defaults to 1 day.

date-time

The start of the time range (inclusive), in ISO 8601 format. Defaults to 7 days ago. Range cannot exceed 6 months.

date-time

The end of the time range (inclusive), in ISO 8601 format. Defaults to the current time.

date-time

The start of the time range (exclusive), in ISO 8601 format.

date-time

The end of the time range (exclusive), in ISO 8601 format.

Responses

400

The request was malformed or contained invalid parameters.

404

The item you were looking for does not exist

500

An unexpected error was encountered.

Language
Credentials
Header
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json