Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

OpenSpending Data Model

Navigation: Schema: Native > Tables

NATIVEPLATFORMSCALARREQUESTS: openspending.nl Native Platform Scalar Requests

Contents Previous Home Next More

Direct access to native API.

Catalog: OpenSpendingNl

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 openspending.nl 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 openspending.nl 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

 

ERROR_MESSAGE_CODE

string(30)

Error Message Code

 

ERROR_MESSAGE_TEXT

string(4000)

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

 

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

 

 

12-12-2020 19:01 Version 20.1.301-BETA+3023