---
title: "POST /v1/{+orgenv}/securityStats:queryTabularStats"
method: POST
path: "/v1/{+orgenv}/securityStats:queryTabularStats"
tags: ["organizations"]
---

# POST /v1/{+orgenv}/securityStats:queryTabularStats

`POST /v1/{+orgenv}/securityStats:queryTabularStats`

Retrieve security statistics as tabular rows.

## Path parameters

- `orgenv` string, required

## Request body

- GoogleCloudApigeeV1QueryTabularStatsRequest — Request payload representing the query to be run for fetching security statistics as rows.
  - `pageSize` integer — Page size represents the number of rows.
  - `pageToken` string — Identifies a sequence of rows.
  - `metrics` GoogleCloudApigeeV1MetricAggregation[] — Required. List of metrics and their aggregations.
    - `name` string — Name of the metric
    - `aggregation` 'AGGREGATION_FUNCTION_UNSPECIFIED' | 'AVG' | 'SUM' | 'MIN' | 'MAX' | 'COUNT_DISTINCT' — Aggregation function associated with the metric.
    - `order` 'ORDER_UNSPECIFIED' | 'ASCENDING' | 'DESCENDING' — Ordering for this aggregation in the result. For time series this is ignored since the ordering of points depends only on the timestamp, not the values.
  - `filter` string — Filter further on specific dimension values. Follows the same grammar as custom report's filter expressions. Example, apiproxy eq 'foobar'. https://cloud.google.com/apigee/docs/api-platform/analytics/analytics-reference#filters
  - `dimensions` string[] — Required. List of dimension names to group the aggregations by.
  - `timeRange` GoogleTypeInterval — Represents a time interval, encoded as a Timestamp start (inclusive) and a Timestamp end (exclusive). The start must be less than or equal to the end. When the start equals the end, the interval is empty (matches no time). When both start and end are unspecified, the interval matches any time.
    - `endTime` string, google-datetime — Optional. Exclusive end of the interval. If specified, a Timestamp matching this interval will have to be before the end.
    - `startTime` string, google-datetime — Optional. Inclusive start of the interval. If specified, a Timestamp matching this interval will have to be the same or after the start.

## Response `200`

Successful response

---

[API](https://skmtc.net/google/apis/apigee.md) · [All operations](https://skmtc.net/google/apis/apigee/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/google/apigee/versions/6e272fa448a7/schema)