Returns the rate details for the specified rate.

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.

• Id supports the following operator: =.

Note: Id is required in order to query Rates. For example, the following query is processed server side:

SELECT * FROM Rates WHERE Id = 'se-28529731'

Columns

Name	Type	References	Description
Id [KEY]	String		A string that uniquely identifies the rate.
RateType	String		The type of rate.
CarrierId	String	Carriers.Id	A string that uniquely identifies the carrier.
CarrierCode	String		A shipping carrier, such as fedex, dhl_express, stamps_com, etc.
CarrierNickname	String		The nickname for the carrier account.
CarrierFriendlyName	String		The friendly name of the carrier.
ServiceCode	String		A carrier service, such as usps_first_class_mail, fedex_ground, etc.
ServiceType	String		The service type for the rate.
PackageType	String		The package type for the rate.
Zone	Integer		The shipping zone for the rate.
DeliveryDays	Integer		The estimated number of days to delivery.
CarrierDeliveryDays	Integer		The carrier's delivery days estimate.
GuaranteedService	Boolean		Indicates whether the delivery date is guaranteed.
EstimatedDeliveryDate	Datetime		The estimated delivery date.
ShipDate	Datetime		The ship date for the rate estimate.
NegotiatedRate	Boolean		Indicates whether the rate is a negotiated rate.
Trackable	Boolean		Indicates whether the shipment is trackable at this service level.
ValidationStatus	String		The validation status of the rate.
ShippingAmountCurrency	String		The currency of the shipping cost.
ShippingAmount	Decimal		The shipping cost amount.
InsuranceAmountCurrency	String		The currency of the insurance cost.
InsuranceAmount	Decimal		The insurance cost amount.
ConfirmationAmountCurrency	String		The currency of the confirmation cost.
ConfirmationAmount	Decimal		The confirmation cost amount.
OtherAmountCurrency	String		The currency of the other fees.
OtherAmount	Decimal		The other fees amount.
RequestedComparisonAmountCurrency	String		The currency of the requested comparison amount.
RequestedComparisonAmount	Decimal		The requested comparison amount.
TaxAmountCurrency	String		The currency of the tax amount.
TaxAmount	Decimal		The tax amount.
WarningMessages	String		Warning messages returned with the rate.
ErrorMessages	String		Error messages returned with the rate.
RateDetails	String		A breakdown of individual charges that make up this rate.