#pablo-mn_api
echo needleBOT
👋 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/1303523189367902218
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
ember rampart
Hi there
Can you provide more context about why you're trying to do this and what you're trying to achieve specifically?
raven notch
Hello! thanks for your reply.
So, we want to make that our customers update their credit cards to make them to come to our website and re-enter their information using stripe-checkout session, that's been working great for us, but there are still around 200K users that we want to communicate and make them to do this update
In order to send email campaigns, we want to only focus on those who don't have a credit card in stripe, and we need to measure the success of the campaign by doing daily (or every 2 days) reports of customers with credit cards in stripe
echo needleBOT
raven notch
That's our current work right now.
THen, secondary is the fact that we want to provide our clients with the amount of people that have a Credit Card on file from their customers
oak gorge
Thanks for sharing the details. Stripe doesn't have an API to retrieve bulk information.
We don't recommend retrieving the customers default payment method on regular basis and this can potentially hit the rate limit: https://docs.stripe.com/rate-limits
I'd recommend retrieving all customers' default payment method only once to get a baseline records on the customer that have credit card in Stripe. Your system will then listen to customer.updated event for any change of default payment method on the Customer object and keep it sync within your database.
raven notch
Ok, yes, I'm aware of that limit,.. I've seen that error many times.. what you suggest makes sense
Thank you sir.
I have other question, regarding Payments/charges...
I should open another thread for that. yes?
oak gorge
Feel free to ask your question here 🙂
raven notch
ok thanks
so, here's the thing.
My company client's are Property Managers, and they have their residents and each resident is a "Customer" in Stripe, so in order to identify what customer belongs to what Property Manager (or Building), I use metadata.. so far so good,
But then, when the system charges someone, we attach a metadata "buildingId" to each Payment Intent that we generate
the thing is that now we need to run a report of what was charged to all people in the different building so we can split the money generated with our clients (the property managers)
basically, a report of Payments captured minus those that were refunded, By metadata and By date (it is a Monthly Report)
and I'm wondering what's the right way to generate something like that..
I've been thinking that making a SUM of Payment Intents "successful" and then look for REFUNDs
but there are also charge objetcs.. and invoices...
so I'm kind of confused
oak gorge
How are you collecting the payments? Is it through Invoice or direct Payment Intent integration?
raven notch
we create a PaymentIntent and attach the metadata to that
oak gorge
For direct Payment Intent integration, there shouldn't be invoice (with ID in the format of in_xxx).
I'd recommend using itemised balance or payout reconciliation report and referring to payment_metadata for buildingId: https://docs.stripe.com/reports/select-a-report
oak gorge
Sounds good! Feel free to let us know if you have any further question