KarlS-dotnet-paymentintent | Stripe Developers | Page 1

worn berry Sep 16, 2021, 11:13 PM

#

@marble pivot hard to say unfortunately without concrete examples. Can you share your dotnet code? Also did you see that we support auto-pagination: https://stripe.com/docs/api/pagination/auto?lang=dotnet

marble pivot Sep 16, 2021, 11:14 PM

#

code here or into pastebin?

worn berry Sep 16, 2021, 11:14 PM

#

here is fine!

#

don't leak your API key

marble pivot Sep 16, 2021, 11:15 PM

#

did that once checking in code to github... that was costly

#

var service = new PaymentIntentService();
bool fetch = true;
while (fetch)
{
fetch = false;
var payments = service.List(options);

foreach(var pay in payments)
{
    Model.PaymentResponse obj;
    response.Add(obj = new Model.PaymentResponse()
    {
        ID = pay.Id,
        Status = pay.Status,
        Created = pay.Created,
        Description = pay.Description,
        Email = pay.ReceiptEmail,
        Amount = pay.Amount / 100
    });
}

fetch = payments.HasMore;
if (payments.HasMore)
    options.StartingAfter = payments.Last().Id;

}
return response;

worn berry Sep 16, 2021, 11:20 PM

#

hum that should paginate fine but I'm not sure what your response.Add does and how you turn that into a CSV

#

my advice is: log all payments ids to a file first and then check if what you have in the Dashboard is/isn't in the list?

marble pivot Sep 16, 2021, 11:20 PM

#

var response = new List<Model.PaymentResponse>();

#

that is my own Model.

#

which I pass back to my calling code

#

which I run an insert into my DB

#

foreach (var pay in payment.List(lasttxn))
{
xobj.SetQuery("stripepaymentintent_insert");
xobj.SetParameter("pay_id", pay.ID);
xobj.SetParameter("pay_status", pay.Status);
xobj.SetParameter("pay_date", pay.Created);
xobj.SetParameter("pay_description", pay.Description);
xobj.SetParameter("pay_email", pay.Email);
xobj.SetParameter("pay_amount", pay.Amount);
xobj.SetParameter("create_date", DateTime.Now);

                xobj.Query();
            }

#

the id I should be dealing with is a pi_ id correct?

#

I'm wondering if my Linq last() is screwing me up. Gonna try something different there.

worn berry Sep 16, 2021, 11:28 PM

#

yeah that's why I recommend adding a log line inside the foreach to compare

#

but if you move to auto-pagination your life would be easier!

marble pivot Sep 16, 2021, 11:29 PM

#

I will. Gonna test this as-is for now.

#

I'm getting kicked out after 352 payments

worn berry Sep 16, 2021, 11:36 PM

#

do you handle errors?

#

no one would "kick you out" but you might have a timeout for example and not properly handling errors https://stripe.com/docs/api/errors

marble pivot Sep 16, 2021, 11:36 PM

#

I do. I'm in code testing... but let me see if I missed catching any.

#

I use the term lightly 🙂

#

no errrors. could something be logged to the dev dashboard? have I exceeded a rate limit?

worn berry Sep 16, 2021, 11:44 PM

#

you can't exceed rate limits with sequential reads

#

sorry I can't really help without actionable information. Nothing "kicks you out" in our API without an error message

marble pivot Sep 16, 2021, 11:48 PM

#

are we talking apples and oranges?

#

I'm downloading all payments from the UI and getting over 2,000 records. In code, I'm using the PaymentIntenService and Itterating over each payment from the List function and then checking and continuing when HasMore is true.

#

I'm setting my Starting after property like this:

            fetch = payments.HasMore;
            if (fetch)
                options.StartingAfter = lastpay.Id;

#

