Available queries in the Query API
orderByMetric
and sort
inputs.Finally, reports use cursor-based pagination. You can control page size with the first
and
last
inputs.Show MetricReportInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show MetricReportDimensionInput
headers
array when displaying the report. This defaults to the column name if unspecified.dimensions
.Show MetricReportMetricInput
headers
array when displaying the report. This defaults to the Metric’s unique name if unspecified.ASC
) or descending (DESC
) order. Defaults to descending (DESC
) order when not provided.See SortShow Deprecated Fields
metric
metric
filterSql
insteadSee FilterInputorderByColumn
input. You can also order by dimensions this way.Show Deprecated Fields
filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show MetricReportConnection
headers
and rows
for a single page of a report. It also allows paging forward and backward to other
pages of the report.Show PageInfo
Show MetricReportEdge
Show MetricReportNode
Show QueryInfo
Show SqlV1Input
Show SqlResponse
data
field.Show SqlColumnResponse
Show QueryInfo
Show DescribeSqlV1Input
Show DescribeSqlResponse
Show SqlColumnResponse
Show DataGridInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.ASC
) or descending (DESC
) order. Defaults to descending (DESC
) order when not provided.Show Sort
ASC
: Sort in ascending order.DESC
: Sort in descending order.columns
array input.Show Deprecated Fields
columns
array input.deprecated: Use filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show DataGridConnection
headers
and rows
for a single page of a Data Grid table. It also allows paging forward and backward to other
pages of the Data Grid table.Show QueryInfo
Show PageInfo
Show DataGridEdge
Show RecordsByUniqueIdInput
Show RecordsByUniqueIdResponse
Show QueryInfo
Show TopValuesInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show TopValuesResponse
Show CounterInput
Show MetricInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show Deprecated Fields
metricName
is not specified.deprecated: Use metric
metricId
is not specified.deprecated: Use metric
filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show CounterResponse
Show QueryInfo
Show [CounterInput!]
Show MetricInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show Deprecated Fields
metricName
is not specified.deprecated: Use metric
metricId
is not specified.deprecated: Use metric
filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show CounterResponse
Show QueryInfo
Show TimeSeriesInput
Show MetricInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show TimeSeriesGranularity
DAY
, then the the time series query will return a label and a value for each day.If there are no records for a given time series granularity, Propel will return the label and a value of “0” so that the time series can be properly visualized.MINUTE
: Aggregates values by minute intervals.FIVE_MINUTES
: Aggregates values by 5-minute intervals.TEN_MINUTES
: Aggregates values by 10-minute intervals.FIFTEEN_MINUTES
: Aggregates values by 15-minute intervals.HOUR
: Aggregates values by hourly intervals.DAY
: Aggregates values by daily intervals.WEEK
: Aggregates values by weekly intervals.MONTH
: Aggregates values by monthly intervals.YEAR
: Aggregates values by yearly intervals.Show Deprecated Fields
metricName
is not specified.deprecated: Use metric
metricId
is not specified.deprecated: Use metric
filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show TimeSeriesResponse
groupBy
, if specified.Show TimeSeriesResponseGroup
groupBy
. It contains an array of time series labels and an array of Metric values for a particular group.Show QueryInfo
Show LeaderboardInput
Show MetricInput
Show TimeRangeInput
LAST_N
relative time period is selected, an n
≥ 1 must be provided. If no n
is provided or n
< 1, a BAD_REQUEST
error will be returned.LAST_N
relative periods.Show DimensionInput
ASC
) or descending (DESC
) order. Defaults to descending (DESC
) order when not provided.Show Sort
ASC
: Sort in ascending order.DESC
: Sort in descending order.Show Deprecated Fields
metricName
is not specified.deprecated: Use metric
metricId
is not specified.deprecated: Use metric
filterSql
insteadShow FilterInput
and
and or
. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and
takes precedence over or
.Show LeaderboardResponse
Show QueryInfo