#abuznego_customer-fingerprint

1 messages ¡ Page 1 of 1 (latest)

hollow cloakBOT
#

👋 Welcome to your new thread!

⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.

⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.

🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1283572776623542323

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

brittle kettle
#

abuznego_customer-fingerprint

#

Hey @sonic brook Can I ask you to be a bit more descriptive and explain what you are really trying to do? Are you writing code, using the Dashboard, using Sigma, something else?

sonic brook
#

I have a list of fingerprints associated with fraudulent disputes. I would like to know all the customers I have associated with the fingerprint using the API so I can script cancellations for them.

brittle kettle
#

If you have access to Sigma this would take you 30 seconds and it might be worth paying for it.

Via the API, there isn't a straightforward way unfortunately. You'll have to do something like this:

  1. List all Customers using the List Customers API https://docs.stripe.com/api/customers/list
  2. For each Customer list all its PaymentMethods using the List Customer PaymentMethods API: https://docs.stripe.com/api/payment_methods/customer_list
  3. For each PaymentMethod, check if it's a card and if so if the card[fingerprint] property matches one of the fingerprints you want to find
sonic brook
#

What would the steps be for doing this with Sigma?

hollow cloakBOT
brittle kettle
#

Sigma has all PaymentMethods in the payment_methods table with the card_fingerprint column so you'd do one SQL query

sonic brook
#

how do i access sigma if my company has already enabled it

brittle kettle
#

It's in the Dashboard, if you search for Sigma it should be there