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 | Accepts the quote and generates 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 | Cancels 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 | Cancels the drafted quote. |
| CancelSubscription | Cancels a customer's subscription immediately. |
| CapturePaymentIntent | Captures the funds of an existing uncaptured PaymentIntent when its status is requires_capture. |
| ConfirmPaymentIntent | Confirms that your customer intends to pay with current or provided payment method. |
| CreateBillingMeterEvent | Creates a billing meter event. |
| 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 | Downloads the file in the Stripe account. |
| DownloadQuote | Downloads the PDF for a finalized quote. |
| FinalizeInvoice | Finalizes a draft invoice manually. |
| FinalizeQuote | Finalizes 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 | Uploads a file to Stripe. |
| VoidCreditNotes | Marks the credit note as void. |
| VoidInvoice | Marks a finalized invoice as void. |