SSIS Components for Stripe

Build 24.0.9062

EarlyFraudWarning

Query an early fraud reported by the customer.

Table Specific Information

Select

The 本製品 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 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062