ibgoldbergs | Stripe Developers | Page 1

runic gullBOT May 3, 2023, 7:36 PM

#

green hearth May 3, 2023, 7:38 PM

#

on behalf of doesn't really make sense in this request, since you (the platform) are debitting the connected account balance. Why are you trying to set that?

#

Arguably this should fail as a 4xx error, but it looks like it gets ignored instead

lone cypress May 3, 2023, 7:39 PM

#

Trying to build a report to show all the charges we made that were due to debiting a connected account

green hearth May 3, 2023, 7:39 PM

#

How does that relate to setting OBO on the account debit?

lone cypress May 3, 2023, 7:40 PM

#

because it allows us to pull in the name of the connected account

#

if there is a better way, i'd love to know

green hearth May 3, 2023, 7:47 PM

#

lone cypress because it allows us to pull in the name of the connected account

What do you mean by that?

#

The account details are available in the source of the charge here:
https://dashboard.stripe.com/logs/req_MtMj9tRjwszkLk

lone cypress May 3, 2023, 7:48 PM

#

maybe lets drop OBO, and move onto the problem i'm trying to solve. Want to generate a report of charges where we debited the connected account

#

can we do this via sigma?

#

select
connected_accounts.id,
connected_accounts.business_name,
charges.id
from charges
left join connected_accounts on connected_accounts.id = charges.source_id

This doesn't seem right in Sigma

runic gullBOT May 3, 2023, 7:49 PM

#

green hearth May 3, 2023, 7:51 PM

#

We aren't really equipped to help with sigma queries, but it looks like the information you need is present on the charge. Looking at the request above you can see payment_method_details.type='stripe_account' and source.id='acct_1234'

#

So you might want to filter/join on those

#ibgoldbergs