EarlyFraudWarning
Query an early fraud reported by the customer.
Table Specific Information
Select
The connector uses the Stripe API to filter the results by the following columns and operators:
- Id supports the following operator: =.
- ChargeId supports the following operator: =.
- Created supports the following operator: =,>,<,>=,<=.
- PaymentIntent supports the following operator: =.
- AccountId supports the following operator: =.
The rest of the filter is executed client-side within the connector.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
SELECT * FROM EarlyFraudWarning SELECT * FROM EarlyFraudWarning WHERE Id = '123321' SELECT * FROM EarlyFraudWarning WHERE ChargeId = 'ch_3NASvLJSsh'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of fraud warning. | |
| Actionable | Boolean | An EFW is actionable if it has not received a dispute and has not been fully refunded. | |
| ChargeId | String | The Id of the charge. | |
| Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
| FraudType | String | The type of fraud labelled by the issuer. Supported values are card_never_received, fraudulent_card_application, made_with_counterfeit_card, made_with_lost_card, made_with_stolen_card, misc, and unauthorized_use_of_card. | |
| Livemode | Boolean | true if the object is in live mode andfalse if in test mode. | |
| PaymentIntentId | String | The Id of the Payment Intent. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get fraud warning for. |