OrderRiskAssessments
Retrieves a list of risk assessments for orders.
Table-Specific Information
Select
The component uses the Shopify API to process WHERE clause conditions built with the following column and operators. The component processes other filters client-side within the component.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderRiskAssessments WHERE OrderId = 'Val1'
Insert
The following columns can be used to create a new record:
OrderId, RiskLevel, Facts (references OrderRiskAssessmentFacts)
OrderRiskAssessmentFacts Temporary Table Columns
| Column Name | Type | Description |
| Description | String | A description of the fact. |
| Sentiment | String | Indicates whether the fact is a negative, neutral or positive contributor with regards to risk. |
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. |