---
schema_version: "1"
id: 8f915cc3340d75d33ff4e800ba799adb2b3fd4af02331d3042cd35b8baf12c1a
title: ccdw_aggr_ocapi_request
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_ocapi_request.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_ocapi_request.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: aef078acd6171299f5b56a1993fca57d842d255add487b684b5076420f05f093
products:
  - Composable Storefront
  - Salesforce APIs
---
# 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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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     |

<!-- **Indices**: None listed -->