notmars - Sigma | Stripe Developers | Page 1

zealous lagoon Apr 7, 2022, 6:00 PM

#

Hi 👋

#

Unfortunately we cannot help too much beyond what is shown here: https://stripe.com/docs/sigma/transactions#refunds

You can restrict the refund types by examining the balance transactions as we detail here

spring needle Apr 7, 2022, 6:46 PM

#

the problem is not so much the refund and the balance, but the reason details esp when the generic reasons are not selected...

zealous lagoon Apr 7, 2022, 6:46 PM

#

Hmmm ... 🤔

#

When generic reasons are not selected what values are you getting?

spring needle Apr 7, 2022, 6:47 PM

#

our support engineer are putting the reason for the refund in the "other" which should be in a note

#

the problem is I dont get if it s a credit_note

#

a connect_..._credit_note

#

and so on 🙂

#

kinda lost in the schema to find where your UI is putting the "other" info

zealous lagoon Apr 7, 2022, 6:48 PM

#

Oh, okay so the user selects "other" and then there's a note associated where the detail what this "othe" is

spring needle Apr 7, 2022, 6:50 PM

#

that s in the Stripe UI. when you select the menu for a refund, you have a selection of reason choice, and then "other", if you select other you can put a text, which is what I'm looking for in the DB 🙂

#

Screen_Shot_2022-04-07_at_2.51.12_PM.png

icy roost Apr 7, 2022, 7:01 PM

#

Do you have the IDs of some of the refunds where you are seeing the notes in different places?

spring needle Apr 7, 2022, 7:06 PM

#

you want prod or test ?

icy roost Apr 7, 2022, 7:08 PM

#

Either should work

spring needle Apr 7, 2022, 7:08 PM

#

https://dashboard.stripe.com/test/payments/pi_3Km0REACWsQhiwhD0rExJmxd

Stripe Login | Sign in to the Stripe Dashboard

Sign in to the Stripe Dashboard to manage business payments and operations in your account. Manage payments and refunds, respond to disputes and more.

#

that s on test

#

Screen_Shot_2022-04-07_at_3.09.27_PM.png

icy roost Apr 7, 2022, 7:21 PM

#

Thanks, still looking in to this. Having trouble looking up some docs on this. Will get back to you with what I can find

spring needle Apr 7, 2022, 7:26 PM

#

thanks you so much, cause I really tried, and I'm a bit lost 🙂

icy roost Apr 7, 2022, 8:09 PM

#

I think that the platform and connected account refunds will have to be seperate queries but they should just have to be the two.

#

Are there refunds that you are currently worried about missing that may not be showing up through those queries or the credit note query?

spring needle Apr 7, 2022, 9:02 PM

#

the refund are not the problem

#

we get the refun alright

#

what I need is the note content attached to it

#

which I dont know if it s a credit note

#

or something else like a reason field in some of those tables

zealous lagoon Apr 7, 2022, 9:27 PM

#

Hi 👋 I'm back. We're still looking

zealous lagoon Apr 7, 2022, 10:19 PM

#

Is it possible for you to generate a test refund where you select "Other", add a note, and provide us the ID of the request? The ID would start with re_

#

If/when you come back online, this would be a good question to write in to Support with. They have more resources to troubleshoot Sigma queries than we do: https://support.stripe.com/contact/email

#notmars - Sigma