Robert-find-old-requests | Stripe Developers | Page 1

rustic ledgeBOT Jan 19, 2023, 1:43 PM

#

bleak trench Jan 19, 2023, 1:46 PM

#

👋 Hi there, Happy to help!
You can try filtering all the API requests related to a resourceId via your dashboard?
https://dashboard.stripe.com/logs?object=sub_1234

carmine ridge Jan 19, 2023, 1:49 PM

#

Hey @bleak trench 👋
That looks promising!

Any way we can do it via API call as well? (We're using Ruby version of the API if that matters).

bleak trench Jan 19, 2023, 1:54 PM

#

When using APIs you can filter just by event type but not with resource Id unfortunately.
https://stripe.com/docs/api/events/list#list_events-type

carmine ridge Jan 19, 2023, 1:55 PM

#

I see.

List events, going back up to 30 days.
Stripe documentation says that there's access for up to 30 days back via API, while we need the data for the last 12 months.

How can we do that?

bleak trench Jan 19, 2023, 1:57 PM

#

Yes, there is a retentials of 30 days for events, that's why I suggest you to filter by request

carmine ridge Jan 19, 2023, 2:02 PM

#

Hm... Let me experiment with that and get back to you.
To clarify, do I understand correctly that if we filter the list by request in this manner:

Stripe::Event.list type: 'customer.subscription.updated'

it will fetch events going back as 12 months in the past (i.e. bypass 30 days limitation)?

bleak trench Jan 19, 2023, 2:03 PM

#

No, the event listing is limited to 30 days back up,
https://stripe.com/docs/api/events/list#:~:text=List events%2C going back up to 30 days

bleak trench Jan 19, 2023, 2:04 PM

#

bleak trench 👋 Hi there, Happy to help! You can try filtering all the API requests related ...

Meanwhile searching by request via the dashboard, you can go back more than 30 days, in the history

carmine ridge Jan 19, 2023, 2:05 PM

#

I see. Thanks for clarification. Unfortunately we have thousands of subscriptions, so searching through the dashboard wouldn't be an option.

Returning to the original question (and keeping in mind that the changes occurred in last 12 months):

We want to find out the date when Subscription was changed to new Product. How do we do that?

What approaches could we take to get this information in an automated manner?

heavy kayak Jan 19, 2023, 2:12 PM

#

Hi 👋 taking over as my teammate needs to step away. It's not easy to retrieve when a request was made to update a Subscription from the API, using the dashboard is going to be the better approach for that.

carmine ridge Jan 19, 2023, 2:12 PM

#

Hey @heavy kayak 👋

#

Thanks for stepping in.

Going through thousands of subscriptions manually via dashboard doesn't seem to be an option.

What other alternatives do we have?

heavy kayak Jan 19, 2023, 2:16 PM

#

There aren't any from our end. You could try going back through your outbound request logs to find the request that was made to update the Subscription (assuming it was made from an integration rather than manual action via the dashboard) and see when that request was made.

carmine ridge Jan 19, 2023, 2:20 PM

#

Hm... That's unfortunate.

I wonder if we can look at it under other angle somehow:

we have a Subscription id
we want to know when it was changed (within last 12 months)

Do I understand correctly that Stripe provides no way to do that via API?

heavy kayak Jan 19, 2023, 2:24 PM

#

That is correct.

carmine ridge Jan 19, 2023, 2:26 PM

#

Trying to think outside the box here and solve the actual problem...

We have a list of subscriptions that we need to check.
We could write a scraper on our end which will go through subscriptions one by one, open them via dashboard page, i.e.

GET https://dashboard.stripe.com/logs?object=sub_001
GET https://dashboard.stripe.com/logs?object=sub_002
GET https://dashboard.stripe.com/logs?object=sub_003

and fetch the date that way. It shouldn't be more than a couple of thousands requests.

Would that be treated as any violation from our end? i.e. would that cause any inconvenience to Stripe servers, could our IP get banned, etc?

heavy kayak Jan 19, 2023, 2:32 PM

#

I do not know off-hand.

carmine ridge Jan 19, 2023, 2:33 PM

#

Is there someone this could be transferred to?

Greatly appreciate prompt answers and willingness to help btw. 👍

heavy kayak Jan 19, 2023, 2:38 PM

#

Happy to help, but dashboard questions do get a bit outside of our wheelhouse as we focus on the API in this forum. Our Support team may have more insight on these matters:
https://support.stripe.com/?contact=true

Stripe: Help & Support

Find help and support for Stripe. Our support center provides answers on all types of situations, including account information, charges and refunds, and subscriptions information. Get your questions answered and find international support for Stripe.

carmine ridge Jan 19, 2023, 2:41 PM

#

Roger. The question seems to be of a "dev nature" as we're trying to fetch the data for thousands of entities, hence pinged here first. Will try my luck with https://support.stripe.com/?contact=true

If we don't get an answer there/won't come up with a solution in the nearest time - would it be ok to re-ask this question in the #dev-help again? Or would that violate any rules?

heavy kayak Jan 19, 2023, 2:46 PM

#

About the dashboard question or about using the API to retrieve changes made within the last year?

#

Robert-find-old-requests

carmine ridge Jan 19, 2023, 2:47 PM

#

Tbh. not sure.

About finding an automated way to figure out when a number of subscriptions changed their products (within last 12 months).

heavy kayak Jan 19, 2023, 2:50 PM

#

I would expect that my teammates would provide the same resposne.

carmine ridge Jan 19, 2023, 2:54 PM

#

I see...
In case there's no scenario on how this could be fetched via API and assuming dashboard does provide access to this data. Whom can I consult if scraping this data in automated manner from the dashboard (as suggested here) #1065627009461518386 message violate any Stripe rules?

Is Support team on https://support.stripe.com/?contact=true the best contact to reach?
Also - what topic would you suggest to pick up "API Integration", "Subscriptions & Invoices" or "Other"?

Stripe: Help & Support

Find help and support for Stripe. Our support center provides answers on all types of situations, including account information, charges and refunds, and subscriptions information. Get your questions answered and find international support for Stripe.

heavy kayak Jan 19, 2023, 2:59 PM

#

Yes, and "Other" seems like it would be the best fit.

#Robert-find-old-requests