ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、ShipStation の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにShipStation から関連するレスポンスデータを返します。
CData ODBC Driver for ShipStation ストアドプロシージャ
| Name | Description |
| AddTagToOrder | Adds a tag to an order |
| AssignUserToOrder | Assigns a user to an order |
| CreateLabelForOrder | Creates a label for an Order |
| CreateLabelForShipment | Creates a label for a shipment |
| DeactivateStore | Deactivates a specified store |
| HoldOrder | This method will change the status of the given order to On Hold until the date specified or will change the status of the given order from On Hold to Awaiting Shipment |
| ReactivateStore | Reactivates the specified store. Note: stores are active by default |
| RefreshStore | Refreshes the specified store |
| RemoveTagFromOrder | Removes tag from an Order |
| RestoreOrder | This method will change the status of the given order from On Hold to Awaiting Shipment. This endpoint is used when a HoldUntil Date is attached to an order. |
| UnassignUserFromOrder | Unassigns a user from an order. |
| VoidShipmentLabel | Voids the specified label by shipmentId. |