# NATIVEPLATFORMSCALARREQUESTS: HubSpot Native Platform Scalar Requests {res:itgen_native_platform_scalar_requests_desc} ## Documentation The NativePlatformScalarRequests table provides direct access to the native API protocol over an established connection to the HubSpot 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 HubSpot API server. - Catalog: `HubSpot` - Schema: `Native` - Alias: `npt` - Label: Native Platform Scalar Requests - 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` | `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 | ☐ | |