#rayray-report
random solstice
select * from connected_accounts
and i take that back - 28 is the number
my apologies - though i do have over 300
violet raven
Okay you said the query is just select * from connected_accounts if that helps
So you are using Sigma here, correct?
violet raven
Are you creating all of your Connected Accounts?
Or are you connecting some via OAuth that were already created?
I think Sigma will only return those accounts that you have platform controls over (meaning you created them)
random solstice
we've always created them via the OAuth route
violet raven
Gotcha, so likely the ones that are being returned are when someone creates a new account with your platform via OAuth.
random solstice
was there an update that is relatively new that would give us platform controls over any new standard connected accounts?
violet raven
As opposed to connecting a previously created account.
random solstice
ohhhh wow - that is rough
we've always used the OAuth route so still a little weird
violet raven
The change happened about a year ago: https://support.stripe.com/questions/standard-connect-with-platform-controls.
random solstice
ah
violet raven
However, this didn't change your Sigma behavior
Prior to this change you wouldn't have been able to retrieve any Standard accounts via Sigma.
random solstice
yes that was my experience
makes complete sense
now the real question...how do i get those other accounts to allow for us to manage via platform controls...
is there anything in stripes power to allow for this. without it we're in all types of trouble from a reconciliation and reporting standpoint
violet raven
Yeah not possible unfortunately. We can't give platform controls to these accounts that can be connected to multiple platforms (if they were created as a standalone account originally then that is the case). This would allow platforms to see sensitive data about other accounts and platforms.
You should still be able to do most of your reporting and reconciliation however.
Like what data can you not get that you need for reporting/reconciliation?
random solstice
not so shoot myself in the foot but you can already do so via dashboard
🙂
well for instance if I want to see the sum of source charge amount and the application fees grouped by account
so i can say "this is how much money we charge with varying application fees to each client" then maybe "by service"
violet raven
not so shoot myself in the foot but you can already do so via dashboard
Not sure what you mean by this?
random solstice
you had said that if was a security concern for connecting to other accounts that have additional platforms connected. My assumption is that seeing charges/fees etc made on other platforms is the issue. If I "view dashboard as" I can see all this information I beleive
but that aside - how might I answer the question I posed for instance?
violet raven
Ah I see what you are saying. Yeah I'm not as familiar with the Dashboard as we mainly help with the API.
That said, I think you should still be able to use the Reports API to get what you need: https://stripe.com/docs/reports/api
That should still return the data from your Connected Accounts that don't have platform controls.
random solstice
interesting - do you know if any metadata is available through that api ?
would be helpful but i could probably get away with not having it - just curious
and thank you so much for your responses here. I'll check the reports api out and see if I can pull some in and do some queries to join the accounts/fees/sourceamounts
violet raven
I do think metadata should be returned. If you take a look at https://stripe.com/docs/reports/report-types you can see each different type of report and the columns
random solstice
great - will give it a whirl
violet raven
👍
random solstice
thank again!