CheckoutRateQuotes
Returns a checkout rate quote for the specified quote Id.
View-Specific Information
Select
The add-in will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- QuoteId supports the following operator: =.
Note: QuoteId is required in order to query CheckoutRateQuotes. For example, the following query is processed server side:
SELECT * FROM CheckoutRateQuotes WHERE QuoteId = 'se-2345'
Columns
| Name | Type | References | Description |
| QuoteId [KEY] | String | The unique identifier of the rate quote. | |
| ConfigurationId | String | The unique identifier of the checkout rates configuration. | |
| OptionId | Integer | An integer that uniquely identifies the delivery option. | |
| OptionName | String | The display name of the delivery option. | |
| Type | String | The delivery option type. | |
| CarrierId | String |
Carriers.Id | A string that uniquely identifies the carrier. |
| ServiceCode | String | A carrier service, such as usps_first_class_mail, fedex_ground, etc. | |
| FinalAmount | Decimal | The price shown to the buyer after fees or fallbacks are applied. | |
| Currency | String | The currency of the final amount. | |
| EstimatedDeliveryDays | Integer | The estimated number of days in transit. | |
| EstimatedDeliveryDate | Datetime | The estimated delivery date. | |
| CreatedAt | Datetime | The date and time the quote was calculated. |