todordvv_invoice-paidoutofband | Stripe Developers | Page 1

velvet oracleBOT Oct 9, 2024, 5:30 PM

#

👋 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/1293626602223177761

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

Below are links to other discussions we've had with you in the past week in case you want to review that information. If your question is related to one of these previous discussions, please provide a comprehensive summary of the current state and what you need help with now. We help many users simultaneously, so a summary allows us to resolve your issue as soon as possible.

todordvv_docs, 1 hour ago, 21 messages
todordvv_docs, 3 hours ago, 119 messages

#

fresh pond Oct 9, 2024, 5:30 PM

#

I am sorry I have made multiple calls to https://docs.stripe.com/api/invoices/list?lang=php but can't find the requests in the logs question in the dashboard so I can't provide a req_id

winter panther Oct 9, 2024, 5:32 PM

#

@fresh pond there isn't a filter for it unfortunately. So you'll have to list all Invoices and check if it has https://docs.stripe.com/api/invoices/object#invoice_object-paid_out_of_band true or not

#

todordvv_invoice-paidoutofband

fresh pond Oct 9, 2024, 5:33 PM

#

ah, I see... the issue with that is that there's a limit of 100 per request right

#

so we might have to do multiple requests to get all the invoices from a certain period (if it's a busy period, but I guess it is what it is).

#

it's weird it's not listing those under reports API csv file

#

since they are being marked as paid

winter panther Oct 9, 2024, 5:38 PM

#

yeah you could also use Sigma for this otherwise

fresh pond Oct 9, 2024, 5:38 PM

#

sigma?

winter panther Oct 9, 2024, 5:38 PM

#

https://stripe.com/sigma

fresh pond Oct 9, 2024, 5:39 PM

#

this does look cool but is there a connector that can be used via PHP or rest?

#

and from what I can see the reporting api apparently already uses this in the background - it uses the same report type values

#

https://docs.stripe.com/stripe-data/access-data-in-dashboard

winter panther Oct 9, 2024, 5:43 PM

#

Sigma does have the column paid_out_of_band in the invoices table. And yes we have https://docs.stripe.com/stripe-data/schedule-queries that lets you export the data in PHP for example

fresh pond Oct 9, 2024, 5:52 PM

#

okay good to know

#

do we have sigma in our enterprise plan or is it an addon?

winter panther Oct 9, 2024, 5:53 PM

#

Not sure, I don't know much about pricing. I'd recommend asking our support team for help on this: https://support.stripe.com/contact

#todordvv_invoice-paidoutofband