invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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 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 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) 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 Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
REQUEST_ID varchar2(60) Request ID Request ID.
REQUEST_URL varchar2(4000) Request URL 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.PROVIDER_INSTANCE_UID Key

Release Notes

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