ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Stripe の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにStripe から関連するレスポンスデータを返します。
CData SSIS Components for Stripe ストアドプロシージャ
| 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. |