Run query
Query
The access token received from the authorization server in the OAuth 2.0 flow.
when saveAsKind is true, this parameter indicates the id of the associated dataset
start and end time for the query, these must be specified as RFC3339 strings or using relative time expressions (e.g. now-1h, now-1d, now-1w, etc)
Variables is an optional set of additional variables that are inserted into the APL
Authorizations
The access token received from the authorization server in the OAuth 2.0 flow.
Query Parameters
legacy, tabular when saveAsKind is true, this parameter indicates the id of the associated dataset
Body
start and end time for the query, these must be specified as RFC3339 strings or using relative time expressions (e.g. now-1h, now-1d, now-1w, etc)
Response
Format specifies the result set format. Either "legacy" (default) or "tabular".
Row id of the newest row, as seen server side. May be higher than what the results include if the server scanned more data than included in the results. Can be used to efficiently resume time-sorted non-aggregating queries (ie filtering only).
Row id of the oldest row, as seen server side. May be lower than what the results include if the server scanned more data than included in the results. Can be used to efficiently resume time-sorted non-aggregating queries (ie filtering only).
FieldsMetaMap contains the unit information (if we have it) for each field in the given dataset entry
The time resolution of the query’s graph, in seconds. Valid values are the query’s time range /100 at maximum and /1000 at minimum or "auto".
start and end time for the query, these must be specified as RFC3339 strings or using relative time expressions (e.g. now-1h, now-1d, now-1w, etc)
We also support '==', but we’re not exporting that to swagger, because it can’t deal with it add >, >=, <, <= to that list, it breaks codegen.
and, or, not, eq, !=, ne, exists, not-exists, gt, gte, lt, lte, starts-with, not-starts-with, ends-with, not-ends-with, contains, not-contains, regexp, not-regexp Supported for these filters: starts-with, not-starts-with, ends-with, not-ends-with, contains, not-contains, eq, ne.
Supported for these filters: and, or, not.
Tables hold the result tables in the "tabular" result format
The standard mode of operation is to create buckets on the _time column,
Columns contain a series of arrays with the raw result data. The columns here line up with the fields in the Fields array.
Fields contain information about the fields included in these results. The order of the fields match up with the order of the data in Columns.
AggInfo captures information about an aggregation
Name is the system name of the aggregation, which is the string form of aggregation.Type. If the aggregation is aliased, the alias is stored in the parent FieldInfo
Args specifies any non-field arguments for the aggregation. Fx. [10] for topk(players, 10).
Fields specifies the names of the fields this aggregation is computed on. Fx ["players"] for topk(players, 10)
Groups specifies which grouping operations has been performed on the results.
Name is the name assigned to this table. Defaults to "0". The name "_totals" is reserved for system use.
End is the ending time the query is limited by. Queries are restricted to the interval [start,end).
Field specifies the field name on which the query range was restricted. Normally _time
Start is the starting time the query is limited by. Queries are restricted to the interval [start,end).
Was this page helpful?