CheckoutRateQuotes
Returns a checkout rate quote for the specified quote Id.
View-Specific Information
Select
The connector 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 connector.
- 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. |