Kamesh | Stripe Developers | Page 1

steel zephyrBOT Jun 28, 2023, 12:23 AM

#

main temple Jun 28, 2023, 12:27 AM

#

supplied confirm = true and off_session = true and sca required
You may look for the error with authentication_required

user presented with 3ds window but didn't complete or failed verification?

If customer is presented 3DS and doesn't complete it, Payment Intent status will still remain as requires_action
If customer fails authentication, last_payment_error.code will be payment_intent_authentication_failure

dense fulcrum Jun 28, 2023, 12:48 AM

#

thanks.

#

for the first case, what should be status in stripe sigma DB?

#

is it charges.status = 'failed' ?

#

does this look correct ?

#

select
charges.id,
payment_intents.id,
payment_method_details.card_moto,
payment_intents.setup_future_usage,
payment_intents.status,
date_format(charges.created, '%Y-%m-%d') as created_date,
charges.amount,
charges.status,
charges.failure_code,
charges.failure_message,
charges.outcome_network_status,
charges.outcome_reason
from
charges
join payment_intents on payment_intents.id = charges.payment_intent
join payment_method_details on payment_method_details.charge_id = charges.id
where
charges.status = 'failed'
and charges.failure_code = 'authentication_required'
order by
charges.created desc

main temple Jun 28, 2023, 12:58 AM

#

This looks right to me

dense fulcrum Jun 28, 2023, 12:59 AM

#

thanks

#

when we pass off_session = true do they get reflected as setup_future_usage = off_sesson in stripe sigma db?

main temple Jun 28, 2023, 1:08 AM

#

No! off_session and setup_future_usage are two different parameters and serve different use cases. off_session is to inform Stripe that customer is absent from this payment whereas setup_future_usage is to save the payment method that the customer uses

dense fulcrum Jun 28, 2023, 1:14 AM

#

Thanks. this payment intent is one of the result from the above query, can you please confirm if this falls under confirm=true and offession = true ? https://dashboard.stripe.com/payments/pi_3NMCsTIliO10oyBM2vz0hi6z

Stripe Login | Sign in to the Stripe Dashboard

Sign in to the Stripe Dashboard to manage business payments and operations in your account. Manage payments and refunds, respond to disputes and more.

#

i can't find any column which indicates that we are setting offession=true

main temple Jun 28, 2023, 1:19 AM

#

You may refer to the creation request of this Payment Intent here: https://dashboard.stripe.com/logs/req_CgU5wCtm4Isarv

Both confirm and off_session fields are set to true

dense fulcrum Jun 28, 2023, 1:21 AM

#

thanks

main temple Jun 28, 2023, 1:23 AM

#

No problem! Happy to help 😄

dense fulcrum Jun 28, 2023, 1:52 AM

#

Also can you please help what field i can filter to identify transactions that required 3ds (success or failure)

main temple Jun 28, 2023, 2:01 AM

#

You may look for payment_method_details.card.three_d_secure in Charge object if 3DS has been performed: https://stripe.com/docs/api/charges/object#charge_object-payment_method_details-card-three_d_secure

Stripe API reference – The charge object – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

dense fulcrum Jun 28, 2023, 2:29 AM

#

Thanks. from sigma db perspective, can we use ayment_method_details.card.3ds_succeeded since payment_method_details.card.three_d_secure is not in db

#Kamesh