Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Stripe.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Stripe, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Stripe Stored Procedures
| Name | Description |
| AcceptQuote | To accept the quote and generate the Invoice for the accepted quote. |
| ApproveReview | Approves a Review object, closing it and removing it from the list of reviews. |
| AttachPaymentMethodToCustomer | Attaches a PaymentMethod object to a Customer. It is not applicable for future payments. |
| CancelPaymentIntent | To cancel a PaymentIntent. The Status of PaymentIntent that you want to cancel should be one of the following: requires_payment_method, requires_capture, requires_confirmation, requires_action, processing. |
| CancelQuote | To cancel the drafted quote. |
| CancelSubscription | Cancels a customers subscription immediately. |
| CapturePaymentIntent | To capture the funds of an existing uncaptured PaymentIntent when its status is requires_capture. |
| ConfirmPaymentIntent | To confirm that your customer intends to pay with current or provided payment method. |
| DeleteCustomerDiscount | Removes the currently applied discount on a customer. |
| DeleteSubscriptionDiscount | Removes the currently applied discount on a subscription. |
| DetachPaymentMethodFromCustomer | Detaches a PaymentMethod object from a Customer. After a PaymentMethod is detached, it can no longer be used for a payment or re-attached to a Customer. |
| DownloadFile | Download the file in the Stripe account. |
| DownloadQuote | Download the PDF for a finalized quote. |
| FinalizeInvoice | To finalize a draft invoice manually. |
| FinalizeQuote | To finalize the drafted quote. |
| GetOAuthAccessToken | Gets the OAuth access token from Stripe. |
| GetOAuthAuthorizationURL | Gets the Stripe authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to Stripe. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various Stripe services. |
| ResumeSubscription | Initiates resumption of a paused subscription, optionally resetting the billing cycle anchor and creating prorations |
| UploadFile | To upload a file to Stripe. |
| VoidCreditNotes | To mark the credit note as void |
| VoidInvoice | To mark a finalized invoice as void. |