Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT operations with ShipStation.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from ShipStation, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for ShipStation Stored Procedures
| 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. |