EndPoint Send an Invoice For Manual Payment
Name
send_invoice
Description
Send an Invoice For Manual Payment [API reference]
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
Id | Invoice Id | YES | Send an invoice for the Invoice Id. |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
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 |
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:
Send an Invoice For Manual Payment using API Source
Stripe
Send an Invoice For Manual Payment

Send an Invoice For Manual Payment using API Destination
Stripe
Send an Invoice For Manual Payment
