sayori | Stripe Developers | Page 1

jovial haloBOT Sep 21, 2022, 10:39 PM

#

spring sigil Sep 21, 2022, 10:40 PM

#

Hi, are you trying to see how many payment methods each customer has? Are you able to add more details here so I can better assist?

night vapor Sep 21, 2022, 10:41 PM

#

I'm interested in

total number of Customer entities we have connected on Stripe
across all Customers, total number of PaymentMethods all aggregated

spring sigil Sep 21, 2022, 10:44 PM

#

I see, you'd be able use this API, https://stripe.com/docs/api/customers/list and auto paginate, https://stripe.com/docs/api/pagination/auto.

#

Then, count the total customers that way.

night vapor Sep 21, 2022, 10:46 PM

#

Ah, auto paging iter will make this slightly more convenient for me. In the end, this will still call the API the same number of times in total compared to if I use starting_after to page manually, right?

spring sigil Sep 21, 2022, 10:47 PM

#

Yes, this handles fetching large lists of resources without having to manually paginate results and perform subsequent requests.

night vapor Sep 21, 2022, 10:47 PM

#

Got it, thanks 👍

spring sigil Sep 21, 2022, 10:48 PM

#

On the second ask, you can only only list a specific customer's payment method, https://stripe.com/docs/api/payment_methods/customer_list. What are you trying to solve by aggregating the total number of payment methods across all of your customers?

night vapor Sep 21, 2022, 10:50 PM

#

We are working with cybersecurity insurance who is asking us:

Please provide an approximate total unique PII, PHI, and credit card record stored or processed by the applicant or third party vendors

A total count of customers, and how many payment methods we have attached total, should suffice here. Do you have any other suggestions?

spring sigil Sep 21, 2022, 10:55 PM

#

Depending on how many customers you have, you might want to write a script to to list the payment methods attached to a customer here: https://stripe.com/docs/api/payment_methods/customer_list. You'd want to gradually make these requests. If you have way too many customers, then I'd recommend writing in to Stripe Support. Our support team will be able to assist: https://support.stripe.com/contact

night vapor Sep 21, 2022, 10:58 PM

#

Sounds good, I'll probably check in with email support - we have something on the order of 60,000 customers

#sayori