OrderRiskAssessments
Lists fraud risk assessments attached to orders with scores and reasons.
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 globally unique Id of the order being assessed. | |
| RiskLevel | String | True |
The likelihood that the order is fraudulent, as determined by this risk assessment. The allowed values are HIGH, LOW, MEDIUM, NONE, PENDING. | |
| Facts | String | True |
Optional descriptive details about the risk assessment. Values are specific to the risk provider. | |
| ProviderId | String | True |
The globally unique Id of the provider that generated the assessment. | |
| ProviderTitle | String | True |
The name of the application or service that performed the risk assessment. |