geeky-account-balance

[strange plinth]

Hi there, we don't have sigma query examples to share

You can reach out to our support team for guidance on Sigma: https://support.stripe.com/contact

[spare sinew]

Already talked to support, they couldn't help.

At least can you tell me which table will have the list of failed transfer reversals? I searched the schema, could not find it

[ivory sapphire]

I would have thought the transfer_reversals table would have that but I am seeing that they don't have statuses assosciated with them. Do you have the ID of an example failed transfer reversal?

[spare sinew]

Hi @ivory sapphire, thank you for checking! Here is a live sample : https://dashboard.stripe.com/logs/req_lIxINHReBf4wtC
To be more specific, I want to know all the transfer reversals that failed due to insufficient balance in the connected account. We use Separate Charges and Transfers model with Stripe Connect.

If you can't access via the url, here you go tr_3NHP4sGXYV26Jsm83dApzA7D

[ivory sapphire]

Ah, so I don't think there is a place to list failed reversals. The API request is failing and no reversal object is being created.

I don't think there is a programmatic way to look at your logs here so you may have to go to the dashboard page and filter for /v1/transfers/*/reversals

[spare sinew]

Yeah, I was looking for a way to filter the logs only for failed transfer reversals. Got it, let me try that.

Cool, I see it. Any way I can export this into CSV or something? Or even if I can filter again for a specific connect account, that also helps

[ivory sapphire]

Not as far as I know. I will check with my colleagues and get back to you

[spare sinew]

Thank you! Or if I can query Logs using an API, I can do that filtering in code.

[ivory sapphire]

Unfortunately I am not finding a way to export your logs or look through them programmatically. I can file a feedback request for it but at the moment I am not sure if there is a better way to look back at these reversal failures.

If you ask support they may be able to export your logs for you though I am not sure if we offer that.

[spare sinew]

Hmm, that's too bad. And my use-case is not even super niche, just want to get data on all failed transfer reversals 🙂 Thanks anyway, I'll try talking to support again to export the logs or apply connect account id filter

Sorry another question. So I stopped payouts for acct_1MJJDsImSHOFYOZF, and they have some balance. But when I try to reverse a tranfer, which failed before tr_3NHP4sGXYV26Jsm83dApzA7D, it still gives insufficient balance error. Why is that?

[ivory sapphire]

Good question. Looking in to that and will get back to you

[ivory sapphire]

It look like the balance on that account is pending. It needs to go from pending to available before you can transfer it to or away from the account.

[spare sinew]

Ah, I see.

[ivory sapphire]

I'm not sure if you can cancel the transfer before then or something. Checking in to this

[serene solstice]

👋 Taking over. I would recommend working with our support team. I'm sorry that's not wht you want to hear but this is really an account-specific support question about the balance and handling negative and pending balance and our support team is better equipped to help: https://support.stripe.com/contact

geeky-account-balance

[spare sinew]

Sure, thanks. I wish I could get a report of all failed transfer reversals, or even just export the logs. Unfortunately, looks like I have to manually look through the logs. Support also couldn't help