OrderShippingLines
Retrieve shipping lines attached to orders.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderShippingLines WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| CarrierIdentifier | String | A reference to the carrier service that provided the rate. Present when the rate was computed by a third-party carrier service. | |
| Title | String | Returns the title of the shipping line. | |
| Code | String | A reference to the shipping method. | |
| Custom | Bool | Whether the shipping line is custom or not. | |
| DeliveryCategory | String | The general classification of the delivery method. | |
| IsRemoved | Bool | Whether the shipping line has been removed. | |
| Phone | String | The phone number at the shipping address. | |
| ShippingRateHandle | String | A unique identifier for the shipping rate. The format can change without notice and isn't meant to be shown to users. | |
| Source | String | Returns the rate source for the shipping line. | |
| CurrentDiscountedPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| CurrentDiscountedPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| CurrentDiscountedPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| CurrentDiscountedPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| DiscountedPriceAmount | Decimal | Decimal money amount. | |
| DiscountedPriceCurrencyCode | String | Currency of the money. | |
| DiscountedPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| DiscountedPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| DiscountedPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| OriginalPriceAmount | Decimal | Decimal money amount. | |
| OriginalPriceCurrencyCode | String | Currency of the money. | |
| OriginalPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| OriginalPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| OriginalPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| OriginalPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| RequestedFulfillmentServiceId | String | The ID of the fulfillment service. | |
| OrderId | String |
Orders.Id | A globally-unique ID. |
| TaxLines | String | A list of tax line objects, each of which details a tax applicable to this shipping line. |