UnyteBI - Invoice Items | Stripe Developers | Page 1

tranquil cobalt Apr 28, 2022, 6:06 PM

#

Hi 👋

#

Do you have the ID of the invoice?

autumn olive Apr 28, 2022, 6:14 PM

#

Yes I have the ID of the invoice. So I tried joining the invoice table with the coupons table, but this invoice (of the screenshot) is not in the query. I think it's because the coupon is being applied against the invoice line item?

tranquil cobalt Apr 28, 2022, 6:18 PM

#

Can you share the ID of the invoice (sorry)

autumn olive Apr 28, 2022, 6:28 PM

#

Yup one second

#

in_1KaiPIJeuviw0nusEN6PotlB

tranquil cobalt Apr 28, 2022, 6:31 PM

#

Okay and what happens when you try to retrieve that via the API?

autumn olive Apr 28, 2022, 6:35 PM

#

I get null values in the discount fields

#

Acatually sorry let me send you a screenshot, I do values....

#

tranquil cobalt Apr 28, 2022, 6:39 PM

#

Okay that is because you need to Expand the request. If you are going through the API that is

#

WE call that out here: https://stripe.com/docs/api/invoices/line_item?lang=dotnet#invoice_line_item_object-discounts

Stripe API reference – The (Invoice) Line Item object – .NET

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

autumn olive Apr 28, 2022, 6:44 PM

#

Ah okay thanks! this was really helpfyl!

#

👍

tranquil cobalt Apr 28, 2022, 6:44 PM

#

Happy to help 🙂

#UnyteBI - Invoice Items