---
title: "SYSTEMDATACONTAINERHTTPCACHECONTENTS (Data Dictionary)"
description: "System Data Container HTTP Cache Contents"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMDATACONTAINERHTTPCACHECONTENTS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMDATACONTAINERHTTPCACHECONTENTS
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# SYSTEMDATACONTAINERHTTPCACHECONTENTS: Data Dictionary System Data Container HTTP Cache Contents

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: System Data Container HTTP Cache Contents

Cached results of HTTP calls executed by providers.

Can only retrieve data.

## Table Columns

The columns of the table `SYSTEMDATACONTAINERHTTPCACHECONTENTS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CACHE_FIRST_HIT_UTC` | `datetime` | Cache First Hit | [ ] |  | Date at which the cache entry was first hit (UTC). |
| `CACHE_HITS` | `int32` | Cache Hits | [ ] |  | Number of times the cache entry was used after initial storage. |
| `CACHE_HITS_PER_HOUR` | `int32` | Cache Hits per Hour | [ ] |  | Number of times per hour the cache entry is used since creation. |
| `CACHE_KEY` | `varchar2(4000)` | Cache Key | [x] |  | Unique key. |
| `CACHE_LAST_HIT_UTC` | `datetime` | Cache Last Hit | [ ] |  | Date at which the cache entry was last hit (UTC). |
| `CREATED_UTC` | `datetime` | Created | [ ] |  | Date at which the cache entry was created (UTC). |
| `HTTP_METHOD` | `varchar2(30)` | HTTP Method | [x] |  | HTTP method. |
| `HTTP_REQUEST_BODY` | `varchar2(1000000)` | HTTP Request Body | [ ] |  | HTTP request body. |
| `HTTP_REQUEST_BODY_GZIPPED` | `blob` | HTTP Request Body (GZipped) | [ ] |  | HTTP request body as gzipped contents. |
| `HTTP_REQUEST_BODY_GZIPPED_LENGTH` | `int64` | HTTP Request Body Gzipped Length (Bytes) | [ ] |  | Number of bytes in the gzipped text request body. |
| `HTTP_REQUEST_BODY_LENGTH` | `int64` | HTTP Request Body Length | [ ] |  | Number of characters in the text request body. |
| `HTTP_RESPONSE_BODY` | `varchar2(1000000)` | HTTP Response Body | [x] |  | HTTP response body. |
| `HTTP_RESPONSE_BODY_BINARY` | `blob` | HTTP Response Body (Binary) | [ ] |  | HTTP response body as binary contents. |
| `HTTP_RESPONSE_BODY_BYTES_GZIPPED_LENGTH` | `int64` | HTTP Response Body Gzipped Length (Bytes) | [ ] |  | Number of bytes in the gzipped binary response body. |
| `HTTP_RESPONSE_BODY_BYTES_LENGTH` | `int64` | HTTP Response Body Length (Bytes) | [ ] |  | Number of bytes in the binary response body bytes. |
| `HTTP_RESPONSE_BODY_GZIPPED` | `blob` | HTTP Response Body (GZipped) | [x] |  | HTTP response body as gzipped contents. |
| `HTTP_RESPONSE_BODY_GZIPPED_LENGTH` | `int64` | HTTP Response Body Gzipped Length (Bytes) | [ ] |  | Number of bytes in the gzipped text response body. |
| `HTTP_RESPONSE_BODY_LENGTH` | `int64` | HTTP Response Body Length | [ ] |  | Number of characters in the text response body. |
| `HTTP_RESPONSE_HEADERS` | `varchar2(16000)` | HTTP Response Headers | [ ] |  | HTTP response headers. |
| `INBOUND_CORRELATION_IDS` | `varchar2(240)` | Inbound Correlation IDs | [ ] |  | Inbound correlation IDs. |
| `MANAGED_THREAD_ID` | `int32` | Managed Thread ID | [ ] |  | Managed thread ID. |
| `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2(4000)` | Data Container Alias | [ ] |  | Data container alias. |
| `PROVIDER_DATA_CONTAINER_ID` | `varchar2(4000)` | Data Container ID | [ ] |  | Data container ID. |
| `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Provider Description | [x] |  | Provider description. |
| `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | [x] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2(240)` | Provider Name | [x] |  | Name of the provider. |
| `PROVIDER_SHORT_NAME` | `varchar2(240)` | Provider Short Name | [x] |  | Provider short name. |
| `REQUEST_ID` | `varchar2(60)` | Request ID | [ ] |  | Request ID. |
| `REQUEST_URL` | `varchar2(4000)` | Request URL | [x] |  | Request URL used to retrieve the answer. |
| `TASK_ID` | `int32` | Task ID | [ ] |  | Task ID. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `SYSTEMDATACONTAINERHTTPCACHECONTENTS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS)`.PROVIDER_INSTANCE_UID` | Key |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

