OrderRiskAssessments
Contains fraud risk assessment results for orders, including scores, triggers, and recommendations.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- 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 |
The unique identifier of the order being evaluated by this risk assessment. | |
| RiskLevel | String | True |
Indicates the assessed likelihood that the order is fraudulent, based on data from the risk evaluation process. The allowed values are HIGH, LOW, MEDIUM, NONE, PENDING. | |
| Facts | String | True |
Additional contextual information or factors that influenced the risk evaluation. The specific values depend on the provider's assessment logic. | |
| ProviderId | String | True |
The unique identifier of the service or application that generated this risk assessment. | |
| ProviderTitle | String | True |
The display name of the risk assessment provider application responsible for generating the evaluation. |