taron_api | Stripe Developers | Page 1

fresh coyoteBOT Apr 18, 2024, 12:54 PM

#

👋 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/1230501718433730601

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

mighty trellisBOT Apr 18, 2024, 12:55 PM

#

mystic talon Apr 18, 2024, 12:55 PM

#

Hello

tough tapir Apr 18, 2024, 12:55 PM

#

Hi @mystic talon

mystic talon Apr 18, 2024, 12:55 PM

#

There is no API that returns this directly

#

You would either use the Reports API

#

Or you would need to list out your balance transactions

#

https://docs.stripe.com/reports/api is our docs on the Reports API

Run a report from the API

Access Stripe's financial reports programmatically to automate your reconciliation workflow.

tough tapir Apr 18, 2024, 12:56 PM

#

with the get list it is took a bit long time

mystic talon Apr 18, 2024, 12:56 PM

#

That will be the easiest way to get this calculation

mystic talon Apr 18, 2024, 12:57 PM

#

tough tapir with the get list it is took a bit long time

Yep you would need to do a lot of pagination and it likely will take a while

tough tapir Apr 18, 2024, 12:57 PM

#

I can get weekly/monthly and yearly reports?

#

I need to get weekly/monthly/yearly Revenue

mystic talon Apr 18, 2024, 12:59 PM

#

Yes you can indicate a start and end time with the Reports API: https://docs.stripe.com/reports/api#report-runs

tough tapir Apr 18, 2024, 12:59 PM

#

ok I see, interval_start and interval_end

#

and what about revenue

#

I will get it in response or I need to calculate it?

#

it will return report as a JSON?

mystic talon Apr 18, 2024, 1:01 PM

#

Pause and read through those docs please

#

Then you can ask further clarifying questions

#

It will answer a lot of what you are asking

tough tapir Apr 18, 2024, 1:02 PM

#

I noticed that it will be in url
"url": "https://files.stripe.com/v1/files/file_xs8vrJzC/contents",

mystic talon Apr 18, 2024, 1:06 PM

#

Correct, that will contain a CSV

tough tapir Apr 18, 2024, 1:07 PM

#

ok thank you for your support but I need JSON

mystic talon Apr 18, 2024, 1:10 PM

#

Yeah then you want to List Balance Transactions. I'd recommend caching the data on your end so you only have to retrieve a small portion each time you want this info

#taron_api