ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Shopify の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにShopify から関連するレスポンスデータを返します。
CData Excel Add-In for Shopify ストアドプロシージャ
| Name | Description |
| AcceptCancellationRequest | Accepts a cancellation request sent to a fulfillment service for a fulfillment order. |
| AcceptFulfillmentRequest | Accepts a fulfillment request sent to a fulfillment service for a fulfillment order. |
| ApproveComment | Marks a blog comment as approved, making it publicly visible on the storefront. |
| AssignDefaultAddress | Assigns a customer's selected address as the default shipping and billing address in their profile. |
| CalculateRefund | Calculates refund amounts for order line items and shipping, returning a breakdown of refundable totals. |
| ChangeSpamStatus | Updates a comment's spam status, toggling between spam and non-spam classification. |
| CompleteDraftOrder | Finalizes a draft order and converts it into a completed order ready for checkout and fulfillment. |
| CreateAccountActivationUrl | Generates a secure URL that allows a customer to activate their online store account. |
| GetOAuthAccessToken | Gets an authentication token from Shopify. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RejectCancellationRequest | Rejects a cancellation request sent to a fulfillment service for a fulfillment order. |
| RejectFulfillmentRequest | Rejects a fulfillment request sent to a fulfillment service for a fulfillment order. |
| RestoreComment | Restores a comment that was previously deleted or marked as removed. |
| SendCancellationRequest | Sends a cancellation request to the fulfillment service of a fulfillment order. |
| SendFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| SendInvite | Sends an account invitation email to a customer, with optional custom messaging. |
| SendInvoice | Emails a draft order invoice to a customer, allowing them to complete payment via checkout. |
| UpdateQuantity | Updates available inventory quantities for a specific product variant at a designated location. |