Sadeed

[honest light]

Can you share the ID (req_xxx) of the failing API request? https://support.stripe.com/questions/finding-the-id-for-an-api-request

[mossy tinsel]

Sure gimme a sec

[honest light]

I think the issue is that the list endpoint doesn't return cancelled subscriptions by default

So you'd need to pass the status parameter too

By default, returns a list of subscriptions that have not been canceled. In order to list canceled subscriptions, specify status=canceled.

[mossy tinsel]

req_oy02Lg0aw6lApo

okay

that works

thanks

what if I want both cancelled and active

@honest light

[honest light]

You'd need to use Search API: https://stripe.com/docs/search#query-fields-for-subscriptions

But that doesn't support customer 😦

[mossy tinsel]

Yea...., Maybe there is some other way of doing this.
I am trying to sync users with cancelled subscriptions in my db with stripe by checking if their last subscription was cancelled and they still have time left on that cancelled subscription.

Now if i do it using only cancelled subscriptions I wouldn't know if they have an ongoing active subscription

Which would break more things

[honest light]

Why would you not just track state async via a webhook?

[mossy tinsel]

This is for already existing users, we moved to another platform and cancelled subscriptions were overlooked when migrating data

So I have to use a script to fix that

[honest light]

I guess you'll need to query the API for the data you can get, and then filter in your code for the additional parameter you can't pass

[mossy tinsel]

Yea, i guess that is the only way