NATIVEPLATFORMSCALARREQUESTS: JIRA Service Desk Native Platform Scalar Requests |
Direct access to native API.
Catalog: JIRA
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 JIRA Service Desk 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 JIRA Service Desk 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 |
☐ |
|
FAIL_ON_ERROR |
boolean |
Fail on Error |
☑ |
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) |
☐ |
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_DATE_TIME_UTC |
datetime |
|
☐ |
|
RESULT_NUMBER |
decimal |
|
☐ |
|
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 |
☐ |
|
15-06-2022 20:37 Version 22.0.232-PROD+3445