ebellotpu6

[languid lichen]

Sure, what are they looking to build?

[wet dirge]

The client is asking me to automate a process that is carried out manually from the dashboard.

The process is as follows:

1)In the dashboard, go to payments. Once in payments, select the failed payments filter, and export.

[languid lichen]

Sure, should be possible. Important to note that 'failed' isn't a status that maps directly to a status on the corresponding API object: https://docs.stripe.com/api/payment_intents/object#payment_intent_object-status

'Failed' in the Dashboard can be any of of a few of those, including requires_payment_method and requires_action

[wet dirge]

2. Now foreach customer that has a payment failed, we need to get the link on the invoice failed, like this: https://invoice.stripe.com/i/acct_1MBekFAd02IkV8oW/live_YWNjdF8xTUJla0ZBZDAySWtWOG9XLF9QVGxndk13Q0U2MndQaE9XWkkzZ0FXUWZySUpzdGpGLDk4OTAwMjk00200R8cpQA7E?s=db

[languid lichen]

Sure, you can just 'expand' the invoice field via the API when the list the objects and it'll be included in the API response: https://docs.stripe.com/api/payment_intents/object#payment_intent_object-invoice

[wet dirge]

so, I first I have to filter the paymentintents for status != succeeded. Then I can find the link in the invoice field?

[languid lichen]

Yes, if you 'expand' it in your API request to list: https://docs.stripe.com/api/expanding_objects

[wet dirge]

okey

[languid lichen]

And then there'll be a hosted_invoice_url field: https://docs.stripe.com/api/invoices/object#invoice_object-hosted_invoice_url

[wet dirge]

thank you