#harry_invoice-upcoming
strong karmaBOT
👋 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/1241153919758106694
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
snow tapir
You can use the Retrieve Upcoming Invoice API: https://docs.stripe.com/api/invoices/upcoming to preview the next Invoice on a Subscription
harry_invoice-upcoming
sorry I pressed the wrong button
strong karmaBOT
snow tapir
cc @steep thistle damn sorry I forgot to unlock too, what a day 😅
steep thistle
No worries, thanks
More specifically I'm trying to build a report using Data Pipeline
Are upcoming invoices available in the Data Pipeline tables?
Just trying to see if there's a way I can get the upcoming invoice estimated amount directly via the tables available from Data Pipeline
jade ruin
Let me dig a bit and see.
What are you using upcoming invoices in the Data Pipeline for? Like a revenue projection type thing? Or something else?
I think data availability varies a little bit from account to account, but I don't think Data Pipeline has anything in the schema for Upcoming Invoices. You can check here to be sure though: https://dashboard.stripe.com/stripe-schema
steep thistle
yup basically for forecasting is the use case
😦 yeah i didn't see anything in the schema for upcoming invoices either
we do have a number of tiered subscriptions so though it's possible derive the upcoming amount using the tables in the schema, it's not the easiest query to write
hence why i'm wondering if i can access the estimated amount directly somehow
jade ruin
Not that I know of. You can probably do something with the latest_invoice on each of the Subscription objects to get a sense for what the next Invoice will be: https://docs.stripe.com/api/subscriptions/object#subscription_object-latest_invoice, but obviously it doesn't account for any upgrades/downgrades that are pending