invantive documentation
Invantive Support ForumsLog In / Sign Up

NATIVEPLATFORMSCALARREQUESTS: Bouw7 Native Platform Scalar Requests

insert

  • Catalog: Bouw7
  • Schema: Native
  • Label: Native Platform Scalar Requests

Direct access to native API.

Can retrieve data and change data using insert.

Summary

The NativePlatformScalarRequests table provides direct access to the native API protocol over an established connection to the Bouw7 API server. It will contain a new row for every row inserted with a native API request in PAYLOAD_TEXT with the results of unaltered forwarding of the payload to the Bouw7 API server.

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

Table Columns

The columns of the table NATIVEPLATFORMSCALARREQUESTS 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
BLOB_PREFERRED char BLOB Preferred fetched only when named Indicator whether a BLOB result is preferred over text.
BOL_RESPONSE_CACHE_MAX_AGE_SEC int32 Response Cache Maximum Age (sec) fetched only when named Maximum age in seconds of Bridge Online response cache entries to be used.
CONTENT_TYPE varchar2(240) Content Type fetched only when named
DATE_ENDED datetime End Date fetched only when named
DATE_STARTED datetime Start Date fetched only when named
DRY_RUN char Run without Actions fetched only when named
DURATION_MS double Duration (ms) fetched only when named
ERROR_MESSAGE_CODE varchar2(30) Error Message Code fetched only when named
ERROR_MESSAGE_TEXT varchar2(32000) Error Message Text fetched only when named
FAIL_ON_ERROR char Fail on Error fetched only when named Whether to raise an exception when processing the native request triggered an error from the provider.
HTTP_DISK_CACHE_MAX_AGE_SEC int32 HTTP Disk Cache Maximum Age (sec) fetched only when named Maximum age in seconds of HTTP disk cache entries to be used.
HTTP_DISK_CACHE_SAVE char Save HTTP Disk Cache fetched only when named Whether results can be stored in HTTP disk cache.
HTTP_DISK_CACHE_USE char Use HTTP Disk Cache fetched only when named Whether results can be fetched from HTTP disk cache.
HTTP_MEMORY_CACHE_MAX_AGE_SEC int32 HTTP Memory Cache Maximum Age (sec) fetched only when named Maximum age in seconds of HTTP memory cache entries to be used.
HTTP_MEMORY_CACHE_SAVE char Save HTTP Memory Cache fetched only when named Whether results can be stored in HTTP memory cache.
HTTP_MEMORY_CACHE_USE char Use HTTP Memory Cache fetched only when named Whether results can be fetched from HTTP memory cache.
HTTP_METHOD varchar2(30) HTTP Method fetched only when named
HTTP_STATUS_CODE numeric HTTP Status Code fetched only when named
ORIG_SYSTEM_GROUP varchar2(4000) Original System Group fetched only when named
ORIG_SYSTEM_REFERENCE varchar2(4000) Original System Reference fetched only when named
PAYLOAD_TEXT varchar2 Payload fetched only when named
RESULT_BLOB blob Result BLOB fetched only when named
RESULT_DATE_TIME_UTC datetime Result Date Time fetched only when named
RESULT_NUMBER number Result Number fetched only when named
RESULT_TEXT varchar2 Result Text fetched only when named
SUCCESSFUL char Succesful fetched only when named
TIMEOUT_SEC int32 Timeout (sec) fetched only when named Timeout in seconds.
TRANSACTION_ID int64 Transaction ID fetched only when named Incrementing ID of the transaction.
URL varchar2(4000) URL fetched only when named

Release Notes

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