ストアドプロシージャ

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

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

CData ODBC Driver for Yahoo Shopping ストアドプロシージャ


Name	Description
CancelOrderCoupon	Cancels the coupon adaptation of the specified order information.
ChangeOrderStatus	Change the order status of the specified order.
ChangePaymentStatus	Renewal status update function for managing payment status of orders.
ChangeShipmentStatus	Shipment status update function for managing order delivery status.
GetAuthorizationStatus	Gets the authorization status of public key authentication.
GetOAuthAccessToken	Gets an authentication token from Yahoo Shopping.
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 auth token from this URL.
IssuePaymentNumber	Issue payment number for payment by buyer for mobile Suica, convenience store settlement (Seven Eleven), convenience store settlement (other), payment order at Paisy.
MoveItems	Move multiple items in one batch to another category. (It does not reflect the front).
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Yahoo Shopping.
SetItemDisplayPriority	Change display priorities of products under one store category at once. (It does not reflect the front).
SplitOrder	It provides the function of dividing one order into two orders.
SubmitItem	Individual product reflection