#joao_connect-sigma
latent houndBOT
👋 Welcome to your new thread!
⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.
⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.
🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1217157274234257419
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
light dawnBOT
fickle vortex
nothing so far. before start the Sigma subcription, I'd like to know if I can run queries on the connected accounts data...
bleak hound
What type of connected accounts are you using?
fickle vortex
I am not sure the type of the connected account. I have a Stripe application in my website and some customers can connect their Stripe account via OAuth2.
light dawnBOT
bleak hound
Okay so let's align on what exactly you are doing to integrate our APIs and products since this is crucial information
fickle vortex
So I have read-only access to their data and I'd like to run Sigma queries against it.
normal goblet
👋 hopping in here - what we really need to know is what kind of connected accounts (standard, express, custom) you're working with
fickle vortex
ok, let me see if I can find that info in the developers dashboard
it is Standard
normal goblet
Okay, so what will matter here is whether or not you have platform controls enabled for these standard accounts (https://docs.stripe.com/connect/platform-controls-for-standard-accounts). If you do have it enabled, then you should be able to use it with sigma https://docs.stripe.com/stripe-data/query-connect-data
normal goblet
😦 yeah unfortunately that means you wouldn't be able to access those connected acounts through your platform's sigma data
fickle vortex
so let me describe the problem we are facing in our product... we run a financial analysis using Stripe as datasource.
our current implementation uses the itemized balance report to run our analysis https://docs.stripe.com/reports/report-types/connect#schema-connected-account-balance-change-from-activity-itemized-1
the problem is that we need the recurring interval of each transaction, and that information isn't present in the report
We've tried a different solution like comparing the list of prices against each transaction amount, but that's innacurate.
normal goblet
You could try including that information as metadata and switching to a different report (like https://docs.stripe.com/reports/report-types/connect#schema-connected-account-balance-change-from-activity-itemized-2) that includes metadata
fickle vortex
in this report type, I see that I can get metadata from payment, refund and transfer. But does any of them include the recurring interval info?
normal goblet
The idea would be that you'd set whatever info you need - if you need the recurring interval info then you can update the payment intent to have that information as metadata
fickle vortex
the problem is that we don't have control over the payment intent of our customers
normal goblet
If you don't want to modify the payment intents of your customers at all then your options are pretty limited - have you considered using the API to list all payments?
fickle vortex
I've tried to list all invoices, but for a customer with 35k transactions (7 years history), it takes a long time to retrieve the data
I can run nearly 60 requests per second, but the API starts throttling them. after ~20 seconds retrieving the invoices, the API takes ~7 seconds to reply each request.
normal goblet
Unfortunately there really aren't very many other options - we don't have any specific report that would give you the recurring interval of a payment and sigma isn't an option for you because you don't have aplatform controls