# ccdw_aggr_ocapi_request

This table aggregates daily performance metrics for OCAPI requests.

> **Note:** This table is not constrained by IP Address Filters configured in Business Manager.

| Column Alias            | Data Type | Key    | Description                                                                                | Index? |
| ----------------------- | --------- | ------ | ------------------------------------------------------------------------------------------ | ------ |
| `request_date`          | DATE      |        | Date of the request.                                                                       | No     |
| `api_name`              | VARCHAR   |        | Name of the OCAPI API.                                                                     | No     |
| `api_resource`          | VARCHAR   |        | Specific OCAPI resource accessed.                                                          | No     |
| `api_version`           | VARCHAR   |        | Version of the OCAPI API.                                                                  | No     |
| `site_id`               | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md). | No     |
| `client_id`             | VARCHAR   |        | Client identifier making the request.                                                      | No     |
| `status_code`           | SMALLINT  |        | HTTP status code of the response.                                                          | No     |
| `method`                | VARCHAR   |        | HTTP method used (for example, "GET", "POST").                                             | No     |
| `num_requests`          | INTEGER   |        | Total number of requests.                                                                  | No     |
| `response_time`         | NUMERIC   |        | Average response time for the requests.                                                    | No     |
| `num_requests_bucket1`  | INTEGER   |        | Number of requests in response time bucket 1.                                              | No     |
| `num_requests_bucket2`  | INTEGER   |        | Number of requests in response time bucket 2.                                              | No     |
| `num_requests_bucket3`  | INTEGER   |        | Number of requests in response time bucket 3.                                              | No     |
| `num_requests_bucket4`  | INTEGER   |        | Number of requests in response time bucket 4.                                              | No     |
| `num_requests_bucket5`  | INTEGER   |        | Number of requests in response time bucket 5.                                              | No     |
| `num_requests_bucket6`  | INTEGER   |        | Number of requests in response time bucket 6.                                              | No     |
| `num_requests_bucket7`  | INTEGER   |        | Number of requests in response time bucket 7.                                              | No     |
| `num_requests_bucket8`  | INTEGER   |        | Number of requests in response time bucket 8.                                              | No     |
| `num_requests_bucket9`  | INTEGER   |        | Number of requests in response time bucket 9.                                              | No     |
| `num_requests_bucket10` | INTEGER   |        | Number of requests in response time bucket 10.                                             | No     |
| `num_requests_bucket11` | INTEGER   |        | Number of requests in response time bucket 11.                                             | No     |