lastpay looks like this (I've removed the Linq call)

#

PaymentIntent lastpay = null;
foreach(var pay in payments)
{
lastpay = pay;

#

I have to go... but I look forward to your response.

worn berry Sep 16, 2021, 11:57 PM

#

But I gave you multiple ideas of what to try. Auto-pagination is one, logging all payment intent ids in your code explicitly is a second one, and then comparing what you see in your export and diffing the list to find an example PI that was in the export and not your code export to understand the difference

#

I don't really have a better answer yet as it's mostly the same information as when we started, this is how you should debug this further

barren halo Sep 17, 2021, 4:57 AM

#

Hi @marble pivot I am trying to catchup. Can you update here again how did it go?

marble pivot Sep 17, 2021, 4:57 AM

#

Yes, thanks. I'm basing my failure on the fact that in the Strip User Dashboard, under payments, when I export I have more than 2,000 entries.

#

When I use the library PaymentIntentService and I try to capture ALL entries I only retrieve 352.

#

First I was using my own paging mechanism, using StartingAfter and my own While loop (C# code) and now have tried a foreach with ListAutoPaging and I am getting the exact same result, 352 entries.

#

Maybe I'm barking up the wrong tree?

barren halo Sep 17, 2021, 5:01 AM

#

I believe you are in correct direction. In your code with AutoPaging, are you doing something similar to this?

var service = new CustomerService();
var options = new CustomerListOptions {
  Limit = 3
};

// Synchronously paginate
foreach (var customer in service.ListAutoPaging(options)) {
  // Do something with customer
}

// Asynchronously paginate
await foreach (var customer in service.ListAutoPagingAsync(options)) {
  // Do something with customer
}

(It's from our API reference doc)

marble pivot Sep 17, 2021, 5:02 AM

#

I'm not using the CustomerService API at all.

#

Unless you just copied that here as a similar example

barren halo Sep 17, 2021, 5:03 AM

#

Yes I know, it's just an example

#

"similar example" yes

marble pivot Sep 17, 2021, 5:03 AM

#

ok, yep, doing exactly that.

barren halo Sep 17, 2021, 5:03 AM

#

okie that's weird. Do you have the request Id (from your Dashboard log)?

marble pivot Sep 17, 2021, 5:04 AM

#

Yes, 1 sec.

#

req_Po1d2qZIqTGTW5

deft prairie Sep 17, 2021, 5:04 AM

#

Also when you mentioned

I'm downloading all payments from the UI and getting over 2,000 records.
How did you download the payments? and do you have example payment that was not returned in your request?

marble pivot Sep 17, 2021, 5:05 AM

#

Yes, WSW, I'm using the Export options under the Payments tab.

#

So every Payment (intent) including Successes and Failures.

#

(and whatever other status is pulled down)

deft prairie Sep 17, 2021, 5:07 AM

#

yup, I mean have you compared the two list 2000 records <> 352 and see which ones are missing?

#

Those will be useful too to troubleshoot

marble pivot Sep 17, 2021, 5:08 AM

#

Well, sure but I was thinking that since the difference in count is so large that there was a more obvious reason for the discrpency.

#

Which ID should I be looking for exactly?

#

My CSV download include ch_, cus_, and card_ ID types.

deft prairie Sep 17, 2021, 5:10 AM

#

o, you only care payment_intent right?

#

ch_, cus_ and card_

#

shouldn't matter

#

because what your code are doing is to pull payments

#

i think that's the reason

marble pivot Sep 17, 2021, 5:10 AM

#

Yes, payment_intent. I need a complete accounting of every success and failure payments to use in my system.

deft prairie Sep 17, 2021, 5:10 AM

#

you've downloaded a bunch of unrelated objects

#

cus_, card_ are not payment

#

only pi_ matters

#

you should filter your csv and only count pi_xxxx

marble pivot Sep 17, 2021, 5:11 AM

#

Oh, well that is what is available in the UI.

#

let me see

#

on the Payments download in the Stripe Dashboard, can I specify to download the pi_ data?

#

with a filter I mean? (looking now)

deft prairie Sep 17, 2021, 5:14 AM

#

which dashboard page are you downloading things now?

marble pivot Sep 17, 2021, 5:14 AM

#

Stripe Payments

#

I see I can add PagmentIntent ID to my results

deft prairie Sep 17, 2021, 5:14 AM

#

yeah, can you copy/paste the link

#

?

marble pivot Sep 17, 2021, 5:15 AM

#

https://dashboard.stripe.com/payments

deft prairie Sep 17, 2021, 5:15 AM

#

How did you export the list?

#

that's the payment page, should only contain payment

marble pivot Sep 17, 2021, 5:16 AM

#

Right, but that is was I need (in code and in my system) a complete accounting of every transaction (success or fail)

deft prairie Sep 17, 2021, 5:17 AM

#

correct, that's the page you should use to export

#

and you should only care about the record with pi_xxxx

#

because that's the payment records

marble pivot Sep 17, 2021, 5:18 AM

#

Ah! I added PaymentIntent column to my results and now I am seeing that not every row actually has a pi_ number

#

Gotcha. But @deft prairie I also need the Failed transaction attemps. I them in here and indeed, they do not have a pi_xxxx number

deft prairie Sep 17, 2021, 5:20 AM

#

pi_xxx will contain status, status will tell you if they are successful

#

only succeeded ones are completed payment

marble pivot Sep 17, 2021, 5:21 AM

#

I understand but I need a list of both succeeded and failed attempts. I need to download the failed attempts. Is this available in the API?

deft prairie Sep 17, 2021, 5:25 AM

#

no

#

you have to list all the success and failed one, then filter and group them yourself

marble pivot Sep 17, 2021, 5:27 AM

#

Wait. I'm confused. 1) I'm not seeing any Failed attemps when i use the .NET API to retrieve ALL PaymentIntents, only successful ones. and 2) I'm not clear if there is another approach, withing the API to fetch the FAILED attemps.

deft prairie Sep 17, 2021, 5:28 AM

#

Are you sure you only get the successful one?

marble pivot Sep 17, 2021, 5:29 AM

#

Yes, with the built in options, yes. Is there an option to expand my filter? Maybe be default in only produces succesful results?

#

In the API, tested now several times with 2 different approaches is 352.

deft prairie Sep 17, 2021, 5:31 AM

#

ok, for this req_Po1d2qZIqTGTW5 you just shared
you are pulling payment_intent using this parameter

{
  limit: "100",
  starting_after: "pi_1JA4BtG30Vl6ne6NyuBHeL3p"
}

this pi_1JA4BtG30Vl6ne6NyuBHeL3p status is cancelled

#

it is not a successful payment

marble pivot Sep 17, 2021, 5:33 AM

#

So you are saying that is not a good staring_after object?

deft prairie Sep 17, 2021, 5:35 AM

#

what I am saying is that, listing payment_intent API will return all the payments including successful and failed one

#

this pi_1JA4BtG30Vl6ne6NyuBHeL3p is an example of failed one (due to cancellation)

marble pivot Sep 17, 2021, 5:36 AM

#

Here is the 1st request in my attempt at using ListAutoPaging: req_LDjFPknJ5lAucg

#

These are the next 3: req_WQlTWtoyNxcx4W, req_CHEzNtQYeZWAUq, req_O2kEiz3e2xCYN7

#

Right, but what I am saying is, my request for the PaymentIntents is not retrieving the complete set of PaymentIntents.

deft prairie Sep 17, 2021, 5:39 AM

#

I thought we cleared that up because the way export the the payment_intent?

#

cus_, ch_xxx and card_ are not payment_intent and you should not compare them

marble pivot Sep 17, 2021, 5:40 AM

#

I'm not using the export in my solution, that is just a proof of concept. I am going after the data programatically.

deft prairie Sep 17, 2021, 5:40 AM

#

ok, then how can you tell you are missing data then?

marble pivot Sep 17, 2021, 5:41 AM

#

Ahh... I have a know customer who paid, their credit card was declined and I can't find their failed/declined PaymentIntent record.

deft prairie Sep 17, 2021, 5:42 AM

#

do you have your customer email or ID?

marble pivot Sep 17, 2021, 5:42 AM

#

yes. 1 sec.

#

(is this chat here public?)

deft prairie Sep 17, 2021, 5:43 AM

#

yes. you can dm me

marble pivot Sep 17, 2021, 5:43 AM

#

done

deft prairie Sep 17, 2021, 5:44 AM

#

Ok, with the email, it is much easier

#

non-coding way, you can go to your dashboard, and search the email address xxxxx@xxxx.com

marble pivot Sep 17, 2021, 5:45 AM

#

yes

deft prairie Sep 17, 2021, 5:45 AM

#

it will show all the customer created using the email

#

actually this is better go to your https://dashboard.stripe.com/customers

#

filter by email xxxxx

#

#

you can find all the customers

marble pivot Sep 17, 2021, 5:46 AM

#

I'm doing that already

deft prairie Sep 17, 2021, 5:46 AM

#

then click into them and find all the payment done

marble pivot Sep 17, 2021, 5:46 AM

#

Filters Status Failed.

deft prairie Sep 17, 2021, 5:47 AM

#

there is no status

marble pivot Sep 17, 2021, 5:47 AM

#

Perfect. Now how do I do this in code?

deft prairie Sep 17, 2021, 5:47 AM

#

same thing

#

first

find all the customers

marble pivot Sep 17, 2021, 5:47 AM

#

There is Status on the Payments dashboard.

deft prairie Sep 17, 2021, 5:47 AM

#

https://stripe.com/docs/api/customers/list?lang=node#list_customers-email

Stripe API reference – List all customers – Node

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

#

with email

#

loop through the customer found, and list the payment_intent with the customer_ID
https://stripe.com/docs/api/payment_intents/list?lang=node#list_payment_intents-customer

Stripe API reference – List all PaymentIntents – Node

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

marble pivot Sep 17, 2021, 5:48 AM

#

So, for every customer, for every payment intent?

#

I can do that, but before I do that, are you saying that I can't get a list of failed payments using the API?

#

Your UI allows for it

deft prairie Sep 17, 2021, 5:50 AM

#

no, you will get everything

#

succeeded and failed

marble pivot Sep 17, 2021, 5:50 AM

#

but that is exactly what I want.

#

but my result does not include failed.

deft prairie Sep 17, 2021, 5:53 AM

#

which one does not contain failed one?

marble pivot Sep 17, 2021, 5:53 AM

#

This code here, it only return Succeeded and Canceled, no Faield.

        var service = new PaymentIntentService();
        foreach (var pay in service.ListAutoPaging(options))
        {

deft prairie Sep 17, 2021, 5:54 AM

#

can you share the list of returned results?

#

this pi_1JA4BtG30Vl6ne6NyuBHeL3p was returned result and it failed

marble pivot Sep 17, 2021, 5:55 AM

#

Status is cancelled. I will DM you.

deft prairie Sep 17, 2021, 5:56 AM

#

its ok to discuss here, can you first try to implement by the customer

#

it will limit the returned list

#

since you want to check per customer

marble pivot Sep 17, 2021, 6:02 AM

#

Wait.. I have an example of a failed payment intent but this failed payment intent is not showing up in the list of all PaymentIntetents I download. I not not want to loop through every customer. Why isn't this failed payment intent showing up in this list of all payment intents?

#

Can you reverse lookup the payment intent for the email I sent?

#

WAIT.. should I be looking at charges, success and failures instead?

deft prairie Sep 17, 2021, 6:11 AM

#

Charge API will work too

#

Same thing, you will have to list charges by customer https://stripe.com/docs/api/charges/list?lang=node#list_charges-customer

Stripe API reference – List all charges – Node

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

marble pivot Sep 17, 2021, 6:11 AM

#

Well, Payment API isn't working! Almost done with test code.

#

ok, have some to test.

#

ch_1IKNuUG30Vl6ne6Nb5Slc6FZ succeeded
ch_1IKAc0G30Vl6ne6NbKP4Qd3z succeeded
ch_1IK92dG30Vl6ne6NsEzCbwW9 succeeded
ch_1IK7UgG30Vl6ne6Nx8mLNYmq succeeded
ch_1IK23TG30Vl6ne6Ne5VqAnOP succeeded
ch_1IJqtlG30Vl6ne6NxISnl8gT failed
ch_1IJqr3G30Vl6ne6NWM9V103j failed
ch_1IJmLPG30Vl6ne6Nb1ZO0uSR failed

#

and I can retreive the balance transaction id, which is what I really really need.

#

ch_3JaQ7rG30Vl6ne6N0Ldo62ZP txn_3JaQ7rG30Vl6ne6N01BE7H01 succeeded

#

Hey @deft prairie I think I am all set! Thank you for all of this help. Goodnight. Bedtime here.

#KarlS-dotnet-paymentintent