Stripe Connector
Documentation
Version: 2
Documentation

EndPoint List All Invoices


Name

get_invoices

Description

You can list all invoices, or list the invoices for a specific customer. The invoices are returned sorted by creation date, with the most recently created invoices appearing first. [API Help]

Parameters

Parameter Label Required Options Description
customer Customer Id NO Only return invoices for the customer specified by this customer Id.
status Status (draft or open or paid or uncollectible or void) NO
Option Value
draft draft
open open
paid paid
uncollectible uncollectible
void void
The status of the invoice, one of draft, open, paid, uncollectible, or void
subscription Subscription Id NO Only return invoices for the subscription specified by this subscription Id.
collection_method Collection method (charge_automatically or send_invoice) NO
Option Value
charge_automatically charge_automatically
send_invoice. send_invoice.
The collection method of the invoice to retrieve. Either charge_automatically or send_invoice.
created_gt Created later than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the created field is greater than this value.
created_gte Created on or later than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the created field is greater than or equal to this value.
created_lt Created earlier than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the created field is less than this value.
created_lte Created on or earlier than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the created field is less than or equal to this value.
due_date_gt Due Date later than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the Due Date field is greater than this value.
due_date_gte Due Date on or later than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the Due Date field is greater than or equal to this value.
due_date_lt Due Date earlier than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the Due Date field is less than this value.
due_date_lte Due Date on or earlier than (yyyy-MM-dd) NO
Option Value
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
2022-01-31 2022-01-31
2022-01-31 23:59:59 2022-01-31 23:59:59
Return results where the Due Date field is less than or equal to this value.

Output Columns

Label DataType Length Raw Description
Id DT_WSTR 255 False
Object DT_WSTR 100 False
AccountCountry DT_WSTR 100 False
AccountName DT_WSTR 1020 False
AccountTaxId DT_WSTR 1020 False
AmountDue DT_I8 0 False
AmountPaid DT_I8 0 False
AmountRemaining DT_I8 0 False
ApplicationFeeAmount DT_I8 0 False
AttemptCount DT_I8 0 False
Attempted DT_BOOL 0 False
AutoAdvance DT_BOOL 0 False
BillingReason DT_WSTR 1020 False
Charge DT_WSTR 255 False
CollectionMethod DT_WSTR 1020 False
Created DT_DBTIMESTAMP 0 False
Currency DT_WSTR 100 False
CustomFields DT_WSTR 1020 False
CustomerId DT_WSTR 1020 False
CustomerAddressCity DT_WSTR 1020 False
CustomerAddressCountry DT_WSTR 1020 False
CustomerAddressLine1 DT_WSTR 1020 False
CustomerAddressLine2 DT_WSTR 1020 False
CustomerAddressPostalCode DT_WSTR 1020 False
CustomerAddressState DT_WSTR 1020 False
CustomerEmail DT_WSTR 100 False
CustomerName DT_WSTR 100 False
CustomerPhone DT_WSTR 100 False
CustomerShippingAddressCity DT_WSTR 100 False
CustomerShippingAddressCountry DT_WSTR 100 False
CustomerShippingAddressLine1 DT_WSTR 100 False
CustomerShippingAddressLine2 DT_WSTR 100 False
CustomerShippingAddressPostalCode DT_WSTR 100 False
CustomerShippingAddressState DT_WSTR 100 False
CustomerShippingName DT_WSTR 100 False
CustomerShippingPhone DT_WSTR 100 False
TaxExempt DT_WSTR 100 False
TaxIDs DT_WSTR 1020 False
DefaultPaymentMethod DT_WSTR 1020 False
DefaultSource DT_WSTR 1020 False
DefaultTaxRates DT_WSTR 1000 False
Description DT_WSTR 1020 False
Discount DT_WSTR 1020 False
Discounts DT_WSTR 100 False
DueDate DT_DBTIMESTAMP 0 False
EndingBalance DT_I8 0 False
Footer DT_WSTR 1020 False
HostedInvoiceURL DT_WSTR 1020 False
InvoicePDF DT_WSTR 1020 False
LastFinalizationError DT_WSTR 1020 False
LinesObject DT_WSTR 100 False
LinesData DT_NTEXT 0 False
LinesHasMore DT_BOOL 0 False
LinesTotalCount DT_I8 0 False
LinesUrl DT_WSTR 1020 False
LiveMode DT_BOOL 0 False
NextPaymentAttempt DT_DBTIMESTAMP 0 False
Number DT_WSTR 1020 False
Paid DT_BOOL 0 False
PaymentIntent DT_WSTR 1020 False
PeriodEnd DT_DBTIMESTAMP 0 False
PeriodStart DT_DBTIMESTAMP 0 False
PostPaymentCreditNotesAmount DT_I8 0 False
PrepaymentCreditNotesAmount DT_I8 0 False
ReceiptNumber DT_WSTR 255 False
StartingBalance DT_I8 0 False
StatementDesctiption DT_WSTR 1020 False
Status DT_WSTR 100 False
StatusTransitionsFinalizedAt DT_DBTIMESTAMP 0 False
StatusTransitionsMarkedUncollectibleAt DT_DBTIMESTAMP 0 False
StatusTransitionsPaidAt DT_DBTIMESTAMP 0 False
StatusTransitionsVoidedAt DT_DBTIMESTAMP 0 False
SubscriptionId DT_WSTR 1020 False
Subtotal DT_I8 0 False
Tax DT_I8 0 False
Total DT_I8 0 False
TotalDiscountAmounts DT_WSTR 100 False
TotalTaxAmounts DT_WSTR 100 False
TransferData DT_WSTR 1020 False
WebhooksDeliveredAt DT_DBTIMESTAMP 0 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.