NATIVEPLATFORMSCALARREQUESTS |
Direct access to native API.
Catalog: OpenSpendingNl
Schema: Native
Alias: npt
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 |
|
☑ |
Indicator whether a BLOB result is preferred over text. |
BOL_RESPONSE_CACHE_MAX_AGE_SEC |
int32 |
|
☐ |
Maximum age in seconds of Bridge Online response cache entries to be used. |
CONTENT_TYPE |
string(240) |
|
☐ |
|
DATE_ENDED |
datetime |
|
☑ |
|
DATE_STARTED |
datetime |
|
☑ |
|
DRY_RUN |
boolean |
|
☑ |
|
DURATION_MS |
int32 |
|
☑ |
|
ERROR_MESSAGE_CODE |
string(30) |
|
☐ |
|
ERROR_MESSAGE_TEXT |
string(32000) |
|
☐ |
|
FAIL_ON_ERROR |
boolean |
|
☑ |
Whether to raise an exception when processing the native request triggered an error from the provider. |
HTTP_DISK_CACHE_MAX_AGE_SEC |
int32 |
|
☐ |
Maximum age in seconds of HTTP disk cache entries to be used. |
HTTP_DISK_CACHE_SAVE |
boolean |
|
☐ |
Whether results can be stored in HTTP disk cache. |
HTTP_DISK_CACHE_USE |
boolean |
|
☐ |
Whether results can be fetched from HTTP disk cache. |
HTTP_MEMORY_CACHE_MAX_AGE_SEC |
int32 |
|
☐ |
Maximum age in seconds of HTTP memory cache entries to be used. |
HTTP_MEMORY_CACHE_SAVE |
boolean |
|
☐ |
Whether results can be stored in HTTP memory cache. |
HTTP_MEMORY_CACHE_USE |
boolean |
|
☐ |
Whether results can be fetched from HTTP memory cache. |
HTTP_METHOD |
string(30) |
|
☐ |
|
HTTP_STATUS_CODE |
int16 |
|
☐ |
|
ORIG_SYSTEM_GROUP |
string(4000) |
|
☐ |
|
ORIG_SYSTEM_REFERENCE |
string(4000) |
|
☐ |
|
PAYLOAD_TEXT |
string |
|
☐ |
|
RESULT_BLOB |
byte[] |
|
☐ |
|
RESULT_DATE_TIME_UTC |
datetime |
|
☐ |
|
RESULT_NUMBER |
decimal |
|
☐ |
|
RESULT_TEXT |
string |
|
☐ |
|
SUCCESSFUL |
boolean |
|
☑ |
|
TIMEOUT_SEC |
int32 |
|
☐ |
Timeout in seconds. |
TRANSACTION_ID |
int32 |
|
☑ |
Incrementing ID of the transaction. |
URL |
string(4000) |
|
☐ |
|
29-05-2022 01:01 Version 22.0.196-PROD+3400