Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: Native > Tables

NATIVEPLATFORMSCALARREQUESTS: Exact Online Native Platform Scalar Requests

Contents Previous Home Next More

Direct access to native API.

Catalog: ExactOnlineREST

Schema: Native

Alias: npt

Label: Native Platform Scalar Requests

Documentation:

The NativePlatformScalarRequests table provides direct access to the native API protocol over an established connection to the OData 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 OData API server.

Retrieve: true

Insert: true

Update: false

Delete: false

View Columns

The columns of the view 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.

Name

Data Type

Label

Required

Documentation

BLOB_PREFERRED

boolean

BLOB Preferred

Indicator whether a BLOB result is preferred over text.

BOL_RESPONSE_CACHE_MAX_AGE_SEC

int32

Response Cache Maximum Age (sec)

Maximum age in seconds of Bridge Online response cache entries to be used.

CONTENT_TYPE

string(240)

Content Type

 

DATE_ENDED

datetime

End Date

 

DATE_STARTED

datetime

Start Date

 

DRY_RUN

boolean

Run without Actions

 

DURATION_MS

int32

Duration (ms)

 

ERROR_MESSAGE_CODE

string(30)

Error Message Code

 

ERROR_MESSAGE_TEXT

string(32000)

Error Message Text

 

HTTP_DISK_CACHE_MAX_AGE_SEC

int32

HTTP Disk Cache Maximum Age (sec)

Maximum age in seconds of HTTP disk cache entries to be used.

HTTP_DISK_CACHE_SAVE

boolean

Save HTTP Disk Cache

Whether results can be stored in HTTP disk cache.

HTTP_DISK_CACHE_USE

boolean

Use HTTP Disk Cache

Whether results can be fetched from HTTP disk cache.

HTTP_MEMORY_CACHE_MAX_AGE_SEC

int32

HTTP Memory Cache Maximum Age (sec)

Maximum age in seconds of HTTP memory cache entries to be used.

HTTP_MEMORY_CACHE_SAVE

boolean

Save HTTP Memory Cache

Whether results can be stored in HTTP memory cache.

HTTP_MEMORY_CACHE_USE

boolean

Use HTTP Memory Cache

Whether results can be fetched from HTTP memory cache.

HTTP_METHOD

string(30)

HTTP Method

 

HTTP_STATUS_CODE

int16

HTTP Status Code

 

ORIG_SYSTEM_GROUP

string(4000)

Original System Group

 

ORIG_SYSTEM_REFERENCE

string(4000)

Original System Reference

 

PAYLOAD_TEXT

string

Payload

 

RESULT_BLOB

byte[]

Result BLOB

 

RESULT_TEXT

string

Result Text

 

SUCCESSFUL

boolean

Succesful

 

TIMEOUT_SEC

int32

Timeout (sec)

Timeout in seconds.

TRANSACTION_ID

int32

Transaction ID

Incrementing ID of the transaction.

URL

string(4000)

URL

 

 

07-11-2021 09:07 Version 20.2.94-PROD+3513