Endpoint

Mark an Invoice As Uncollectible

Name

mark_uncollectible_invoice

Description

Marking an invoice as uncollectible is useful for keeping track of bad debts that can be written off for accounting purposes. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Invoice Id	YES		Mark Uncollectible for the Invoice Id.

Output Columns

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

If the column you are looking for is missing, consider customizing Stripe Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

Required columns that you need to supply are bolded.

Examples

SSIS

Use Stripe Connector in API Source component to read data or in API Destination component to read/write data:

Mark an Invoice As Uncollectible using API Source

Stripe

Mark an Invoice As Uncollectible

SSIS API Source - Read from table or endpoint

Mark an Invoice As Uncollectible using API Destination

Stripe

Mark an Invoice As Uncollectible

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Mark an invoice as uncollectible

SELECT * FROM mark_uncollectible_invoice
WHERE Id = 'abcd-1234-id'

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Mark an invoice as uncollectible

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM mark_uncollectible_invoice
WHERE Id = ''abcd-1234-id''';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];