OrderRiskAssessments
Retrieves a list of risk assessments for orders.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- OrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM OrderRiskAssessments
SELECT * FROM OrderRiskAssessments WHERE OrderId = 'Val1'
Insert
The following columns can be used to create a new record:
OrderId, RiskLevel, Facts
Columns
| Name | Type | ReadOnly | References | Description |
| OrderId | String | True |
A globally-unique ID. | |
| RiskLevel | String | True |
The likelihood that the order is fraudulent, based on this risk assessment. The allowed values are HIGH, LOW, MEDIUM, NONE, PENDING. | |
| Facts | String | True |
Optional facts used to describe the risk assessment. The values in here are specific to the provider. | |
| ProviderId | String | True |
A globally-unique ID. | |
| ProviderTitle | String | True |
Name of the app. |