bensears-charge-payout | Stripe Developers | Page 1

dawn tundra Sep 27, 2021, 8:08 PM

#

We don't directly show this in the API no. The way to do it is to reverse the approach and start with the Payout itself

You can use the List BalanceTransactions API https://stripe.com/docs/api/balance_transactions/list and pass payout: 'po_123' to find all the BalanceTransactions associated with that Payout. This represents all the charges, refunds, disputes, etc. all bundled into one Payout and each BalanceTransaction object has a source property that maps to a given object like the ch_123 or re_123 (which you can https://stripe.com/docs/expand)

So for each Payout you list what's in it and keep track of it so that you can know which Payout contains which Charge (and refund and dispute, etc.)

opal whale Sep 27, 2021, 8:12 PM

#

i see, i didn't see the payout field in sigma, is this only accessible via API?

#

i'm trying to build a report in sigma with all the charges, and have a column for the payout id

#

but it looks like theres no way to get the payout?

sleek torrent Sep 27, 2021, 8:26 PM

#

I believe you can find this info in the balance_transactions table, where the payout ID is found under automatic_transfer_id

sleek torrent Sep 27, 2021, 8:48 PM

#

@opal whale does that answer your question?

opal whale Sep 27, 2021, 9:13 PM

#

i don't think that's the case, from what i've seen that field is only filled out on payout type txns

sleek torrent Sep 27, 2021, 9:19 PM

#

Are you using automatic payouts or manual ones?

#bensears-charge-payout