invantive documentation
Forum di supporto InvantiveAccedi / Registrati

NATIVEPLATFORMSCALARREQUESTS: Autotask Native Platform Scalar Requests

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

insert

  • Catalog: Autotask
  • 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 Autotask 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 Autotask API server.

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 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 varchar2(240) Content Type
DATE_ENDED datetime End Date
DATE_STARTED datetime Start Date
DRY_RUN char Run without Actions
DURATION_MS int64 Duration (ms)
ERROR_MESSAGE_CODE varchar2(30) Error Message Code
ERROR_MESSAGE_TEXT varchar2(32000) Error Message Text
FAIL_ON_ERROR char 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 char Save HTTP Disk Cache Whether results can be stored in HTTP disk cache.
HTTP_DISK_CACHE_USE char 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 char Save HTTP Memory Cache Whether results can be stored in HTTP memory cache.
HTTP_MEMORY_CACHE_USE char Use HTTP Memory Cache Whether results can be fetched from HTTP memory cache.
HTTP_METHOD varchar2(30) HTTP Method
HTTP_STATUS_CODE numeric HTTP Status Code
ORIG_SYSTEM_GROUP varchar2(4000) Original System Group
ORIG_SYSTEM_REFERENCE varchar2(4000) Original System Reference
PAYLOAD_TEXT varchar2 Payload
RESULT_BLOB blob Result BLOB
RESULT_DATE_TIME_UTC datetime Result Date Time
RESULT_NUMBER number Result Number
RESULT_TEXT varchar2 Result Text
SUCCESSFUL char Succesful
TIMEOUT_SEC int32 Timeout (sec) Timeout in seconds.
TRANSACTION_ID int64 Transaction ID Incrementing ID of the transaction.
URL varchar2(4000) URL

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: