brilliantov-usage | Stripe Developers | Page 1

inner hull Nov 16, 2021, 1:09 PM

#

Yep you can definitely pull that info via the API https://stripe.com/docs/api/usage_records/subscription_item_summary_list

Stripe API reference – List all subscription item period summaries

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

#

Can you clarify on that first error?

#

Do you have a request ID (req_123) from when you saw that?

knotty venture Nov 16, 2021, 1:12 PM

#

yes, we just fucked up with usage_report in past periods, and tried to to report it again, but the invoice was already settled

inner hull Nov 16, 2021, 1:16 PM

#

And do you need help avoiding that error in future or is this just about listing the usage reports for a period?

knotty venture Nov 16, 2021, 1:16 PM

#

I know how to avoid this 🙂 cause in normal case it is not happening

#

now i just need to compare our periods while we was down with your periods

inner hull Nov 16, 2021, 1:20 PM

#

Good to hear!

#

Is the subscription item period summaries API call sufficient to get you the data for that?

knotty venture Nov 16, 2021, 1:35 PM

#

investigating

#

so it is method about one subscription

#

don't you have method about all subscriptions in one call?

#

the idea is to compare our normal usage with outstanding periods and resend only outstanding

#

@inner hull

inner hull Nov 16, 2021, 1:40 PM

#

Oh I see. Unfortunately I don't think you can do multiple lists of subscription items like that in one call.

#

Can you clarify what you mean by "outstanding" here?

knotty venture Nov 16, 2021, 1:46 PM

#

I have number of organizations and in normal periods we report for example quantity of 1000 across all subscriptions

#

but in some period we were down and not reported any usage, so it will have for example 0 quantity

#

that's outstanding period for me, maybe there is a better word for this

inner hull Nov 16, 2021, 1:48 PM

#

So you want to programmatically go back and see when quantity wasn't reported at all for anyone?

#

Is it unclear when the system was down or what got missed?

knotty venture Nov 16, 2021, 1:48 PM

#

yes, exactly. and compare it with our db

#

it is unclear what is missed

inner hull Nov 16, 2021, 1:53 PM

#

But you are sure it lines up with the periods for those subscriptions?

#

What info is in your DB? What is the disconnect in lining your DB up with our records from, say, that call?

knotty venture Nov 16, 2021, 1:58 PM

#

we have some usage in our DB, for example

sub_id, datetime, quantity
sub_123, 2021-11-05 02:00:00, 1

and this is completely consistent data

#

we need to compare it with usage reported to stripe, and if it is different - report it again

#

OR if there already were some invoices since faulty period report in current period

cinder wind Nov 16, 2021, 2:14 PM

#

Hey there 👋 stepping in and getting caught up on the thread.

#

The endpoint that Pompey mentioned earlier, is the best way to pull the usage records from the API. Here we focus on integration and API questions, so we're not as familiar with the reports. If you're looking for another approach, then I'd recommend reaching out to our support team with an explanation of your scenario so they can check if there is another option.
https://support.stripe.com/?contact=true

#brilliantov-usage