#Eric-customer-country
still imp
Hi 🙂
viscid torrent
So what you want here is the payment_method_details.card.country on the Charge object: https://stripe.com/docs/api/charges/object#charge_object-payment_method_details-card-country
still imp
I tried that method as well. I don't get good coverage that way either
viscid torrent
Hmm you should have. Do you have an example where the country wasn't present there?
viscid torrent
That doesn't really do anything for me
still imp
Give me a sec
viscid torrent
That looks to be querying your own database
still imp
That's from the payment_method_card endpoint
If I use payment_method_id to match the 2, I endup with about 22k charges without country
viscid torrent
Can you show me one of those charge IDs (ch_xxxx) that doesn't have country?
I suspect this is actually just an issue on your end where you aren't retrieving the data correctly.
still imp
As any developer would
Give me a sec. I don't understand what you're saying though. If I only have 18k unique payment id and 40k charges with unique payment id.
We have a 22k gap where I can't match
viscid torrent
Yeah sorry you are just saying numbers. Charges are created each time a payment is attempted. So there won't be a match between the amount of successful payments and charges. There also won't be a match between the amount of PaymentIntents and Charges. There are several nuances here so looking at real examples is the best way to evaluate what is going on.
still imp
Yeah I can filter where status = "succeeded" as well. The gap is lower but we still have one. Give me a sec I'll try to show a real example
viscid torrent
Great
still imp
Looks like my limited skills in SQL won't do it. I have to join those 2 tables and don't know how. Can I get back to you on this?
Don't want to make you wait while my developer gets back.
viscid torrent
Yep we are here 24/5
So feel free to pop back into the main channel whenever and we would be happy to help
still imp
Thanks!