lyngall | Stripe Developers | Page 1

autumn starBOT Aug 30, 2023, 2:40 PM

#

fathom mesa Aug 30, 2023, 2:40 PM

#

Unfortunately I don't think the API can show this. Its list subscriptions endpoint shows the current state for subscriptions. I will think on this and get back to you

#

Are you looking for specifically an API solution for this? Not sure if there are other options but I will look

tawdry loom Aug 30, 2023, 2:42 PM

#

Any solution would work for now, i am aware that via API it's not possible :/

fathom mesa Aug 30, 2023, 2:50 PM

#

So there is a chart like this in the dashboard. You can narrow down to a date range so that may help you there so it may be a bit frictionful to get visibility here https://dashboard.stripe.com/billing

Stripe Login | Sign in to the Stripe Dashboard

Sign in to the Stripe Dashboard to manage business payments and operations in your account. Manage payments and refunds, respond to disputes and more.

#

Also you could pull subscription data with the API and Sigma and use their stard_date and canceled_at timestamps to see which were active during that date range. Obviously that is more hands on but that could give you historical data

#

Otherwise going forward it may be easiest to run a job daily that pulls this info and records it in your DB

#lyngall