Connector Improvement: Stripe Connector is missing object level fields for Price and Payment_Intent objects
Answered
Hi, I was noticing that the payment_intent table in FiveTran doesn't fully match the Stripe API docs for the payment_intent object. Specifically, the field "invoice_id" is missing from the payment intent, even though it is linked in the Stripe API docs.
In addition, the invoice line item object is missing the tax_amounts object (or the child table invoice_item_item_tax). This would provide the individual tax amounts that go into the total tax amount on the invoice in the invoice table. https://docs.stripe.com/api/invoices/line_item
In addition, the object "discounts" is missing from the invoice litem item table (or the child table for invoice_line_item_discounts). This is necessary if you want to see the discounts on individual invoice line items. https://docs.stripe.com/api/invoices/line_item
In addition, the field "tax_behavior" is missing from the Price object. This field is necessary if the tax_amounts object wasn't included, so you could decompose the total tax amount into proportional parts assigned to each invoice_line_item. https://docs.stripe.com/api/prices/object
If these FiveTran tables could be brought into sync with the Stripe API, it would be super helpful.
-
Official comment
Hi Bill,
Sadie from the Product team. Thanks for raising this request. I've added it to our backlog to add the invoice_id to the PAYMENT_INTENT table.
As for tax amounts and discounts, those can be found in the TAX_AMOUNT and DISCOUNT tables. Look for the `type` of the object you'd like to retrieve tax amounts or discounts for, e.g. TAX_AMOUNT.TYPE = 'invoice_line_item'.
Please reach out to our Support team if you have additional questions about tax amounts or discounts.
Best,
Sadie
Please sign in to leave a comment.
Comments
1 comment