---
schema_version: "1"
id: e39d7291bce3e6a93f324d7a9cc621a1395a148512db33420f624a55b1cb0b0d
title: ccdw_aggr_scapi_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_scapi_request.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_scapi_request.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: b39e59e3e4397f90e863e05c8e304c97fdd29c23f19c29fd48b823d35f4d1930
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_scapi_request

This table aggregates daily performance metrics for SCAPI 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_family`            | VARCHAR   |        | Family of the SCAPI API.                                 | No     |
| `api_name`              | VARCHAR   |        | Name of the SCAPI API.                                   | No     |
| `api_resource`          | VARCHAR   |        | Specific SCAPI resource accessed.                        | No     |
| `api_version`           | VARCHAR   |        | Version of the SCAPI 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     |
| `status_code`           | INTEGER   |        | 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 -->