#jarcher0679_best-practices
teal knotBOT
👋 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/1399464882616664186
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
rain jewel
I was thinking of just polling the api once per day, for each account. but now we have 2k+ accounts, need to space those out so that we don't hit the API rate limit
cerulean canyon
Hello
Have you looked into any Reporting APIs?
This isn't something my team would know a ton about but you could try looking up a Balance Report and see if it includes a balance transaction along with the activity that changed the balance - https://docs.stripe.com/reports/balance#available-columns
That would be a better option as you can schedule those to run per day
and it won't affect your rate limits either
Based on the schema here - https://docs.stripe.com/reports/report-types/balance#schema-balance-change-from-activity-itemized-6
I think this should work as we do include balance_transaction_id column in Reports
rain jewel
got it. So the recommendation is to use the api to download reports per account on some cron. then dump that into our own db
cerulean canyon
Correct
rain jewel
thank you @cerulean canyon 👍