ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Shopify の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにShopify から関連するレスポンスデータを返します。

CData Excel Add-In for Shopify ストアドプロシージャ


Name	Description
AcceptCancellationRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
AcceptFulfillmentRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
ApproveComment	Approves a comment
AssignDefaultAddress	Assign a default address to a customer.
CalculateRefund	Calculates refund transactions based on line items and shipping.
ChangeSpamStatus	Changes spam status of a comment
CompleteDraftOrder	Complete a draft order.
CreateAccountActivationUrl	Creates an account activation URL for the specified customer.
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.
ListProduct	Create a product listing to publish a product to your app.
RejectCancellationRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
RejectFulfillmentRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
RestoreComment	Restores a previously removed comment
SendCancellationRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
SendFulfillmentRequest	Sends a fulfillment request to the fulfillment service of a fulfillment order.
SendInvite	Send a default or customized invite to a customer.
SendInvoice	Send a default or customized invoice to a customer.
UpdateQuantity	Update the available quantity of inventory items for a product variant in a specific location.