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 operators: =, >, <, >=, <=.
- PaymentIntent supports the following operator: =.
- AccountId supports the following operator: =.
The rest of the filter is executed client-side within the connector.
You can select from EarlyFraudWarning with the following queries:
SELECT * FROM EarlyFraudWarning WHERE Id = '123321'
SELECT * FROM EarlyFraudWarning WHERE ChargeId = 'ch_3NASvLJSsh'
SELECT * FROM EarlyFraudWarning WHERE Created >= '2024-01-01'
SELECT * FROM EarlyFraudWarning WHERE Livemode = true
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get fraud warning for. |